CODEWITHSUNDEEP
asp.netperformanceentity-framework
Peter
Peter

Reputation: 14108

MigrateDatabaseToLatestVersion performance in ASP.NET

I have inherited an ASP.NET application, using Entity Framework 6, and have enabled migrations. In my Global.asax, I have this:

using (var context = new MyContext())
{
    Database.SetInitializer(new MigrateDatabaseToLatestVersion<MyContext, MyConfiguration>());
    context.Database.Initialize(true);
}

The problem is that every time my application needs to start up (due to IIS shutting it down for example), this logic is run, even though in most cases there is no migration to be performed. This significantly slows down the processing of the requests.

What are my options here? What is best practice? I could disable this and use the Package Manager Console to perform migrations manually, but that kind of beats the purpose (though if there are no other options, I'm prepared to do this).

Upvotes: 1

Views: 326

Answers (1)

Ivan Stoev
Ivan Stoev

Reputation: 205629

The EF6 automatic migrations seem to introduce several issues (not only performance), so the EF Core team decided to remove them from EF Core (you can read some reasoning here).

Since EF Core is the EF6 successor (the future of the Entity Framework), looks like the recommendation (best practice) is to disable it and perform migrations manually.

Upvotes: 2

Related Questions