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 }

Revision #1
Created 2022-09-13 21:15:43 UTC by Admin
Updated 2024-08-30 11:20:50 UTC by Admin