Entity Framework Migrations

Serhat Koroglu

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?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava9y ago
Please visit on this link

http://www.entityframeworktutorial.net/code-first/migration-in-code-first.aspx
+1
Serhat Koroglu9y ago
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());
}
0
Bhuvanesh Mohankumar9y ago
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.
+2