Click here to Skip to main content
13,293,178 members (42,552 online)
Click here to Skip to main content
Add your own
alternative version


4 bookmarked
Posted 27 Jun 2012

Ensure Your Code First DB is Always Initialized

, 27 Jun 2012
Rate this:
Please Sign up or sign in to vote.
A quick and easy way to ensure that your Code First DB Initializer is always run when your app starts, not just on the first data access operation


With EF Code First, the built in DB Initializers, DropCreateDatabaseAlways, CreateDatabaseIfNotExists, and DropCreateDatabaseIfModelChanges, and any classes you derive straight from these, only invoke their Seed method when your DbContext based class needs to access the database. This can be frustrating, especially when you are debugging Seed methods and start an application merely to check DB initialization. This tip describes a very simple way to ensure your DB is always initialized before your client app even starts up, without having to write unwanted code in the client app.

How Do I Do This?

Simply invoke a data access method inside a static constructor for your DbContext derivative:

public class TheContext: DbContext
    static TheContext()
        Database.SetInitializer(new DbInitAlways());
        var ctx = new TheContext();
        var r = ctx.Roles.First();
    public DbSet<Role> Roles { get; set; }

Points of Interest

  • The first line above, setting the initializer, should always be changed to set a suitable initializer. Using a DropCreateDatabaseAlways or derivative, like I have, will always drop the database. IT WILL ALWAYS DESTROY ANY TEST DATA YOU HAVE CAPTURED.
  • I just used Roles because it was a convenient and common DbSet on my DbContext. Use any available to you.
  • It is necessary to call First on Roles, and not just Roles, as the latter returns an IQueryable, which only accesses the DB when needed, that is, when iterated, or queried for a specific object.


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


About the Author

Brady Kelly
Founder Erisia Web Development
South Africa South Africa
I am a software developer in Johannesburg, South Africa. I specialise in C# and ASP.NET MVC, with SQL Server, with special fondness for MVC and jQuery. I have been in this business for about eighteen years, and am currently trying to master Angular 4 and .NET Core, and somehow find a way to strengthen my creative faculties.
- Follow me on Twitter at @bradykelly

You may also be interested in...


Comments and Discussions

-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.171207.1 | Last Updated 27 Jun 2012
Article Copyright 2012 by Brady Kelly
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid