Code First Automatic Migration

Question

The current project I am working on, I am telling Entity Framework to do nothing by setting SetInitializer with params null:

public EfDbContext()
{
   Database.SetInitializer<EfDbContext>(null); //new NullDatabaseInitializer<EfDbContext>());
}

I have a script that creates a few table. When I running the script, it is creating the dbo.__MigrationHistory in the DB.

How can I disable migration, I thought the above code would disable that.

Am I missing something? I also don't have migration enabled and any configuration files for migration.

I am using EF 6.1.3.

Daniel Forero · Accepted Answer · 2017-08-08 15:49:12Z

1

In your migrations folder there is a file called Configuration, in the constructor try something like this:

public Configuration()
{
     AutomaticMigrationsEnabled = false;
}

The ugly but easy way to disable the migrations at all regardless the configuration is deleting the table dbo.__MigrationHistory.

answered Aug 8, 2017 at 15:49

Daniel Forero

957 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Valter Over a year ago

I don't have any migration configuration. I don't have a migration folder. Every time i delete the dbo.__MigrationHistory, when I run the script that creates the table, the dbo.__MigrationHistory gets created again

Daniel Forero Over a year ago

ok, go to your package manager console and enter this command: add-migration initialSchema This will allow you to manage the migrations manually, and it will creates this folder and the configuration for you.

Valter Over a year ago

Why is EF creating dbo.__MigrationHistory table if it is not enabled? Is it default behavior?

Daniel Forero Over a year ago

yes it is, the table is not only for automatic migrations, it is use for all the migrations regardless if you are applying it by hand or automatic, this table is use to calculate what changes the migration needs to do in the database based in the information of the table and what is new in the code.

Valter Over a year ago

Is there any way to prevent EF from creating migration history table in the DB?

|

Valter · Accepted Answer · 2017-08-11 13:31:14Z

1

I fixed the issue by adding the following code into the Application_Start() in Global.asax:

Database.SetInitializer(new NullDatabaseInitializer<DbContext>());

answered Aug 11, 2017 at 13:31

Valter

2,8995 gold badges33 silver badges51 bronze badges

Collectives™ on Stack Overflow

Code First Automatic Migration

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related