Linq: GroupBy, Sum and Count

I don’t understand where the first “result with sample data” is coming from, but the problem in the console app is that you’re using SelectMany to look at each item in each group.

I think you just want:

List<ResultLine> result = Lines
    .GroupBy(l => l.ProductCode)
    .Select(cl => new ResultLine
                ProductName = cl.First().Name,
                Quantity = cl.Count().ToString(),
                Price = cl.Sum(c => c.Price).ToString(),

The use of First() here to get the product name assumes that every product with the same product code has the same product name. As noted in comments, you could group by product name as well as product code, which will give the same results if the name is always the same for any given code, but apparently generates better SQL in EF.

I’d also suggest that you should change the Quantity and Price properties to be int and decimal types respectively – why use a string property for data which is clearly not textual?

Leave a Comment