>>>>>Thanks. I found that using Reflection I was able to have my ExcelWrapper SaveLinq Of T. Turned out easier than I thought.
>>>>>
>>>>>Slightly off topic and as Cetin pointed out to me, I should make use of the relationships so my Linq now looks like this:
>>>>>
>>>>> 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);
>>>>> }
>>>>> }
>>>>> }
>>>>>>>>>>
>>>>>This now works fine. I am a little bit worried about this though:
>>>>>
>>>>>
>>>>> RS_Type = t.TransactionHeader.RSTransactions.FirstOrDefault().RSTransactionType.Description ?? "",
>>>>> RS_Document = t.TransactionHeader.RSTransactions.FirstOrDefault().Document ?? "",
>>>>>
>>>>>
>>>>>There is a 1 to M relation between TransactionHeaders and RSTransactions. But I'm really only interested in the first record, but I need two fields (Description and Document). The fact that I issue twice FirstOrDefault does not look right.
>>>>>
>>>>>Many thanks for your help.
>>>>
>>>>Don't see an easy way of avoiding the duplication but the code should be fine. But if TransactionHeader can have NO RSTransactions you will get an exception (ditto if no EMTransactions)
>>>
>>>Nono, it works fine. Coalescence ?? "" ?.
>>
>>That would work if (for example) RSTransactionType.Description was null. Won't if there is no first RSTransaction (i.e. if FirstOrDefault() returns null)
>
>Well ... Could it be that EF takes care of that ? I don't have a clue, but it does work.
Doesn't take care of if for me :-{
If FirstOrDefault() returns null than trying to access any property of the expected type throws a NullReferenceException
