linq - 如何将此 SQL 查询转换为 LINQ to SQL

Question

我有以下 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%'))

Answer 1

您可以使用 LinqPad或 Linqer .我会尝试在 LinqPad 中转换它，但我必须拥有数据库。