Allow specifying different index facets per table in TPT, TPC or entity splitting

[AndriySvyryd]

Split off from #19811

modelBuilder.Entity<Customer>().ToTable("Customer");
modelBuilder.Entity<SpecialCustomer>().ToTable("SpecialCustomer", tb =>
{
    tb.HasIndex(c => c.Id).HasDatabaseName("IX_Customer");
});

Alternative API:

modelBuilder.Entity<Customer>().HasIndex(c => c.Id)
    .ToTable("CustomerDetails", tb => tb.HasDatabaseName("IX_Customer"));

[amyboose]

Is it possible to reconsider the possibility of implementing this feature for EF Core 8 together with #27972 and #27971?

It helps to get rid of some bugs using EFCore.NamingConventions. For example, look at efcore/EFCore.NamingConventions#185

[ErikEJ]

@amyboose The EF Core 8 train has left the platform