>>> 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 ?? "", >>>>>>