[Solved] Convert SQL into LINQ and Lambda

by


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 Convert SQL into LINQ and Lambda