问如何将包含内循环联接的SQL查询转换为LINQ？

EN

SELECT
    b.tm_runManagerID,
    b.testName,
    b.startDate,
    b.endDate,
    SUM( CASE WHEN c.testPass = 1 THEN 1 ELSE 0 END) AS passNumber,
    SUM( CASE WHEN c.testPass = 0 THEN 1 ELSE 0 END) AS failNumber,
    SUM(1) AS totalNumber,
    b.status
FROM dbo.tm_actionManager a WITH (NOLOCK)
    INNER LOOP JOIN [tm_runManager] b WITH (NOLOCK) ON a.tm_runManagerID = b.tm_runManagerID
    LEFT OUTER JOIN dbo.tm_testResult c WITH (NOLOCK) 
    on a.tm_actionManagerID = c.tm_actionManagerID AND c.nodeCompared = 'overallresult'
    WHERE   a.tm_runManagerID IN (SELECT tm_runManagerID FROM dbo.tm_runManager (NOLOCK) WHERE isActive = 1)
    GROUP BY b.tm_runManagerID,b.testName,b.startDate,b.endDate,b.status
    ORDER BY b.tm_runManagerID DESC