How to call Database.SetInitializer for a model first?

Question

I created the model in edm-designer (VS10), using the "DbContext Object Generator" as a generation element.

In the generated DbContext subclass, it overrides the constructor, so I cannot use it in another partial class:

public EntitiesContainer() : base("name=EntitiesContainer") { this.Configuration.LazyLoadingEnabled = false; } 

What is the correct way to initialize a database with the first model?

Answer 1

You can modify the T4 template that is used to create the DbContxt class. You can then add partial modifiers or methods that you want to use to initialize your context.

Answer 2

When using the model for the first time, there is no automatic database initialization. You must generate the SQL script from the model (use the context menu in the EDMX designer and select "Create database from model") and execute it yourself on the existing database.

SetInitializer is for code only.