62,046
社区成员
发帖
与我相关
我的任务
分享
var list = from e1 in LinqDBContext.wbCheckInfo
join a in LinqDBContext.wbCheckList on a.wbCheckId equals e1.wbCheckId
join b in LinqDBContext.site on a.siteid equals b.siteid
join c in LinqDBContext.onlineFiresystem on b.siteid equals c.siteid
join d in LinqDBContext.firesystype on c.tiSysType equals d.tiSysType
select new {//to do..}
这样难道不行吗from q in A
from p in B.Where(w => w.stuId == q.Id).DefaultIfEmpty()
select new
{
q.Id,
q.Name,
p.stuId,
p.bName,
}