SQL 转 LINQ, 多left join ,在线等结贴

[Error_Code]

         SELECT Patients.*, CurrentSurgeries.*,Fac_PreopChecklists.*
         FROM  
         (Patients left join Pt_CurrentSurgeries on Patients.PatientID = Pt_CurrentSurgeries.PatientID)
         left join Fac_PreopChecklists on Fac_PreopChecklists.Pt_CurrentSurgeryID=Pt_CurrentSurgeries.Pt_CurrentSurgeryID
         left join CurrentSurgeries on Pt_CurrentSurgeries.CurrentSurgeryID = CurrentSurgeries.CurrentSurgeryID, Pt_Forms, Forms
         WHERE  (Pt_CurrentSurgeries.StatusID>0 OR Pt_CurrentSurgeries.StatusID is null)
         AND (CurrentSurgeries.SurgeryDate>=GETDATE() or CurrentSurgeries.SurgeryDate is null)
         AND Patients.PatientID = Pt_Forms.PtID 
         AND Pt_Forms.FormID = Forms.FormID 
         AND Forms.FacilityID=12
         AND (Patients.FirstName like '%sdf%' OR Patients.LastName like '%sdf%')

[Error_Code]

刚发现Linq to entities 不能DefaultIfEmpty()

[wuyq11]

var q =
from e in db.Employees
join o in db.Books on e.EmployeeID equals o.EmployeeID into b
from x in b.DefaultIfEmpty()
select new
{
e.ID,
e.Name,
o.BookName
};