Entity Framework Migrations

Question

I use code first to design my database. In my server there is a different database. So I want that when I published my new asp.net project to the server, let the database migrate to new version automatically. How can I do that? Which subject should I check?

OK we can do that with the remote database connection string and update-database command from console. But not so, how is it possible by inline the code?

Bhuvanesh Mohankumar · Answer

You are following a Code first approach. You can directly deploy and publish your code to server. Now when it comes to database do you have the database project separately to deploy? Follow this link you will get what you need. https://msdn.microsoft.com/en-us/library/jj591621(v=vs.113).aspx Please let me know if more details needed. mark as answer  if helpful.

Bikesh Srivastava · Answer

Please visit on this link http://www.entityframeworktutorial.net/code-first/migration-in-code-first.aspx

Serhat Koroglu · Answer

I learnt a way to do this. There is System.Data.Entity.Database.SetInitializer method to implement. It uses DropCreateDatabaseIfModelChanges or MigrateDatabaseToLatestVersion object as parameter. https://msdn.microsoft.com/en-us/library/hh829293(v=vs.113).aspx We can implement this appending the line to global.asax's application start event method: protected void Application_Start( object sender EventArgs e) { System.Data.Entity.Database.SetInitializer( new MigrateDatabaseToLatestVersion()); }