Program against a database project using entity framework

Question

Using Visual Studios 2010 I'm creating a project that has a database.

I decided to try to use one of those Database Projects that allow you to manage the database in source control along with the code.

I also think I will use entity framework as my data access tool.

Are there any good solution to tie the EF 4.0 project to the database being managed in the Database project (assuming it's a new db)?

Ladislav Mrnka · Accepted Answer · 2011-09-06 09:31:36Z

5

You simply use your database project to create database for you and you use Database first approach with Entity framework (that means you will use wizard and update from database to create entity model for you).

answered Sep 6, 2011 at 9:31

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

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

3 Comments

Ingó Vals Over a year ago

So it will be very easy to update the EF 4.0 when there are changes to the DB but not automatic. Should I perhaps skip the Database project and just use EF code first instead?

Ladislav Mrnka Over a year ago

It depends on the way how you want to develop the application. Code first = almost no control over the database. Database first with Database project = full control over the database.

cp.engr Over a year ago

Is this the correct workflow for making a db change? (1) Make the change in the Database Project, (2) Build the db project, (3) Publish the db project (to database), and then (4) Update EF Model from the database? It would be nice to be able to update the model directly from the db project, without (3) publishing before I'm ready - are you saying that's not possible? I'm using VS2013 with EF 6.

Russ Clarke · Accepted Answer · 2011-09-06 09:32:17Z

2

I found Scott Guthries 'Code-first' tutorial to be quite good:

http://weblogs.asp.net/scottgu/archive/2010/07/16/code-first-development-with-entity-framework-4.aspx

Let me know if that doesn't quite scratch the itch, I've got a couple of others bookmarked.

answered Sep 6, 2011 at 9:32

Russ Clarke

17.9k4 gold badges44 silver badges45 bronze badges

Collectives™ on Stack Overflow

Program against a database project using entity framework

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related