23
votes

I have added EF 5 to my project via Nuget and enabled migrations with the "Enable-Migrations" command. I have then called "Add-Migration" to generate the base code for generating the schema.

I then added a property to one of my domain objects (string property called "TestProperty") and added a mapping to my EntityTypeConfiguration file (we're ignoring the conventions at the moment).

Calling "Add-Migration" again produces the error:

Unable to generate an explicit migration because the following explicit migrations are pending: [201303262144218_Initial]. Apply the pending explicit migrations before attempting to generate a new explicit migration.

But calling "Update-Database" produces a sql exception because the tables already exist:

There is already an object named 'Customer' in the database

In my constructor for my DbContext I have tried the different update strategies, e.g.:

Database.SetInitializer<UnitOfWork>(new DropCreateDatabaseAlways<UnitOfWork>());

Am I missing something obvious? I tried the solution here but it didn't work: Automatic Migrations for ASP.NET

Thanks

EDIT: Update The key to getting past the first step is to create the initial migration and then delete the generated code from the Up and Down methods (http://thedatafarm.com/blog/data-access/using-ef-migrations-with-an-existing-database/).

I can then update the model and the EF map and then run Add-Migration. This generates a migration with the correct Up and Down code.

The problem is then trying to apply the update. Update-Database produces the error "Unable to update database to match the current model because there are pending changes and automatic migration is disabled...automatic migration. Set DbMigrationsConfiguration.AutomaticMigrationsEnabled to true to enable automatic migration. You can use the Add-Migration command to write the pending model changes to a code-based migration". Ok, so I try Add-Migration again and it produces another migration with the exact same code as the last one.

I run Update-Database and get the same error again. I try "Update-Database -TargetMigration 201304080859556_MyMigration -Force" but this produces "The specified target migration '201304080859556_MyMigration' does not exist. Ensure that target migration refers to an existing migration id" - It does!

Very frustrating!

7
Is there an existing file in your Migrations directory called 201303262144218_Initial.cs?MattSull
Yes. I'm a little confused - is the initial migration supposed to be blank or is it supposed to create the database in it's initial state? Also, I don't have a __MigrationHistory table (in either my database or Master)SturmUndDrang
Initial is just a name given to that particular migration. Sometimes people call their first migration initial. If you had an existing db, and ran the add-migration/update-database command without making any changes to your model classes the migration file would be empty. Delete the file 201303262144218_Initial.cs, and then run the two commands again ('add-migration newestMigration' then 'update-database'.MattSull

7 Answers

27
votes

I had the same problem enabling EF migrations for a code-first model with an existing database, and the following procedure worked:

  1. Remove the existing Migrations folder in your project, and DROP the table __MigrationHistory from the existing database.
  2. Run the enable-migrations command from the Package Manager Console.
  3. Run the add-migration command to create an initial migration.
  4. Remove all of the code in Up() method for the initial migration.
  5. Run the update-database command to apply the initial migration to your database. This doesn't make any changes to existing objects (because the Up() method contains no code), but it marks the existing database as having been migrated to the initial state.
  6. Make changes to your code-first model.
  7. Run the add-migration command to create a new migration. The code in the Up() method of the new migration will contain only the changes to your object model.
  8. Run the update-database command to apply the changes to your database.
9
votes

I run Update-Database and get the same error again. I try "Update-Database -TargetMigration 201304080859556_MyMigration -Force" but this produces "The specified target migration '201304080859556_MyMigration' does not exist. Ensure that target migration refers to an existing migration id" - It does!

There is one more issue which may cause your last error (and maybe it's a root cause of previous ones). I had a similar problem and it turned out that for some strange reason some of my migration classes where in a different namespace than the namespace of my MigrationConfiguration class. Correcting namespaces (also in xxx.Designer.cs files) solved this issue (migrations were visible and working again).

3
votes

Did you try using the -force parameter to apply the changes.

Update-Database [-SourceMigration <String>]
  [-TargetMigration <String>] [-Script] [-Force] [-ProjectName <String>]
  [-StartUpProjectName <String>] [-ConfigurationTypeName <String>]
  [-ConnectionStringName <String>] [<CommonParameters>]

-FORCE Specifies that data loss is acceptable during automatic migration of the database.

You can use get-help Update-Database -examples to see usage examples.

Further read: EF Code First Migrations

2
votes

You do not need to remove the migration manually, remove it conveniently with

Remove-Migration

then you can recreate the migration script again with Add-Migration.

In your case, updating the database failed because there are existing tables, drop them with

Drop-Database

Then you can Update-Database.

More detailed usage of these commands are here.

1
votes

Trying to migrate an old db version to a new model, either the database didn't match the new model or i got errors like :

Type is not resolved for member 'Npgsql.PostgresException,Npgsql, Version=3.2.2.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7'

Here's how it worked (using automatic migration) :

  1. Delete Migrations folder
  2. Execute enable-migrations
  3. Set this two properties to true in the newly created Configuration.cs

    public Configuration()
    {
        AutomaticMigrationsEnabled = true;
        AutomaticMigrationDataLossAllowed = true;
    }
    
  4. Execute Update-Database -Force

Your database will be updated to latest scheme and ready.

hope this helps.

0
votes

This is a blanket approach that usually works:

  1. Delete your entire Migrations folder (make sure that you copy any code that you might have created from the seed method in your migration configuration file).
  2. Delete the actual database. If you are using LocalDb, this will normally sit within your AppData solution folder (Right-click -> open folder location). Make sure to delete the .mdf & .log database files.
  3. Go to Package Manager Console. Enter enable-migrations -projectname yourprojectname
  4. Go to Package Manager Console. Enter add-migration "Initial" -projectname yourprojectname.
  5. Open the migration configuration file and paste the code that you copied from step 1 into the seed method.
  6. Go to Package Manager Console. Enter update-database -projectname yourprojectname

This should do the trick.

0
votes

1) Remove the existing Migrations folder in your project, and delete existing migration from Migration_History table if any.

2)Run the following command from the package manager console:

add-migration reset

3)After that run the following command from the package manager console:

Remove-Migration

4)After that run the following command from the package manager console (InitialMigration is the name of the first migration, you can name as you want ):

add-migration InitialMigration