AutoInclude causes ExecuteUpdate/Delete to have useless JOIN

[roji]

With 8.0.0-alpha.1.23055.2, having an AutoInclude navigation on the target entity type causes ExecuteDelete to fail. Note that ExecuteUpdate does work correctly, and having an owned entity type also works (see related #28727):

await using var ctx = new BlogContext();
await ctx.Database.EnsureDeletedAsync();
await ctx.Database.EnsureCreatedAsync();

ctx.Blogs.ExecuteUpdate(s => s.SetProperty(b => b.Name, "Foo"));

public class BlogContext : DbContext
{
    public DbSet<Blog> Blogs { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        => optionsBuilder
            .UseSqlServer(@"Server=localhost;Database=test;User=SA;Password=Abcd5678;Connect Timeout=60;ConnectRetryCount=0;Encrypt=false")
            .LogTo(Console.WriteLine, LogLevel.Information)
            .EnableSensitiveDataLogging();

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Blog>(
            x => x.Navigation(b => b.Details).AutoInclude());
    }
}

public class Blog
{
    public int Id { get; set; }
    public string? Name { get; set; }

    public BlogDetails Details { get; set; }
}

public class BlogDetails
{
    public int Id { get; set; }
    public int Foo { get; set; }
}

[roji]

Note that ExecuteUpdate works, but the SQL contains the useless JOIN from the AutoInclude:

UPDATE [b]
SET [b].[Name] = N'foo'
FROM [Blogs] AS [b]
INNER JOIN [BlogDetails] AS [b0] ON [b].[DetailsId] = [b0].[Id]

This also doesn't happen with an owned entity, so I suspect the same origin.

[roji]

Note the interesting difference between owned and auto-include in the pre-translation query trees (/cc @maumar):

Owned:

[Microsoft.EntityFrameworkCore.Query.EntityQueryRootExpression]
    .Select(b => [Microsoft.EntityFrameworkCore.Query.IncludeExpression])
    .ExecuteUpdate(s => s.SetProperty(b => b.Name, "Foo"))

Auto-include:

[Microsoft.EntityFrameworkCore.Query.EntityQueryRootExpression]
    .Join([Microsoft.EntityFrameworkCore.Query.EntityQueryRootExpression], b => Property(b, "DetailsId"), b0 => Property(b0, "Id"), (o, i) => new TransparentIdentifier`2(Outer = o, Inner = i))
    .Select(b => [Microsoft.EntityFrameworkCore.Query.IncludeExpression])
    .ExecuteUpdate(s => s.SetProperty(b => b.Name, "Foo"))

[roji]

Note: split the Delete issue out to #30572