List<Class3> a = new List<Class3>();
a.Add(new Class3(){a=1,b=2,c=3});
a.Add(new Class3() { a = 1, b = 1, c = 3 });
a.Add(new Class3() { a = 2, b = 2, c = 232 });
a.Add(new Class3() { a = 3, b = 1, c = 32 });
a.Add(new Class3() { a = 4, b = 2, c = 22 });
a.Add(new Class3() { a = 4, b = 3, c = 22 });
List<Class4> b = new List<Class4>();
b.Add(new Class4 { a = 34, b = 1, f = "aaaaa" });
b.Add(new Class4 { a = 3434, b = 2, f = "bbbbb" });
b.Add(new Class4 { a = 34, b = 0, f = "aaaaa" });
var tem = from s in a
join s2 in b
on s.b equals s2.b into d
from s3 in d.DefaultIfEmpty()
select new Class5 { a = s.a, b = s.b, f = (s3 == null ? "" : s3.f) };
红字是关键部分,如果不用info,那select出的就是inner join的效果,不用DefaultIfEmpty()也是一样的
into就是把a的项目都放到了d上,并且这时,在 select 里面s2就会成null了
linq左联接
最新推荐文章于 2024-10-18 05:08:16 发布