Query: Using Include and referencing a navigation property will not result in repeated joins

[maumar]

When we apply Include and also access navigation property on the entity that was included, we generate JOINs for to the same table twice. We could potentially be smart about it and only do it once.

e.g.

ctx.As.Include(a => a.B).Where(a => a.B.Name == "Foo")

[divega]

@maumar @anpete I see we have some possible overlap or duplication between this bug, #4900, #3816 and #3419.

Could you please figure out if we can consolidate into a smaller set of orthogonal bugs without loosing information?

[smitpatel]

@maumar - Can you do a quick check if this is fixed after new include compiler ?

[maumar]

Yes, that is indeed fixed, closing