T：sql语句

select * from DB_FacultyReserveDetails details
join DB_FacultyreserveRule rul on details.[FK_ FacultyReserveRule] =rul.Id
where details.FK_BedInfo not in (select FK_BedInfo from SD_StuLiveInfo)


Linq语句：

var query = (from res in db.DB_FacultyReserveDetails
join faculty in db.DB_FacultyreserveRule on res.FK__FacultyReserveRule equals faculty.Id into facu
from selfiquery in facu.DefaultIfEmpty()
where !(from ii in db.SD_StuLiveInfo
select ii.FK_BedInfo).Contains(res.FK_BedInfo)
&& selfiquery.BeginDate <= System.DateTime.Now
&& selfiquery.EndDate >= System.DateTime.Now
join view in db.View_FullDept on res.Fk_DeptClass ?? res.Fk_DeptInfoMajor ?? res.Fk_DeptInfoFaculty equals view.ID
group view by new { code = view.ID, name = view.fullName } into g
select new 
{
Code = g.Key.code,
Name = g.Key.name,
Value = “0”
}).ToList();


　　

版权声明：本文为BabyRui原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/BabyRui/p/10056840.html