Как преобразовать приведенный ниже SQL-запрос в LINQ C#? Нужно ли мне разделить запрос на несколько запросов? какой подх ⇐ C#

[Anonymous]

SELECT DISTINCT
NULL AS encounterFlagId, AccountFlagID,
CASE
WHEN ((SELECT COUNT(*)
FROM [APP].[AFPTable] afp
LEFT JOIN APP.PTable p ON afp.ProjectID= p.ProjectID AND p.Active = 1
WHERE afp.AccountFlagID = af.AccountFlagId
AND afp.Active = 1
AND p.ThroughDate IS NULL
AND ProjectTypeID IN (SELECT ProjectTypeID
FROM APP.PTableType
WHERE AccountWorkable = 1)) >=
(SELECT COUNT(*)
FROM APP.PTable p
WHERE p.Active = 1
AND p.ThroughDate IS NULL
AND ProjectTypeID IN (SELECT ProjectTypeID
FROM APP.PTableType
WHERE AccountWorkable = 1)))
THEN 'ALL'
ELSE STUFF((SELECT ',' + CAST(APP.ufn_GetAbbre(p.Description, 1) AS varchar(300))
FROM [APP].[AFPTable] afp
LEFT JOIN APP.PTable p ON afp.ProjectID = p.ProjectID AND p.Active = 1
WHERE afp.AccountFlagID = af.AccountFlagId
AND afp.Active = 1
AND p.ThroughDate IS NULL
AND ProjectTypeID IN (SELECT ProjectTypeID
FROM APP.PTableType
WHERE AccountWorkable = 1)
FOR XML PATH('')), 1, 1, '') END AS Projects
FROM [APP].[AFPTable] af


Подробнее здесь: https://stackoverflow.com/questions/790 ... y-into-mul