Employees
.Join (
Persons,
emp => emp.BusinessEntityID,
prs => prs.BusinessEntityID,
(emp, prs) =>
new
{
emp = emp,
prs = prs
}
)
.Join (
EmployeeDepartmentHistories,
temp0 => temp0.emp.BusinessEntityID,
dptHst => dptHst.BusinessEntityID,
(temp0, dptHst) =>
new
{
temp0 = temp0,
dptHst = dptHst
}
)
.Join (
Departments,
temp1 => temp1.dptHst.DepartmentID,