Entity Framework Code First check Database exist

Question

In Entity Framework Code first i want to check database is exist before create Database. In code first when i call Entities dc = new Entities() then it goes to OnModelCreating and generate Database. How can i check if the Database exists in Entity framework Code first?

Answer 1

You can do:

using(var dbContext = new MyContext())
{
    if (!dbContext.Database.Exists())
        dbContext.Database.Create();
}

Edit:

Following the colegue sugestion, the meaning of this code is very simple: Supose your context constructor is not set to create the database, so before sending any database operations, you can check if it exists, if not, you can create a new one with the connection string parameters being the rules for the creation.