Skip to main content

Left outer join


from leftTable in context.leftTable
join rightTable in context.rightTable on leftTable.FKRightTable equals rightTable.Id into rightTableJoin
from joinedRightTable in rightTableJoin.DefaultIfEmpty()
select new { LeftData = leftTable.data, RightData = joinedRightTable?.data }