如何在EF中实现left join（左联接）查询

最新推荐文章于 2024-05-16 07:42:25 发布

weixin_30883271

最新推荐文章于 2024-05-16 07:42:25 发布

阅读量310

点赞数

原文链接：http://www.cnblogs.com/jasonlai2016/p/11283929.html

版权

var list = from a in context.Set<Table1>()
                               join b in context.Set<Table2>()
                               on a.Id equals b.Id into ab
                               from abi in ab.DefaultIfEmpty()
                               join c in context.Set<Table3>()
                               on a.SubId equals c.Id into ac
                               from aci in ac.DefaultIfEmpty()
                               where a.IsValid
                               select new OutXXXDto()
                               {
                                   Barcode = abi.Barcode,
                                   CustomerName = abi.CustomerName,
                                   HandlingTime = a.HandlingTime.ToString("yyyy-MM-dd hh:mm:ss"),
                                   Products = aci == null ? string.Empty : string.Join(",", aci.Sublist.Where(p => p.IsValid && p.Id.Equals(aci.Id)).Select(p => p.ProductName)),
                                   SubBarcode = aci == null ? string.Empty : aci.Barcode,
                               };