تبدیل اسکریپت sql به دستورات linq

[z.gitaro]

این اسکریپت اگه به دستورات لینک تبدیل کنیم چجوری میشه

SELECT Code.NodeCode AS Code,
Code.NodeTitle As Title,
SUM(
CASE
WHEN ad.DocumentDate BETWEEN @FromDate AND @ToDate THEN adi.Debit ELSE 0 END
) Debit,
SUM(
CASE
WHEN ad.DocumentDate BETWEEN @FromDate AND @ToDate THEN adi.Credit ELSE 0 END
) Credit,
SUM(
CASE
WHEN ad.DocumentDate <@FromDate THEN adi.Debit ELSE 0 END
) LastDebit,
SUM(
CASE
WHEN ad.DocumentDate <@FromDate THEN adi.Credit ELSE 0 END
) LastCredit,
SUM(
CASE
WHEN ad.AccDocumentTypeId = 1 /*It's Important*/
AND ad.DocumentPeriodId = @PeriodId THEN adi.Debit ELSE 0 END
) FirstDebit,
SUM(
CASE
WHEN ad.AccDocumentTypeId = 1 /*It's Important*/
AND ad.DocumentPeriodId = @PeriodId THEN adi.Credit ELSE 0 END
) FirstCredit

FROM ACC.AccDocument ad
INNER JOIN ACC.AccDocumentItem adi ON adi.AccDocumentId = ad.AccDocumentID
INNER JOIN ACC.AccDocumentStatus ads ON ads.AccDocumentStatusID = ad.AccDocumentStatusId
INNER JOIN ACC.AccDocumentType adt ON adt.AccDocumentTypeID = ad.AccDocumentTypeId
INNER JOIN ACC.AccAccount aa ON aa.AccAccountID = adi.AccAccountId /*Moeen*/
INNER JOIN ACC.AccAccount aa2 ON aa2.AccAccountID = aa.ParentAccountId /*Kol*/
INNER JOIN ACC.AccAccount Code ON Code.AccAccountID = aa2.ParentAccountId /*Gorooh*/
WHERE ad.AccDocumentStatusId <> 0 /*It's Important*/
GROUP BY Code.NodeCode ,Code.NodeTitle
END