1、Join
1.1定義
image.png
1.2結(jié)果
image.png
2脑又、Left Join
2.1定義
var list = (from teacher in teachers
join student in students on teacher.TeacherId equals student.TeacherId into temp
from tt in temp.DefaultIfEmpty()
select new
{
teacherName = teacher.TeacherName,
studentName = tt?.StudentName
}).Dump("查詢語句");
2.2結(jié)果
image.png
