Browsed by
Month: January 2016

Left Outer Join in LINQ with Visual Basic .NET

Left Outer Join in LINQ with Visual Basic .NET

Many developers encounters problems when trying to mimic the functionality of a Left Outer Join in LINQ. To be honest, the needed code is on first sight a bit strange. You can use a Group Join … Into .. and the DefaultIsEmpty() method. Let’s start with a regular (Inner) Join example. It uses the NorthWnd database and will retrieve all customers with at least one order.