Entity Framework Database.SetInitializer simply not working

by

The database will only be created when you actually use the context.

If you have overridden the Seed method in your initializer as follows:

protected override void Seed(MyContext context){...}

The Seed code will only run when you use an instance of MyContext.

That is why it works when you use

var ctx = new MyContext();
ctx.Database.Initialize(true);

You could always force it to create by using your context in the Application_Start() method in Global.asax.cs like:

        System.Data.Entity.Database.SetInitializer(new MyInitializer());

        MyContext db = new MyContext();
        db.Database.Initialize(true);
        //or even something like db.Users.Count();

Or it will be created later on when you use your context. It might have looked like it had stopped working because you removed some code that would use the context on application startup.

More Related Contents:

  1. One DbContext per request in ASP.NET MVC (without IOC container)
  2. How Should I Declare Foreign Key Relationships Using Code First Entity Framework (4.1) in MVC3?
  3. Overriding SaveChanges and setting ModifiedDate, but how do I set ModifiedBy?
  4. Forcing code-first to always initialize a non-existent database?
  5. Entity Framework Code First – two Foreign Keys from same table
  6. Enable ‘xp_cmdshell’ SQL Server
  7. Entity Framework code first. Find primary key
  8. Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation
  9. SQL MERGE statement to update data
  10. A transport-level error has occurred when receiving results from the server [closed]
  11. Can you create sql views / stored procedure using Entity Framework 4.1 Code first approach
  12. Entity framework code-first null foreign key
  13. storing passwords in SQL Server
  14. How does sql server sort your data?
  15. How to configure many to many relationship using entity framework fluent API
  16. How to restore to a different database in SQL Server?
  17. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  18. Navigation Property without Declaring Foreign Key
  19. Entity Framework – Is there a way to automatically eager-load child entities without Include()?
  20. How to get week number of the month from the date in sql server 2008
  21. Optional parameters in SQL Server stored procedure
  22. An error occurred while saving entities that do not expose foreign key properties for their relationships
  23. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  24. Cannot open backup device. Operating System error 5
  25. Entity Framework Code First Date field creation
  26. Convert DBContext to ObjectContext for use with GridView
  27. T-SQL strip all non-alpha and non-numeric characters
  28. Nullable property to entity field, Entity Framework through Code First
  29. Entity Framework Validation confusion – maximum string length of ‘128’
  30. Entity Framework Code First Many to Many Setup For Existing Tables

Leave a Comment