Hello Folks,
I want to convert the below SQL query to LINQ
SELECT AVG(NF.Rating),U.userId, U.UserName,U.FirstName, U.LastName From Users U
LEFT JOIN UserRoles UR ON U.UserId = UR.UserId
LEFT JOIN ROLES R ON UR.RoleId = R.RoleId
LEFT JOIN NutritionistFeedbacks NF ON U.UserId = NF.NutritionistId
WHERE R.NormalizedName = 'NUTRITIONIST'
GROUP BY U.userId, U.UserName,U.FirstName, U.LastName, NF.NutritionistId