Lambda左外连接和右外连接 [英] Lambda Left Outer Join and Right Outer Join

问题描述

有人可以在lambda表达式中给出一个非常简单的示例"Left Outer Join"和"Right Outer Join"吗?请提供示例

Can anybody please give a very simple example of "Left Outer Join" and "Right Outer Join" in lambda expression? Please give examples

推荐答案

左外部连接

Left outer join

var emp = (from ein dbContext.Employees 
          join d in dbContext.Departmentson e.DepartmentID equals d.ID into ej
          from d in ej.DefaultIfEmpty()
          select new {e.Name, e.Phone, Department = (d.Name) });

右外连接

Right outer Join

var emp = (from d in dbContext.Departments
          join e in dbContext.Employees on d.ID equals e.DepartmentID into ej
          from e in ej.DefaultIfEmpty()
          select new {e.Name, e.Phone, Department = (d.Name) });

这篇关于Lambda左外连接和右外连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！