如何在EF中实现left join(左联接)查询

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,
                               };

 

posted @ 2019-08-01 17:12  jasonlai2016  阅读(538)  评论(0编辑  收藏  举报