DbSet names are not used for table names in TPT and TPC mappings

[ajcvickers]

This never mattered before because TPT required explicit table naimg. Now, with UseTptMappingStrategy and UseTpcMappingStrategy, it does matter.

For example:

public abstract class Animal
{
    public int Id { get; set; }
    public string Species { get; set; }
}

public class FarmAnimal : Animal
{
    public decimal Value { get; set; }
}

public abstract class Pet : Animal
{
    public string Name { get; set; }
}

public class Cat : Pet
{
    public string EdcuationLevel { get; set; }
}

public class Dog : Pet
{
    public string FavoriteToy { get; set; }
}

public class SomeDbContext : DbContext
{
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        => optionsBuilder
            .UseSqlServer(Your.ConnectionString)
            .LogTo(Console.WriteLine, LogLevel.Information)
            .EnableSensitiveDataLogging();

    
    public DbSet<Animal> Animals { get; set; }
    public DbSet<Cat> Cats { get; set; }
    public DbSet<Dog> Dogs { get; set; }
    public DbSet<FarmAnimal> FarmAnimals { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Animal>().UseTpcMappingStrategy();
    }
}

The tables are:

      CREATE TABLE [Cat] (
          [Id] int NOT NULL,
          [Species] nvarchar(max) NULL,
          [EdcuationLevel] nvarchar(max) NULL,
          [Name] nvarchar(max) NULL,
          CONSTRAINT [PK_Cat] PRIMARY KEY ([Id])
      );

      CREATE TABLE [Dog] (
          [Id] int NOT NULL,
          [Species] nvarchar(max) NULL,
          [FavoriteToy] nvarchar(max) NULL,
          [Name] nvarchar(max) NULL,
          CONSTRAINT [PK_Dog] PRIMARY KEY ([Id])
      );

      CREATE TABLE [FarmAnimal] (
          [Id] int NOT NULL,
          [Species] nvarchar(max) NULL,
          [Value] decimal(18,2) NOT NULL,
          CONSTRAINT [PK_FarmAnimal] PRIMARY KEY ([Id])
      );

[smitpatel]

Interestingly #27947

[ajcvickers]

@smitpatel For TPC, the DbSets are not for abstract types, but this still doesn't work. Interesting conflict of interest, though. 🤷