linq的左连接右连接内连接用法

1、左连接：

 

 

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

 

 

2、右连接：

 

var RightJoin = from d in ListOfDepartment
join e in ListOfEmployees
on d.ID equals e.DeptID into joinDeptEmp
from e in joinDeptEmp.DefaultIfEmpty()
select new                          
{
EmployeeName = e!= null ? e.Name : null,
DepartmentName = d.Name
};

 

3、内连接：

 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,

                 };

三个表链表查询

 

var list = (  
    from u in dc.userinfos  
        join j in dc.jobs on u.job equals j.jid into j_join from x in j_join.DefaultIfEmpty() join c in dc.cities on u.city equals c.cid into c_join from v in c_join.DefaultIfEmpty() select new { id = u.id, name = u.name, jname = x.jname, cname = v.cname, /*u1=u,x1=x,v1=v*/ //不要用对象的方式 因为对象可能为null那么对象.属性就会抛异常  } ).ToList(); 

 

转载于:https://www.cnblogs.com/sdya/p/4377794.html