Linq to Entities and LEFT OUTER JOIN issue with MANY:1 relations
- by Robert Koritnik
Can somebody tell me, why does Linq to Entities translate many to 1 relationships to left outer join instead of inner join? Because there's referential constraint on DB itself that ensures there's a record in the right table, so inner join should be used instead (and it would work much faster)
If relation was many to 0..1 left outer join would be…