SQL 转 LINQ, 多left join ,在线等结贴
SQL 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%')
刚发现Linq to entities 不能DefaultIfEmpty()
相关问答：
我有一个表，结构是这样。
转出 单位 转入单位 笔数 金额
date(主) outid(主) inid(主) num amt
2009 1 2 1 500 为 1 单位 在2009� ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
上面一个简单的SQL,执行时间2.6� ......
tab1 字段:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 字段:goodsid,goodskind（商品类型）
tab3 字段:goodskind（商品类型）,kindname
结果：
得到商品类型在一段时间 ......
