How can I disable code first migrations

Question

I have a code-first entity model in EF5. But I want to manage the database changes manually -- I do not want EF to modify my existing database and all its data. But when I make parallel changes in the EF mapping and in the database, EF refuses to operate properly telling me I need to use code first migration. How do I turn this off?

Possible duplicate of [How can I disable migration in Entity Framework 6.0](http://stackoverflow.com/questions/18667172/how-can-i-disable-migration-in-entity-framework-6-0) — Michael Freidgeim, Sep 07 '16 at 02:23

Sarath Rachuri · Answer 1 · 2015-06-20T06:19:50.833

112

set the Database.SetInitializer to null.

public class DatabaseContext: DbContext
{
    //the base accepts the name of the connection string provided in the web.config as a parameter
    public DatabaseContext()
        : base("DatabaseContext")
    {
        //disable initializer
        Database.SetInitializer<DatabaseContext>(null);
    }

edited Jun 20 '15 at 06:19

answered Apr 01 '15 at 15:26

Sarath Rachuri

2,086
2
18
18

2

Setting the initializer on the context's instance constructor doesn't make sense. EF will call the initializer before actually getting to that code if you try to make a new context. – Jcl Jul 11 '16 at 17:03
1

Just verified the answer by looking at "Diagnostic Tool" in VS 2017. The ADO.NET calls before the first wanted SQL query have stopped after setting the intializer to null in the constructor. – Karl Mar 14 '18 at 08:41
3

It works as expected. It's true EF will call the initializer before, but then calling it again inside the constructor makes the DbContext just ignore the migrations, in case you want to ignore the fact that your `__MigrationHistory` doesn't have the latest migration, and you don't want to do it anyway. In my case, I use migrations in dev environment, but when I deploy to production, I use SSDT to update the database. Therefore, EF would complain the model has changed because `__MigrationHistory` would not have the latest migration, but I can guarantee the database is updated. – Alisson Reinaldo Silva Mar 27 '18 at 18:04
1

I would suggest moving the call to `Database.SetInitializer` from the constructor to the class constructor. That ensures the call is only made just once. – Steven Apr 14 '20 at 12:13
@Steven Please explain what you mean by "moving the call to Database.SetInitializer from the constructor to the class constructor." What is the class constructor? – Polyfun Nov 09 '22 at 09:50
@Polyfun: This is the type's [static constructor](https://learn.microsoft.com/en-us/dotnet/csharp/programming-guide/classes-and-structs/static-constructors). – Steven Nov 09 '22 at 11:31

score 47 · Answer 2 · answered Nov 11 '16 at 08:06

47

So the most complete answer that I have found is this:

Delete Migrations folder inside your project.
Set Database.SetInitializer<DatabaseContext>(null); inside your DatabaseContext initializer.
Delete the table __MigrationHistory inside your database. For EF6+ the table is located under Tables but for earlier versions it is located under System Tables.
Build and run.
Profit.

answered Nov 11 '16 at 08:06

karlingen

13,800
5
43
74

Unfortunately after following these steps, EF6 still checks for the existence of `__MigrationHistory` every time my application starts-up which adds a few more milliseconds to my app's startup time. Is there a way to disable the `__MigrationHistory` check entirely? – Dai Feb 04 '20 at 01:47
@karlingen Please explain what you mean by "inside your DatabaseContext initializer." – Polyfun Nov 09 '22 at 09:49
@Polyfun It was years ago I did anything related to this, but I think I meant the DatabaseContext's constructor. So put the logic inside the constructor of the DatabaseContext class. Basically what you are seeing in this answer: https://stackoverflow.com/a/29394811/1942551 – karlingen Nov 09 '22 at 21:29

score 29 · Answer 3 · edited May 23 '17 at 11:55

29

If you want to completely turn off migrations:

https://stackoverflow.com/a/9709407/141172

However, I found it better to keep code first migrations enabled, but use the -Script option to have EF create a DB change script for me that I can apply to each database (development, QA, Production) manually:

Update-Database -Script -ProjectName MyProject -StartupProjectName MyProject

That way EF will create the change script for me, and I still have full control over changes being applied. I version the change scripts like any other source code.

edited May 23 '17 at 11:55

Community

1
1

answered Feb 01 '13 at 20:02

Eric J.

147,927
63
340
553

1

your link doesn't really corresponse to `completely turn off migrations`. To do that: add `Database.SetInitializer(null)` to startup of your application – Don Cheadle Dec 14 '15 at 16:28
Any idea how to achieve this with EF Core? – Shimmy Weitzhandler Apr 11 '20 at 19:59
@Shimmy: EF Core should never automatically try to alter your database. See https://github.com/dotnet/efcore/issues/3152 – Eric J. Apr 11 '20 at 20:03

Episodex · Answer 4 · 2015-03-11T08:30:17.157

26

If you already used Migrations then changing only Initializer won't help. You need to go to Management Studio, open your database tables, go to System Tables folder and remove __MigrationHistory table that is located there (for EF6 and above, it's located directly under Tables). This will disable Migrations for good.

edited Mar 11 '15 at 08:30

answered Aug 08 '13 at 09:13

Episodex

4,479
3
41
58

7

The table __MigrationHistory is located directly under Tables, not System Tables. – Peter Hedberg Oct 06 '14 at 10:36
6

@PeterHedberg This is true for EF6+. For earlier versions it was under `System Tables`. – Episodex Mar 11 '15 at 08:29
2

You can also rename the table, instead of deleting it, using `sp_rename`. I also disabled the initializer. – NMrt Jun 26 '19 at 05:28

NoWar · Answer 5 · 2020-09-23T02:49:55.773

2

I just resolved this "issue" by

Deleting table "_MigrationHistory" from the database.
Deleting "Migrations" folder form the project.
Updating EDMX file.
Clean project & rebuild it.

The config of my environment is following

1. Visual Studio 2017 15.8.2
2. ASP NET MVC project
3. .NET Framework 4.6.1
4. Entity Framework 6.2.0

edited Sep 23 '20 at 02:49

answered Sep 10 '18 at 02:59

NoWar

36,338
80
323
498

May i ask what you updated in the EDMX File? I am also using Database First and it is still querying the non existent Migration Tables... Thanks! – dalcam Nov 02 '18 at 22:17
What if later we need migrations, does it creates new `_MigrationHistory` table automatically? – sairfan Feb 05 '19 at 19:05

How can I disable code first migrations

5 Answers5

Linked