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 ?


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.