Show all departments even if no employees (outer join)?
Show all departments even if no employees (outer join)
var allDepts = from d in departments
join e in employees on d.Name equals e.Department
into empGroup
from eg in empGroup.DefaultIfEmpty()
select new {
Dept = d.Name,
EmpName = eg?.Name ?? "No Employee"