CODEWITHSUNDEEP
entity-framework-5
Joby James
Joby James

Reputation: 429

Entity Framework Code First check Database exist

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?

Upvotes: 1

Views: 7551

Answers (2)

Whopperle
Whopperle

Reputation: 91

This would be a static alternative, that works even without creating the DbContext first:

    System.Data.Entity.Database.Exists(dbNameOrconnectionString);

Upvotes: 0

Mortalzera
Mortalzera

Reputation: 96

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.

Upvotes: 3

Related Questions