Create database if exists Entity Framework Model First

Question

Is there a way to have entity framework create a database to the users my documents folder with model first? I've tried a few statements in the DbContext's contructor but it keeps telling me that the database does not exist. This is a with 6.1.1 using a local database only with entity framework sqlserver compact. The only way I'm able to get a database created is manually in in the server explorer and have it made from the edmx generator but that won't work since the application will be installed on various machines.

Samuele · Accepted Answer · 2014-10-20 13:51:29Z

1

Simply put, no. Database initializers and/or migrations only work with Code First, so your best bet is to generate SQL for your database and check if the database already exists during your application startup, then execute the generated script against the configured connection string.

answered Oct 20, 2014 at 13:51

Samuele

1512 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

shady Over a year ago

Thanks I'll try that out tomorrow. Worst case ill use code first. I couldn't find any info on this.

Collectives™ on Stack Overflow

Create database if exists Entity Framework Model First

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related