Mid LINQ

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"

More from LINQ Tutorial

All questions for this course