CODEWITHSUNDEEP
asp.net-mvcdatabaseentity-frameworkdbcontext
Jay
Jay

Reputation: 3082

Using MVC with multiple different databases

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?

Upvotes: 0

Views: 533

Answers (1)

Win
Win

Reputation: 62260

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.

Upvotes: 2

Related Questions