linq to sql.
linq to sql 如何实现 sql 中左连接的效果
[解决办法]
参考
[解决办法]
var leftjoin = from p in ctx.Products
join c in ctx.Categories
on p.CategoryID equals c.CategoryID
into pro
from x in pro.DefaultIfEmpty()
select p.ProductName;
对应SQL：
SELECT COUNT(*) AS [value]
FROM [dbo].[Products] AS [t0]
LEFT OUTER JOIN [dbo].[Categories] AS [t1] ON [t0].[CategoryID] = ([t1].[CategoryID])
[解决办法]
UP
[解决办法]
up
[解决办法]
join
http://topic.csdn.net/u/20091108/00/ce4dd3fe-8498-419a-87d3-f9bc80644578.html
