Using MVC with multiple different databases

Question

I have used MVC thus far in a traditional EF sense by creating POCO first objects and then adding this to a database context but I have a new problem in that I am trying to recreate a legacy system but using the MVC framework but it uses a connection to multiple different databases and tables.

In the legacy solution they use Enterprise library to create the link to databases but I am not sure that this is the best option available and was wondering what are the options open for dbconext in regards to different database connections at the same time, is this possible?

Could you provide a few access pattern examples? For example: Are you typically hitting multiple databases with one request? — AJ X.
– AJ X., Commented Feb 4, 2016 at 22:51
MVC doesn't know anything about databases. The only thing that connects to databases as your describing is Entity Framework. I suggest you change your title. — Erik Philips
– Erik Philips, Commented Feb 5, 2016 at 1:04

Win · Accepted Answer · 2016-02-05 01:05:55Z

2

The question is nothing to do with MVC. Besides, ASP.Net MVC (Presentation Layer) should not even need to know about what kind of ORM or database at Data Access Layer.

Back to original question, it is not worth using Entity Framework, if you have to query two databases at the same time.

I suggest you want to look at other ORM like Dapper.

answered Feb 5, 2016 at 1:05

Win

62.4k13 gold badges106 silver badges190 bronze badges

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

2 Comments

Jay Over a year ago

Thanks Win sorry for the confusion in the question dont think I put it very elequoently

nikudale Over a year ago

@Jay I would suggest use nhibernate ORM

Collectives™ on Stack Overflow

Using MVC with multiple different databases

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related