Linq to Entities and outer joins issue

Posted by Robert Koritnik on Stack Overflow See other posts from Stack Overflow or by Robert Koritnik
Published on 2010-03-22T09:03:29Z Indexed on 2010/03/22 9:11 UTC
Read the original article Hit count: 337

Filed under:

linq-to-entities

|

outer-join

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.

© Stack Overflow or respective owner

Related posts about linq-to-entities

HELP: deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
Linq to Entities : using ToLower() on NText fields

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using SQL Server 2005, with a case sensitive database.. In a search function, I need to create a Linq To Entities (L2E) query with a "where" clause that compare several strings with the data in the database with these rules : The comparison is a "Contains" mode, not strict compare : easy as… >>> More
LiNQ to Entities, Include less

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, If you are making a LinQ to entities expression for ClassA where A has a relation to ClassB like this: var temp = from p in myEntities.ClassA.Include("ClassB") where ... select p; You will get a set of ClassA:s with the reference to ClassB loaded. The thing in my case… >>> More
deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
LINQ To Entities - Items, ItemCategories & Tags

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi There, I have an Entity Model that has Items, which can belong to one or more categories, and which can have one or more tags. I need to write a query that finds all tags for a given ItemCategory, preferably with a single call to the database, as this is going to get called fairly often. I currently… >>> More

Related posts about outer-join

Full outer join in django

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I create a query for a full outer join across a M2M relationchip using the django QuerySet API? It that is not supported, some hint about creating my own manager to do this would be welcome. Edited to add: @S.Lott: Thanks for the enlightenment. The need for the OUTER JOIN comes from the… >>> More
Slow queries in Rails- not sure if my indexes are being used.

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm doing a quite complicated find with lots of includes, which rails is splitting into a sequence of discrete queries rather than do a single big join. The queries are really slow - my dataset isn't massive, with none of the tables having more than a few thousand records. I have indexed all of… >>> More
TSQL Conditionally Select Specific Value

as seen on Stack Overflow - Search for 'Stack Overflow'
This is a follow-up to #1644748 where I successfully answered my own question, but Quassnoi helped me to realize that it was the wrong question. He gave me a solution that worked for my sample data, but I couldn't plug it back into the parent stored procedure because I fail at SQL 2005 syntax. So… >>> More
ROW_NUMBER() VS. DISTINCT

as seen on Stack Overflow - Search for 'Stack Overflow'
Dear All, I have a problem with ROW_NUMBER() , if i used it with DISTINCT in the following Query I have 2 scenarios: 1- run this query direct : give me for example 400 record as a result 2- uncomment a line which start with [--Uncomment1--] : give me 700 record as a result it duplicated some records… >>> More
"SELECT TOP", "LEFT OUTER JOIN", "ORDER BY" gives extra rows

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following Access query I'm running through OLE DB in .NET: SELECT TOP 25 tblClient.ClientCode, tblRegion.Region FROM (tblClient LEFT OUTER JOIN tblRegion ON tblClient.RegionCode = tblRegion.RegionCode) ORDER BY tblRegion.Region There are 431 records… >>> More