ModelFirst and different DB
Posted: 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
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