To use the same DataContext and entity classes for different databases, you should provide different mapping information for the context instances. For example, you can do this via the XML mapping.
In this case you should do the following:
1. Change "Mapping Mode" in model settings to "File". Entity Developer will generate the mapping file ([YourModelName].xml) for the database you are using (Oracle in your case).
2. Make a copy of the generated xml file.
3. Change the connection in the Database Explorer to the necessary one.
4. Check the Target Server in Model Settings -> Synchronization -> Mapping. It must be set to the one that you are going to use (i.e., to SQL Server of the proper version).
5. Run the Update Database Wizard to create the database objects; select the 'Regenerate Storage' option at the first step of the wizard.
6. Save changes and open the mapping file. Now it should contain mapping for the new database.
7. Save this new mapping file somewhere and repeat the previous steps for other databases, if necessary.
For more information about using XML mapping, see
http://www.devart.com/linqconnect/docs/?POCO.html
JIC: When working with different DBMSs it is necessary to clear the "Preserve schema name in storage" check box in the Model Settings.
Also, we recommend you to pay attention to the
fluent mapping approach.