>>>> public static void GetTransactions() >>>> { >>>> using (var context = new PICSEntities(Config.model.SqlServer)) >>>> { >>>> var q = (from p in context.Parcels >>>> join t in context.TransactionDetails on p.Parcels_Id equals t.Parcels_Id >>>> select new >>>> { >>>> Parcels_Id = p.Parcels_Id, >>>> Goods = p.GoodsType.Description, >>>> Inventory = p.ParcelInventoryType.Description, >>>> RSReference = p.RSReference, >>>> Transaction_Nr = t.TransactionHeaders_Id, >>>> Transaction = t.TransactionHeader.TransactionType.Description, >>>> Date = t.TransactionHeader.TransactionDate, >>>> Weight = t.Weight, >>>> Amount = t.Amount, >>>> EM_Document = t.TransactionHeader.EMTransactions.FirstOrDefault().Document ?? "", >>>> EM_Count = t.TransactionHeader.EMTransactions.Count(), >>>> RS_Type = t.TransactionHeader.RSTransactions.FirstOrDefault().RSTransactionType.Description ?? "", >>>> RS_Document = t.TransactionHeader.RSTransactions.FirstOrDefault().Document ?? "", >>>> RS_Count = t.TransactionHeader.RSTransactions.Count() >>>> }).ToList(); >>>> using (var xl = new ExcelWrapper()) >>>> { >>>> xl.wb = xl.wbs.Add(); >>>> xl.ws = xl.wb.ActiveSheet; >>>> string filename = SequencedFilename.get(@"c:\docs\Parcels", $".xlsx"); >>>> xl.SaveLinq(q, filename); >>>> } >>>> } >>>> } >>>>>>>>
>>>> RS_Type = t.TransactionHeader.RSTransactions.FirstOrDefault().RSTransactionType.Description ?? "", >>>> RS_Document = t.TransactionHeader.RSTransactions.FirstOrDefault().Document ?? "", >>>>>>>>