linq 左连接

DataContext db = new DataContext ();
var query = from student in db.Student
join book in db.Book
on student.ID equals book.StudentID into temp
from bookDep in temp.DefaultIfEmpty()
select new
{
 sname=student.Name,
 bname=bookDep==null?"":bookDep.Name//这里主要第二个集合有可能为空。需要判断
};

https://www.cnblogs.com/xinjian/archive/2010/11/17/1879959.html