EntityFramework code-first custom connection string and migrations

by

If your migration does not work correctly try to set Database.Initialize(true) in DbContext ctor.

public CustomContext(DbConnection connection)
: base(connection, true)    
{    
        Database.Initialize(true);    
}

I have similar problem with migrations. And in my solution I have to always set database initializer in ctor, like below

public CustomContext(DbConnection connection)
: base(connection, true)    
{    
        Database.SetInitializer(new CustomInitializer());
        Database.Initialize(true);    
}

In custom initializer you have to implement InitalizeDatabase(CustomContex context) method, eg.

class CustomInitializer : IDatabaseInitializer<CustomContext>
{
    public void InitializeDatabase(CustomContext context)
    {
        if (!context.Database.Exists || !context.Database.CompatibleWithModel(false))
        {
            var configuration = new Configuration();
            var migrator = new DbMigrator(configuration);
            migrator.Configuration.TargetDatabase = new DbConnectionInfo(context.Database.Connection.ConnectionString, "System.Data.SqlClient");
            var migrations = migrator.GetPendingMigrations();
            if (migrations.Any())
            {
                var scriptor = new MigratorScriptingDecorator(migrator);
                string script = scriptor.ScriptUpdate(null, migrations.Last());
                if (!String.IsNullOrEmpty(script))
                {
                    context.Database.ExecuteSqlCommand(script);
                }
            }
        }
    }
}

UPDATED

More Related Contents:

  1. Debug code-first Entity Framework migration codes
  2. Entity Framework Code First Using Guid as Identity with another Identity Column
  3. Code-first vs Model/Database-first [closed]
  4. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  5. Reset Entity-Framework Migrations
  6. Unique Key constraints for multiple columns in Entity Framework
  7. Entity Framework 6 Code first Default value
  8. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  9. Improve navigation property names when reverse engineering a database
  10. Using Entity Framework (code first) migrations in production
  11. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  12. EF5 Code First Enums and Lookup Tables
  13. How to configure ProviderManifestToken for EF Code First
  14. Entity framework code-first null foreign key
  15. Entity Framework loading child collection with sort order
  16. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  17. Value cannot be null. Parameter name: entitySet
  18. SQL Server Express connection string for Entity Framework Code First
  19. mapping private property entity framework code first [duplicate]
  20. MVC3 and Code First Migrations – “model backing the ‘blah’ context has changed since the database was created”
  21. EF Migrations: Rollback last applied migration?
  22. How to create index in Entity Framework 6.2 with fluent configuration
  23. Keyword not supported: “data source” initializing Entity Framework Context
  24. Mocking or faking DbEntityEntry or creating a new DbEntityEntry
  25. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  26. EF Code First foreign key without navigation property
  27. AutomaticMigrationsEnabled false or true?
  28. LINQ To Entities + Include + Anonymous type issue
  29. Why does EF5 code first use datetime2 when inserting a nullable datetime into the database?
  30. Entity Framework Core 2.0 – Run migrations step by step

Leave a Comment