ModelFirst and different DB

JoeRuspante · Post by **JoeRuspante** » Tue 20 Mar 2012 12:06

I'd like to understand how to change the Database in a ModelFirst application.

In my case I have all this projects in a solution:

-) CORE (the main program. The Model designer creates the classes in this project)

-) MODEL (only the design of the classes. File edml)

-) DAL (the mapping with the DB. The Model designer creates the DbContext in this project)

Now I'd like to add a new DB to the solution (for work with Oralce and SQL Server with the same model).

How can I map in the Model designer (MODEL project) the fact that the class "User" is mapped on Oracle with the table "SYS_USER" and on SQL Server is mapped with the table "MY_USER"?

I hope the request is clear and easy to understand.

Thank you in advance

Shalex · Post by **Shalex** » Fri 23 Mar 2012 14:00

Please refer to http://www.devart.com/forums/viewtopic.php?t=23600.