How to use group by in LAMBDA

Question

Navigation

#1 by (3 votes)

-1

I have a Products table:

int id
string descricao
int quant

I want to do the following:

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

How to do the above query in lambda ?

c#

asked by anonymous 24.04.2017 / 01:00

1 answer

score 3 · Accepted Answer

There are two ways to do it:

Direct on linq

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) });