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
Currently browsing Data Access
Entity Framwork's Include Function Produces Inner Joins Instead of Outer Joins
Posted in Data Access February 15, 2010

2