我有以下SQL查询语句,希望将其转换为LINQ。我想使用子查询或LINQ的include
语法,而不想使用join
:
SELECT Count(*) AS CountOfRecs
FROM tblAcc a
INNER JOIN tblAccOwner o ON
a.[Creditor Registry ID] = o.[Registry ID] AND
a.[Account No] = a.[Account No]
WHERE
(a.[Account Owner ID] = 731752693037116688) AND
a.[Account Type] NOT IN ('CA00', 'CA01', 'CA03', 'CA04', 'CA02',
'PA00', 'PA01', 'PA02', 'PA03', 'PA04')) AND
(DATEDIFF(mm, a.[State Change Date], GETDATE()) <= 4 OR
a.[State Change Date] IS NULL AND
(a.[Account Type] IN ('OD','CL00','PL00') OR a.[Account Type] LIKE '%hala%'))