Entity Framework Core - change table schema "__EFMigrationsHistory"

Question

Can I change the __EFMigrationsHistory table __EFMigrationsHistory in the EntityFramework core?

Answer 1

Do this when calling UseSqlServer .

 optionsBuilder .UseSqlServer( "...", x => x.MigrationsHistoryTable( HistoryRepository.DefaultTableName, "mySchema")); 

Answer 2

A look into the source code ( HistoryRepository.cs ). You can customize tables of tables and diagrams inside the DbContext constructor

 public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options) { var relationalOptions = RelationalOptionsExtension.Extract(options); relationalOptions.MigrationsHistoryTableName = "bar"; relationalOptions.MigrationsHistoryTableSchema = "foo"; } 

or inside the OnConfiguring method

 protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { var relationalOptions = RelationalOptionsExtension.Extract(optionsBuilder.Options); relationalOptions.MigrationsHistoryTableName = "bar"; relationalOptions.MigrationsHistoryTableSchema = "foo"; }