Untitled

Linq 'first' issue

var FbtTotals = from ff in ExpenseItemFbtItems

                group ff by ff.ERLineID into g

                select new {

                    lineId = g.Key, totalAttendees = g.Sum(

                    m => m.Num_Attendees_In_Group),

                    attendeeTypes = g.Count(),

                    purposeDesc = g.FirstOrDefault(n => n.User_Purpose_Description)

                };

       

var FbtTotals = from ff in ExpenseItemFbtItems.AsEnumerable()

                            group ff by ff.ERLineID into g

             select new { lineId = g.Key, totalAttendees = g.Sum(m => m.Num_Attendees_In_Group), attendeeTypes = g.Count(), purposeDesc = g.FirstOrDefault(n => n.User_Purpose_Description) };