Linq Query according to companyID

var result=(from c in db.Cases join p in db.Payer on c.PayerID equals p.PayerID group new(c,p) by new {c.CompanyId} into g select new {g.PayerName,g.TotalCollection}).ToList(); Change the code according to the requirement. Thanks.