Multiple Entity Framework for Same Database

Question

Can we create multiple entity framework in project for the same database? I want to create entity framework for each subsystem. Some of subsystem have shared table.

You mean you want to create multiple conceptual data models on top of that database? Yes, that's absolutely possible. Have you tried it? If so: did you have any problems/issues? If yes: what problems/issues?? — marc_s
– marc_s, Commented Aug 22, 2012 at 4:52

Sizons · Accepted Answer · 2015-09-10 12:16:57Z

6

It's possible, and you can create multiple EDMX files as you wish.

But it's not recommmended, as...

You can not query multiple tables in different models.
Defining boundary will be very difficult because mostly tables are connected through relationships.
If same table exists in multiple models, then you will have consistency issues and namespace clashes.

Instead, we created only one EDMX model and put it in a common library, which is then imported in many different sub projects.The only problem is, your connection string has to be defined correctly specifying common library resources.

edited Sep 10, 2015 at 12:16

Sizons

6842 gold badges9 silver badges24 bronze badges

answered Aug 22, 2012 at 5:54

Akash Kava

40.1k21 gold badges126 silver badges173 bronze badges

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

Collectives™ on Stack Overflow

Multiple Entity Framework for Same Database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related