如何翻译SQL外部应用于LINQ

Question

我遇到了试图将此SQL语句与外部申请转换为Linq的问题。我已经阅读并尝试了很多示例，没有运气可以工作。有人可以告诉我一个如何将其写入LINQ语句的示例吗？

SELECT 
    [P].[BandID],
    [P].[PitchID],
    [P].[PitchName],
    [PRO].[PitchProcessID],
    [PRO].[ProcessDescription],
    [PRO].[IsHighVoltage],
    [TRA].[EmployeeID],
    [TRA].[TrainingID],
    [TRA].[Score]
FROM 
    [dbo].[vwPitch] AS [P]
    OUTER APPLY(SELECT 
                    [PP].[PitchProcessID],
                    [PP].[IsHighVoltage],
                    [PP].[ProcessName] + ' - ' 
                  + [PP].[ProcessDescription] AS [ProcessDescription]
                FROM 
                    [dbo].[vwPitchProcess] AS [PP]
                WHERE
                     [PP].[PitchID] = [P].[PitchID]) AS [PRO]
    OUTER APPLY(SELECT 
                    [T].[TrainingID],
                    [T].[EmployeeID],
                    [E].[FLName],
                    [T].[Score]
                FROM
                    [dbo].[TrainingScore] AS [T]
                    LEFT OUTER JOIN [dbo].[vwEmployee] 
                        AS [E] ON [T].[EmployeeID] = [E].[EmployeeID]
                WHERE
                    [T].[PitchProcessID] = [PRO].[PitchProcessID] 
                        AND [T].[EmployeeID] = 123456) AS [TRA]
WHERE
    [P].[BandID] = 34;