当前位置: 澳门新濠3559 > 数据库 > 正文

采用些语法前需要用到into语法

时间:2019-10-06 19:48来源:数据库
1、左连接: 1、左连接: 1、左连接: 1、左连接: var LeftJoin = from emp in ListOfEmployees  join dept in ListOfDepartment  on emp.DeptID equals dept.ID into JoinedEmpDept  from dept in JoinedEmpDept.DefaultIfEmpty() 

1、左连接:

1、左连接:

1、左连接:

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  
};

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                        
};

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                        
};

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 采用些语法前需要用到into语法。!= null ? dept.Name : null                        
};

 

 

 

 2、右连接:

如果想实现右连接,就把两个表换一下位置。

2、右连接:

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,
DepartmentName = dept.Name
};

 

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,
DepartmentName = dept.Name
};

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,
DepartmentName = dept.Name
};

 3、内连接:

2、右连接:

 

 

 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

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,          //重点
DepartmentName = dept.Name 
};

3、内连接:

3、内连接:

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

 左链接或右链接,使用DefaultIfEmpty()语法,采用些语法前需要用到into语法

 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

 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

                 };

3、内连接:

                 select new TB_USER_ZYK
                 {
澳门新濠3559,                    USER_ID = t.USER_ID,
                    USER_NAME = t.USER_NAME,
                    USER_PASSWORD = t.USER_PASSWORD,

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

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,

};

编辑:数据库 本文来源:采用些语法前需要用到into语法

关键词: 澳门新濠3559