LINQ Join

LINQ Join 对应关系数据库中的 INNER JOIN。

LEFT JOIN

1
2
3
4
from c in table0
join o in table1 on c.sno equals o.sno into ps
from o in ps.DefaultIfEmpty()
select new { c.name, o.number}

生成的 SQL：

1
2
3
SELECT [t0].[name], [t1].[number] AS [number] FROM [table0] AS [t0]
LEFT OUTER JOIN [table1] AS [t1]
ON ([t0].[sno]) = [t1].[sno]