c# - EF Core 5 Include always produces left join

Question

I have an one to many relationship and I'm trying to query the parent object and also filter the results based on child's existence.

Let's say we have the following:

public class Parent 
{
    // some properties
    public ICollection<Child> Children { get; set; }
}

public class Child
{
    // some properties
    public Parent Parent { get; set; }
}

And with Fluent API I declare the following:

builder.Entity<Parent>()
    .HasMany(_ => _.Children)
    .WithOne(_ => _.Parent)
    .IsRequired();

When I create the queryable like below, the ef core produces a query with Left Join instead of Inner Join. How can I "force" an inner join?

dbContext.Parent.Include(_ => _.Children)

question from:https://stackoverflow.com/questions/65647439/ef-core-5-include-always-produces-left-join

Answer 1

Waitting for answers