Hello Folks,
I am new in EF so I try the below SQL query convert into the EF (LINQ) expression but still, I am stuck so please guide me.
SELECT U.[Name],U.ContactNumber, COUNT(ordernUMBER) AS TotalOrder, SUM(O.TotalAmount) AS TotalAmount FROM ORDERS O INNER JOIN Users U ON O.CreatedBy = U.UserId GROUP BY U.[NAME], u.ContactNumber;