[Solved] Convert SQL into LINQ and Lambda
Maybe something like this: var result= ( from s in db.Stands join cp in db.ContractProducts on s.Id equals cp.StandId join p in db.Products on cp.ProductId equals p.Id where s.EventId == 1 group p by p.Description into g select new { Description=g.Key, TotalArea = g.Sum (x =>x.TotalArea) } ).ToList(); Where db is the linqdatacontext 1 solved … Read more