EF Migrations for Database-first approach?

c# entity-framework database-migration
Shaddix picture Shaddix · Feb 13, 2012 · Viewed 22.3k times · Source

We're using Database first approach with EntityFramework. We've several customers, and when we deploy new product version, we're now applying DB schema changes "manually" with tools like SQL Compare.

Is there a way how EF Migrations could help to apply changes to customers DB automatically?

Answer

Paul picture Paul · Feb 13, 2012

As far as I know, EF Migrations is a product targeted at CodeFirst and doesn't support Database First operations.

CodeFirst assumes that you will never make any changes manually to the database. All the changes to the database will go through the code first migrations.

Related questions

EF migration shows empty Up() Down() methods

I have a local database that is currently in it's second version and should now go to it's third version. The code for the previous migrations was generated by another programmer so I am assuming I am doing something wrong …

Read More
Use the ColumnAttribute or the HasKey method to specify an order for composite primary keys

I'm trying to use composite primary key on 2 objects with parent-child relationship. Whenever I try to create a new migration, I get an error: Unable to determine composite primary key ordering for type 'Models.UserProjectRole'. Use the ColumnAttribute or the …

Read More
EF Core Add Migration Debugging

How can I step into OnModelCreating with a breakpoint and see if my logic is wrong or if the ModelBuilder is doing something I'm not expecting? I've seen lots of posts on how to debug the actual migration, but nothing …

Read More