Linq to Entities and outer joins issue
- by Robert Koritnik
Can somebody tell me, why does Linq to Entities translate many to 1 relationships to left outer joins instead of inner joins? It relation was many to 0..1. There's referential constraint on DB itself, that ensures there's a record in the right table, so inner join should be used instead.
Is it possible to write LINQ in a way so they will translate to inner joins rather than left outer joins. It would speed query execution a lot.