Click here to Skip to main content
15,884,177 members
Articles / Desktop Programming / Win32
Tip/Trick

Ensure Your Code First DB is Always Initialized

Rate me:
Please Sign up or sign in to vote.
4.89/5 (2 votes)
27 Jun 2012CPOL1 min read 18.5K   5  
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

Introduction

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:

C#
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.

License

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


Written By
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

Comments and Discussions

 
-- There are no messages in this forum --