Simple Linq query has duplicated join against same table?

by

Thank you for reporting this issue. Yes, it is not expected to see both joins. This is a bug that has been fixed in the current (not yet released) bits. In the current bits the same query produces: 

SELECT
[Extent1].[Id] AS [Id],
[Extent1].[Name] AS [Name],
[Extent1].[ContactId] AS [ContactId],
...
[Extent2].[Id] AS [Id1],
..
[Extent2].[FirstName] AS [FirstName],
[Extent2].[LastName] AS [LastName]
FROM  [dbo].[Address] AS [Extent1]
INNER JOIN [dbo].[Contact] AS [Extent2] ON [Extent1].[ContactId] = [Extent2].[Id] ORDER BY [Extent2].[LastName] ASC, [Extent2].[FirstName] ASC

I bit of playing shows that even on 4.0 this only happens when the relationship is 1:many, 0..1:many seems fine.

Thanks,

Kati Iceva
Entity Framework Developer
Microsoft

More Related Contents:

  1. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  2. Entity Framework: There is already an open DataReader associated with this Command
  3. Linq: adding conditions to the where clause conditionally
  4. Entity framework linq query Include() multiple children entities
  5. How to filter nested collection Entity Framework objects?
  6. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  7. Only initializers, entity members, and entity navigation properties are supported
  8. The type of one of the expressions in the join clause is incorrect in Entity Framework
  9. Convert String to Int in EF 4.0
  10. LINQ Join with Multiple Conditions in On Clause
  11. Linq-to-entities – Include() method not loading
  12. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  13. Instantiating a context in LINQ to Entities
  14. conditional include in linq to entities?
  15. EF 4: Removing child object from collection does not delete it – why?
  16. Linq To Entities – how to filter on child entities
  17. Entity Framework, Code First and Full Text Search
  18. LINQ OrderBy not ordering .. changing nothing .. why?
  19. Greater Than Condition in Linq Join
  20. ‘Contains()’ workaround using Linq to Entities?
  21. SQL to LINQ with multiple join, count and left join
  22. Why LINQ to Entities does not recognize the method ‘System.String ToString()?
  23. System.LINQ.Dynamic: Select(” new (…)”) into a List (or any other enumerable collection of )
  24. Include with FromSqlRaw and stored procedure in EF Core 3.1
  25. Filtering include items in LINQ and Entity Framework [duplicate]
  26. The LINQ expression could not be translated and will be evaluated locally
  27. Update records using LINQ
  28. Remove item from list based on condition
  29. How to group by DateTime.Date in EntityFramework
  30. Is it possible to perform joins across different databases using LINQ?

Leave a Comment