Loading

How to write Group by in EF using Linq

Sri

6y928LINQ

Can anyone help me with the group by functionality using LINQ

Please post the exact example,

Thanks in Advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jay Krishna Reddy6y ago
Accepted answer
Here I am sharing you the example with SQL and LINQ

SQL Query;
SELECT Name, SUM(SALARY) AS SALARY FROM EMPLOYEE GROUP BY Name
queries respectively

Linq Query
var salarySum = from emp in employee.EMPLOYEEs

                             group emp by emp.Name into empg

                           select new { NAME = empg.Key, SALARY = empg.Sum(x => x.SALARY)};
Thanks,
Varun Setia6y ago
List 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(), }).ToList();