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.