Thanks Naomi,

I was hoping to get a better approach to the linq statement. I need this kind of statements frequently.


>>I have this linq statement:
>>
>>

>>            q = context.TransactionDetails
>>                .Where(t => t.Parcel.GoodsType.Description == "Rough")
>>                .Where(x => x.TransactionHeader.FiscalYears_Id == _FiscalYear_ID)
>>                .Where(t => t.TransactionHeader.TransactionType.Description == "Purchase")
>>                .GroupBy(t => 1)
>>                .Select(t => new { Weight = t.Sum(x => x.Weight), Amount = t.Sum(x => x.Amount) })
>>                .ToList();
>>

>> and then I use the results in
>>

>>            wt.AddRow("Purchases", q[0].Weight, q[0].Amount);
>>

>>
>>This breaks if there are no records selected, in which case I want to pass 0 for Weight and Amount to wt.AddRow.
>>
>>I'm looking for the proper way to do this, as I have 10's of these statements. The quick and dirty way would be wrapping them in try catch.
>>
>>Thanks for your help.
>
>
>Simple:
>
>>

>
>             if (q==null || q.Count==0)
>             {
>                wt.AddRow("Purchases", 0, 0);
>             }       
>else {
>>            wt.AddRow("Purchases",  q[0].Weight, q[0].Amount);
>}
>>