0

How can I write this query in lambda form?

var result = from email in emails
             join relation in relations on email.Id equals relation.EmailId into g
             join contact in contacts on g.Max(x => x.ContactId) equals contact.Id
             select new MyRowModel
             {
                 Id = email.Id,
                 LastName = contact.LastName,
                 FirstName = contact.FirstName,
                 SentOn = email.SentDate,
                 Subject = email.Subject
             };
juharr
  • 31,741
  • 4
  • 58
  • 93
Muris
  • 158
  • 8

0 Answers0