Entity Framwork’s Include Function Produces Inner Joins Instead of Outer Joins
Entity Framework’s Include function usually produces OUTER JOINs. I ran into an scenario where INNER JOINs were being produced that filtered out needed records. The solution is in the direction of the EF expression.