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?
-
check this stackoverflow.com/a/13198899/87956Vinay Pandey– Vinay Pandey2013-11-12 04:40:18 +00:00Commented Nov 12, 2013 at 4:40
-
possible duplicate of Is there a command to check to see if a database exists from Entity Framework?Gert Arnold– Gert Arnold2013-11-12 06:53:15 +00:00Commented Nov 12, 2013 at 6:53
Add a comment
|
2 Answers
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.
2 Comments
nKn
Even if your comment might be correct, adding a little explaination of what does your solution do and why it works in tue OP's context, won't harm and will encourage other users to upvote your answer.
Mortalzera
I could not care less about upvoting, but you are right, a little explanation could help the others = ].
This would be a static alternative, that works even without creating the DbContext first:
System.Data.Entity.Database.Exists(dbNameOrconnectionString);
