How to use group by in LAMBDA

Question

I have a product table:

int id
string descricao
int quant

Here’s what I wanna do:

select descricao, sum(quant) from produtos group by descricao

How to make the above query in lambda?

Answer 1

There are two ways to do it:

Straight into the Linum

var result=from p in produto group p by p.descricao into g select new {descricao=g.Key,count=g.Sum(x=>x.quant)}

or with Extended Methods

var result = produto.GroupBy(x => x.descricao).Select(new { descricao = g.Key, count = g.Sum(x => x.quant) });