Entity Framework code first - initial code migration not working

Question

I am trying to run migrations from code. I created my models and enabled-migrations and then added initial migration, this initial migration contains all the create tables etc

public partial class Initial : DbMigration
 {
     public override void Up()
     {
        CreateTable(..........
     }

 public override void Down()
    {
           DropTable(...........
     }
}

I then tried the Update-Database command from the visual studio which works fine, creates the database and runs the initial migration.

I then delete the database from the Sql Studio. Then I run the console app that calls the Migration Manager class

// MigrationManager class

    public static bool PerformMigration(string migrationId)
    {
        bool success = false;
        try
        {
            DbMigrationsConfiguration<MyDbContext> config = new Configuration();
    ....
            DbMigrator migrator = new DbMigrator(config);
            migrator.Configuration.AutomaticMigrationsEnabled = false;
            if (string.IsNullOrEmpty(migrationId))                    
                migrator.Update(); --> fails saying pending migration
            else
                migrator.Update(migrationId);

            success = true;
        }
        catch (Exception e)
        {
            success = false;
            LastException = e.Message;
        }

        return success;
    }

The Update() fails with the following error:

Unable to update database to match the current model because there are pending changes and automatic migration is disabled. Either write the pending model changes to a code-based migration or enable automatic migration. Set DbMigrationsConfiguration.AutomaticMigrationsEnabled to true to enable automatic migration.

//Configuration.cs
internal sealed class Configuration : DbMigrationsConfiguration<MyDbContext>
{
    public Configuration()
    {
        AutomaticMigrationsEnabled = false;
    }

    protected override void Seed(WorkflowConfigurationDbContext context)
    {
        SeedData(context);
    } 
    private void SeedData(){...}    

}

public class MyDbContext : DbContext
{
    public MyDbContext()
    {            
    }        

    public DbSet....

    }

When I step through the Update() call, it goes into Configuration() constructor and MyDbContext() constructor but fails after that, it seems like its not trying the Initial migration at all.

L-Four · Accepted Answer · 2015-05-13 13:44:50Z

0

Make sure the database initialization strategy is correct in your EF context's constructor, like:

 public partial class YourContext: DbContext
 {
     static YourContext()
     {
         Database.SetInitializer<YourContext>(new CreateDatabaseIfNotExists<YourContext>());
     }
 }

This is executed the first time the database is accessed.

EDIT: A second issue may be about security: does the user that is executing the migration have the required permissions?

edited May 13, 2015 at 13:44

answered May 13, 2015 at 11:44

L-Four

13.6k9 gold badges73 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

wk4questions Over a year ago

Thanks for your reply, I have already tried that with no success :(

L-Four Over a year ago

Edited my answer: what about security?

Pang · Accepted Answer · 2015-06-14 07:03:14Z

0

Found the issue, it was incorrect namespace.

DbMigrationsConfiguration<MyDbContext> config = new Configuration();
config.MigrationsNamespace = "Correct Namespace";

edited Jun 14, 2015 at 7:03

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered May 13, 2015 at 13:39

wk4questions

1351 gold badge2 silver badges13 bronze badges

Collectives™ on Stack Overflow

Entity Framework code first - initial code migration not working

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related