I was hoping one of you LINQ gurus could help me out with converting this SQL query into LINQ: SELECT TOP 5 ep . UserId , 1 + ISNULL ( rt . Total , 0 ) + ISNULL ( c . Total , 0 ) + ISNULL ( rc . Total , 0 ) AS Total FROM Participants ep LEFT JOIN ( SELECT RecruiterId AS UserId , COUNT (*) * 5 AS Total FROM Participants WHERE EId = 1 AND UserId != RecruiterId GROUP BY RecruiterId ) rt ON ep . UserId = rt . UserId LEFT JOIN ( SELECT UserId , SUM ( NetContribution ) * 100 * 10 AS Total FROM Contributions
Read More...