Click here to Skip to main content
13,295,987 members (51,639 online)
Click here to Skip to main content
Add your own
alternative version


2 bookmarked
Posted 25 May 2011

EntityFramework CodeFirst – DbContext Initializer

, 25 May 2011
Rate this:
Please Sign up or sign in to vote.
EntityFramework CodeFirst – DbContext Initializer

We already discussed about the EntityFramework CodeFirst approach and how we can generate the database out of the code in

Now, let us see how we can handle the changes to the class, which is the base class for the database tables. We may need to propagate the changes from class to database tables.

Consider our sample Student class, where we are going to add a new property called Address.

public classStudent    {
        publicint Id { get; set; }
        publicstring FirstName { get; set; }
        publicstring LastName { get; set; }

        public string Address { get; set; }
        publicList<Mark> Marks { get; set; }

Now run the application and observe the exception indicating that the model got changed.

Model Change Exception

Model Change Exception

Let us see how we can update the underline Student table with change. For updating the class level changes to table, open the global.asax file. If you are an ASP.NET developer, you may be aware that the global.asax file contains different application and session level event handlers.

Inside the Application_Start method, define the database initializer with one among the two options.

  • DropCreateDatabaseAlways: This will drop and recreate the database in every application start.
  • DropCreateDatabaseIfModelChanges: This will drop and create the database only if the underlined model changes.

DbInitializer Options

DbInitializer Options

We will add the DropCreateDatabaseIfModelChanges with our custom DbContext.

void Application_Start(object sender, EventArgs e)

Run the application and observe the new Student table.

Updated Student Table

Updated Student Table

Add data to the table and run the application.

Result Screen

Result Screen

We can define our own DbContext initializer by inheriting from one among the defined Initializers.

Filed under: Entity Framework Tagged: DbContext, DropCreateDatabaseIfModelChanges, EntityFramework


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Architect TCS
India India
I have over 10 years of experience working on Microsoft Technologies. I am carrying the passion on Microsoft technologies specifically on web technologies such as ASP.Net, HTML5, jQuery and Ajax. My interests also include TFS, Azure, Windows 8, Visual Studio 2010. Technology adoption and learning is my key strength and technology sharing is my passion.

Microsoft MVP: Connected Service Developer

You may also be interested in...

Comments and Discussions

QuestionDatabase.SetInitializer in WPF application Pin
Clayer5-Dec-11 12:31
memberClayer5-Dec-11 12:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.171207.1 | Last Updated 25 May 2011
Article Copyright 2011 by ambilykk
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid