EF Core: Use multiple database schemas in DbContext object?

This code provides a solution for organizing DbSet objects by schemas in a DbContext, corresponding to a multi-schema database structure.

• Using schemas to organize DbSet:
  • SchemaDbSet, which combines a DbSet with schema information. This allows DbSets to be grouped by schema.
• Access objects as dbcontext.Common.User
• Strategy for working with multiple schemas

public interface ISchema
{
    string Name { get; }
}

public class CommonSchema : ISchema
{
    public string Name => "Common";
}

public class ProductSchema : ISchema
{
    public string Name => "Product";
}

public class SchemaDbSet<TEntity, TSchema> where TEntity : class where TSchema : ISchema, new()
{
    private readonly DbContext _context;
    private readonly string _schemaName;

    public SchemaDbSet(DbContext context)
    {
        _context = context;
        _schemaName = new TSchema().Name;
    }

    public DbSet<TEntity> Entities => _context.Set<TEntity>();

    public IQueryable<TEntity> Query => Entities.AsQueryable();
}

public class CommonSchemaDbSets
{
    public SchemaDbSet<User, CommonSchema> User { get; set; }
}

public class ProductSchemaDbSets
{
    public SchemaDbSet<Order, ProductSchema> Order { get; set; }
}

public class MyDbContext : DbContext
{
    public CommonSchemaDbSets Common { get; }
    public ProductSchemaDbSets Product { get; }

    public MyDbContext(DbContextOptions<MyDbContext> options) : base(options)
    {
        Common = new CommonSchemaDbSets();
        Product = new ProductSchemaDbSets();
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<User>().ToTable("User", "Common");
        modelBuilder.Entity<Order>().ToTable("Order", "Product");

        Common.User = new SchemaDbSet<User, CommonSchema>(this);
        Product.Order = new SchemaDbSet<Order, ProductSchema>(this);
    }
}