Devart Forums

Hi all,

We are currently using Dotconnect for Oracle in our application with success.
We are considering to switch to SQL Server databases system : would it be hard to do the move ?

The idea is to do the least code modification, thing that would have been easy with entity framework just by modyfing the mapping configuration.

I hope there is a way to do that starting from dotConnect ?

1. Assuming that you are using Devart Entity Model (*.edml) with DbContext template, and Entity Developer for Entity Framework (or Professional) is installed on your workstation:
set Fluent Mapping and Database Independent template's properties to True, and Metadata Artifact Processing model's property to Do Not Generate Mapping Files. Then set connection string to your SQL Server via Database Explorer, save the model. Run Update Database From Model Wizard with selected Regenerate storage option. Now the model can be used with SQL Server.

2. There is an example of using the same code with different databases (including Oracle and SQL Server): http://blogs.devart.com/dotconnect/enti ... qlite.html.