Home / Questions / 337013
Accepted
carallot
Asked: 2020-03-15 01:33:51 +0800 CST 2020-03-15 01:33:51 +0800 CST

Group by in LINQ

  • 772

I am practicing with LINQ in C# and SQL SERVER and I wanted to write this query in LINQ:

SELECT Employees.FirstName, COUNT(Orders.OrderID) AS Orders
FROM  Employees INNER JOIN
Orders ON Employees.EmployeeID = Orders.EmployeeID
GROUP BY Employees.FirstName

But I am not able, neither in from format nor with lambda expression, can you give me a hand please?

c#

1 Answers

  1. Best Answer

    I leave you the consultation and the Microsoft doc where you can search for more.

    https://docs.microsoft.com/en-us/dotnet/csharp/linq/group-query-results

    var collection = from e in Employess
                 join o in Orders on e.EmployeeID equals o.EmployeeID
                 group e by e.FirstName into Empleados
                 select Empleados.
    • 1