GroupBy with Sum in one query

[Сергей Кутузов]

How write this SQL query on BlTollkit LINQ?

select 

c.CategoryId, 

c.CategoryName, 

Count(*) as c1,

Sum(p.UnitsInStock) as s1

from Products p

inner join Categories c on p.CategoryID=c.CategoryID

where SupplierID = 1

group by c.CategoryId, c.CategoryName

[Сергей Кутузов]

var query =
                    from p in db.Product
                    where p.SupplierID==1
                    group p by p.Category.CategoryName
                    into g
                    select new
                        {
                            CategoryName = g.Key,
                            Count = g.Count(),
                            TotalStock = g.Sum(item=>item.UnitsInStock)
                        };

среда, 26 марта 2014 г., 9:33:44 UTC+11 пользователь Сергей Кутузов написал: