有一個表我想加入不同表中的不同列。
到目前為止我是這樣做的
var purchData = (from a in db.AppRequest
join e in db.Employee on a.Req_By equals e.Id
join c in db.Company on e.CompanyId equals c.Id
join d in db.Designation on e.DesignId equals d.Id
join l in db.Master_Locations on a.Req_Location equals l.Id
join dep in db.Department on e.DepId equals dep.Id
join p in db.Purchase on a.Id equals p.Req_Id
join pi in db.PurchasingItems on p.Id equals pi.Purchase_Id
join pd in db.PurchasingDetails on p.Id equals pd.Purchase_Id
join pds in db.PurchasingDetailsSup on pd.Id equals pds.PurchasingDetails_Id
join s in db.M_Supplier on pds.Supp_Id equals s.Id
join payMethod in db.Master_PayMethods on s.Pay_Method equals payMethod.Id
join poNo in db.ApprovedPoNumbers on p.Id equals poNo.Purchase_Id
where a.Id == id && pds.IsApproved == true
在db.ApprovedPoNumbers表中有purchase_Id和Supplier_Id
在db.PurchasingDetailsSup表中有purchase_Id和Supplier_Id
所以我想知道這里join poNo in db.ApprovedPoNumbers on p.Id equals poNo.Purchase_Id我想加入 db.ApprovedPoNumbers表格purchase_Id，表格Supplier_Id 和db.PurchasingDetailsSuppurchase_IdSupplier_Id
uj5u.com熱心網友回復：
您可以通過使用您打算匹配的標準構建兩個物件并equals在它們上使用運算子來實作這一點：
on new {poNo.purchase_Id, poNo.Supplied_Id} equals new {pds.purchase_Id, pds.Supplier_Id} into details
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/432709.html
標籤：C＃ 网 asp.net-mvc asp.net-mvc-4
上一篇：解釋協程的有趣行為
下一篇：在回圈中更改變數