Entity Framework 6 Model First Migration

 

Desired outcome:

Use model first approach with Entity Framework and allow changes to deployed database/ model to be done automatically based on the changes in the model. Automatic schema difference script generation to allow smooth migrations.

Is there a way to perform migrations in model first EF6? I can see code first migrations topics all over, but nothing much on Model First.

Options I saw so far:

  • Database generation power pack (seems outdated)
  • somehow convert to code first, then use migrations (not desirable, as I like to have a visual designer)
  • somehow piggy back on code first migrations (http://blog.amusedia.com/2012/08/entity-framework-migration-with-model.html : this is for EF5, got error that can't run migrations on Model First)
  • some third party tools?

    • As far as I know there still is no automatic migration for Entity framework model first.

    Our approach is:

  • Create a fresh database from the model.
  • Create a diff script to migrate the old database to the new one.
  • Verify that this diff script is indeed correct. Always double check what your automation tool creates.

    • We first used Open DB diff for our model first migrations. After that we switched to Redgate's SQL compare because it produced more reliable migrations . In our experience DbDiff produced a lot of unnecessary SQL because it bothers with the order that columns are in, and has some other issues like foreign keys constantly being dropped and re-added. Aside from that it still did the job fine, but we had to do a lot of double checking on its generated SQL.

    链接地址: http://www.djcxy.com/p/15982.html

    上一篇: 代码首先生产迁移

    下一篇: 实体框架6模型首次迁移