Category Archives: Entity Framework

Left outer join in C# Linq query

Left joins are such a common occurrence in data access programs. There is no direct LINQ operator or syntax mapped for left joins. However, there is an extension method DefaultIfEmpty() which can be employed to perform a left outer join using LINQ syntax. DefaultIfEmpty basically returns a single element sequence with associated type’s default value… Read More »