1、左連接：

var LeftJoin = from emp in ListOfEmployees?
join dept in ListOfDepartment?
on emp.DeptID equals dept.ID into JoinedEmpDept?
from dept in JoinedEmpDept.DefaultIfEmpty()?
select new??
{?
EmployeeName = emp.Name,?
DepartmentName = dept != null ? dept.Name : null??
};

?

如果想實(shí)現(xiàn)右連接，就把兩個(gè)表?yè)Q一下位置。

?

2、右連接：

var RightJoin = from dept in ListOfDepartment?
join employee in ListOfEmployees?
on dept.ID equals employee.DeptID into joinDeptEmp?
from employee in joinDeptEmp.DefaultIfEmpty()?
select new??
{?
EmployeeName = employee != null ? employee.Name : null, ? ? ? ? ?//重點(diǎn)
DepartmentName = dept.Name?
};

?左鏈接或右鏈接，使用DefaultIfEmpty()語(yǔ)法，采用些語(yǔ)法前需要用到into語(yǔ)法

3、內(nèi)連接：

var query = from t in entitiy.TB_GCGL_ADA_USER?
join p in entitiy.TB_GCGL_ZY_ZYK?
on t.ETPRS_CODE equals p.ETPRS_CODE

select new TB_USER_ZYK?
{?
USER_ID = t.USER_ID,?
USER_NAME = t.USER_NAME,?
USER_PASSWORD = t.USER_PASSWORD,

};

轉(zhuǎn)載于:https://www.cnblogs.com/DSC1991/p/8705765.html

《新程序員》：云原生和全面數(shù)字化實(shí)踐50位技術(shù)專家共同創(chuàng)作，文字、視頻、音頻交互閱讀

總結(jié)

以上是生活随笔為你收集整理的linq之多表连接的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。