LINQ 多条件join on

var  tmp = from a in DT1.AsEnumerable()
join b in DT2.AsEnumerable()
on new { bm = a.Field<string>("编码"), lx = "类型" } equals new { bm = b.Field<string>("编码"), lx = b.Field<string>("类型") }
into ab
from c in ab.DefaultIfEmpty()
select new
{
编码 = a.Field<string>("编码"),
类型 = c == null ? "" : c.Field<string>("类型")
};
dt_结果 = tmp.MyCopyToDataTable();

 

posted @ 2018-09-22 23:15  我是四哥  阅读(3258)  评论(0编辑  收藏  举报