Entity Framework "Code First" not seeding or creating databases - no errors

Question

For some reason my DB is not being created and i'm not getting any errors. I'm using "SQL Server"

Tring to initialize the DB in the global.asax.ca file:

protected void Application_Start(object sender, EventArgs e)
{
     //BREAKPOINT HITS. GOOD
     Database.SetInitializer<MenuManagerContext>(new MenuManagerServiceInitializer()); 
}

...

public class MenuManagerServiceInitializer : CreateDatabaseIfNotExists<MenuManagerContext>
{
    //BREAKPOINT NEVER HITS. BAD
    protected override void Seed(MenuManagerContext context)
    {
        context.Chains.Add(...);

        context.SaveChanges();

        base.Seed(context);
    }
}

Any ideas why the database is not being created? I'm not even getting errors so it's very hard to tell what is wrong...

Slauma · Accepted Answer · 2011-08-10 19:10:11Z

8

Database.SetInitializer doesn't cause the database to be created. It's only setting the initialization strategy.

The DB is created if you are using a context for the very first time, for instance by issuing any query, or by attaching or adding an object to the context, and so on.

answered Aug 10, 2011 at 19:10

Slauma

177k60 gold badges407 silver badges424 bronze badges

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

2 Comments

DineshNS Over a year ago

I have similer case as above. Before it works fine. lat time I added about 15 entities. After that db creation stops. No errors pops up. no db created. But ONModelCreating is get called in context. How do I know the reason to happen this ?

Slauma Over a year ago

@DineshN.Samarathunga: I don't know. I'd recommend to ask and describe the problem in a new question.

lcranf · Accepted Answer · 2011-08-11 01:59:11Z

1

Make a call to an Action that returns data through your context

public ActionResult Index()
{
    //should trigger call to MenuManagerServiceInitializer.Seed()
    return View(new MenuManagerContext().Chains.ToList())
}

answered Aug 11, 2011 at 1:59

lcranf

1711 gold badge1 silver badge6 bronze badges

Collectives™ on Stack Overflow

Entity Framework "Code First" not seeding or creating databases - no errors

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