DbSet names are not used for table names when more than one shared-type entity type in the model

[ajcvickers]

In the code below, when I just create "Product" I get the following model and table:

Model: 
  EntityType: Product CLR Type: NamedEntity
    Properties: 
      Id (int) Required PK AfterSave:Throw ValueGenerated.OnAdd
      Name (string)
    Keys: 
      Id PK

CREATE TABLE "ProductsSetName" (
          "Id" INTEGER NOT NULL CONSTRAINT "PK_Products" PRIMARY KEY AUTOINCREMENT,
          "Name" TEXT NULL
      );

Notice the entity type is shared in the model and the DbSet property name is used for the table name.

However, if I also map "Category" to the same shared type, then the DbSet property name is no longer used as the table name:

Model: 
  EntityType: Category CLR Type: NamedEntity
    Properties: 
      Id (int) Required PK AfterSave:Throw ValueGenerated.OnAdd
      Name (string)
    Keys: 
      Id PK
  EntityType: Product CLR Type: NamedEntity
    Properties: 
      Id (int) Required PK AfterSave:Throw ValueGenerated.OnAdd
      Name (string)
    Keys: 
      Id PK

 CREATE TABLE "Category" (
          "Id" INTEGER NOT NULL CONSTRAINT "PK_Category" PRIMARY KEY AUTOINCREMENT,
          "Name" TEXT NULL
      );
      CREATE TABLE "Product" (
          "Id" INTEGER NOT NULL CONSTRAINT "PK_Product" PRIMARY KEY AUTOINCREMENT,
          "Name" TEXT NULL
      );

public class NamedEntity
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class ProductsContext : DbContext
{
    public DbSet<NamedEntity> ProductsSetName => Set<NamedEntity>("Product");
    //public DbSet<NamedEntity> CategoriesSetName => Set<NamedEntity>("Category");

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.SharedTypeEntity<NamedEntity>("Product");
        //modelBuilder.SharedTypeEntity<NamedEntity>("Category");
    }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        => optionsBuilder
            .LogTo(Console.WriteLine, new[] { RelationalEventId.CommandExecuted })
            .EnableSensitiveDataLogging()
            .UseSqlite("Data Source = test.db");
}

public static class Program
{
    public static void Main()
    {
        using (var context = new ProductsContext())
        {
            context.Database.EnsureDeleted();
            context.Database.EnsureCreated();
        }

        using (var context = new ProductsContext())
        {
        }
    }
}

[smitpatel]

First one is probably leaving behind set name. STET should not take names from DbSet.

[ajcvickers]

STET should not take names from DbSet

Why not?

[smitpatel]

Unless we start processing the setters for DbSet. DbSet property is not enough to identify STET. (Even in Set<T>() form). So they should not cause any effect on STET.

[ajcvickers]

Good point.