select Max(tblEmailList.name),count(tblEmailRecipientList.ListId) from tblEmailList join tblEmailRecipientList on tblEmailRecipientList.ListId = tblEmailList.ListId group by tblEmailRecipientList.ListId
var result = from p in context.tblEmailRecipientList join c in context.tblEmailList on p.ListId equals c.ListId group p by p.ListId into temp select new { TotalCount = temp.Count(), MaxName = temp.Max(m => m.name) };
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)