求助 结果集交叉查询

[Izanagi]

感谢帮助 !




如图所示, 现有结果集1和结果集2, 需要使用linq合并成一个结果集, 其中字段ABCD为数字类型.
请尽量使用1条linq查询出来

[骑着蜗牛去爬山]

var ary = (from t1 in listA from t2 in listB where t1.key == t2.key select new { key = t1.key, a = t1.a, b = t1.b, c = t2.c, d = t2.d }).Union( listA.Where(t => listB.Count(tt => tt.key == t.key) == 0).Select(t => new { t.key, a = t.a, b = t.b, c = 0, d = 0 }).Union(listB.Where(t => listA.Count(tt => tt.key == t.key) == 0).Select(t => new{key=t.key,a=0,b=0,c=t.c,d=t.d})));

[Izanagi]

引用 1 楼 hjywyj 的回复:

var ary = (from t1 in listA from t2 in listB where t1.key == t2.key select new { key = t1.key, a = t1.a, b = t1.b, c = t2.c, d = t2.d }).Union( listA.Where(t => listB.Cou……

大侠好身手! 感谢