EF - switch between Firebird and Oracle databases in runtime

I used ASP.NET MVC, Entity Framework Model First and Firebird database. Now we added Oracle database with same tables and fields and I want switch connection between Firebird and Oracle in runtime.

It is possible to use one data model for both databases ? Or, maybe, i need to create separate data models, but how I can used them ?

Answers


Yes it is possible.

If you create an EDMX for each DB with the exact same CSDL section and generate classes for only one of them, then you can create a context that connects to the DB you want by specifying the correct connection string (which includes the correct EDMX elements (SSDL, CSDL, MSL)).


Need Your Help

Social Media Database Design: Should user-centric tables be created? Or master tables with the relevant data?

php mysql database

I'm trying to understand, conceptually, the design of a social media site. I've seen on Database Answers that a sample model has a "Me" table, myMovements, myProfiles which I assume are unique to the

Blurry background images after update to IE11

css background-image internet-explorer-11

So this morning I got an automatic update to IE 11, after checking my eyes it appears that some of my background images are blurry.