LINQ 的LEFT JOIN

LINQ的JOIN預設為INNER JOIN

可是另一個常用的LEFT JOIN要怎麼辦呢?

特地找了一下

from A in A_tab
join B in B_tab on A.code equals B.code into ps
from B in ps.DefaultIfEmpty()
select new { A.Name, B.item_Name }

他所產生的SQL同等於

SELECT [A_tab].[Name], [B_tab].[item_Name] 
FROM [A_tab] AS [A]
LEFT OUTER JOIN [B_tab] AS [B] ON [A].[code] = [B].[code]

在此紀錄