Obtaining multiple fields with LINQ group statement

Question

I'm using the following grouping within my LINQ statement.

I have figured out how to obtain the maximum date from the 'notes' table, however am struggling to find an efficient way to find the 'NoteText' property of the same record (highlighted with ???? in both places)

group new { t1, notes } by new
{
    t1.Opportunity_Title
} into g

let latestNoteDate = g.Max(uh => uh.notes.Date)
let latestNote = g.Max(uh => uh.notes.NoteText) < needs to be latest note for record above ^

select new PipelineViewModel
{
    LastNoteDate = latestNoteDate,
    LastNote = latestNote,  ????
}).Take(howMany);

You should try this one http://stackoverflow.com/questions/8724719/group-multiple-tables-in-linq — manav inder, May 10 '12 at 18:27

Magnus · Accepted Answer · 2012-05-11T11:12:39.420

2

Perhaps like this:

let latestNote = latestNoteDate == null ? null : 
                 g.First(x => x.notes.Date == latestNoteDate).NoteText

edited May 11 '12 at 11:12

answered May 10 '12 at 15:52

Magnus

45,362
8
80
118

If you are not checking for `null` don't use `FirstOrDefault`, use `First` instead. – Daniel Hilgarth May 11 '12 at 09:39

Obtaining multiple fields with LINQ group statement

1 Answers1