Generated dbml-Files for use with other DBs ?

Jeb · Post by **Jeb** » Wed 18 Feb 2009 19:23

Hi ,

i am currently trying the devart Connection to Oracle.
At the time, i am able to select data from an oracle connection.
Now i wanted to try to use the generated dbml file with an other DB-Connection ( SQL-Server instead of Oracle)

So i changed the connection... but it doesn't work....

Is it generally possible to switch form one db to another only with switching the connection string and provider like in nhibernate ?

AndreyR · Post by **AndreyR** » Thu 19 Feb 2009 10:05

There is no problem in such switching in Entity Framework (.edmx file). You can refer to our EFQuerySamples,
which use one conceptual model and several storage models (for Oracle, MySQL, PostgreSQL, MS SQL and SQLite).
Samples are available here:
http://download.devart.com/File.aspx?pr ... amples.zip
If you are using LINQ to Oracle (.dbml file), there is no way to switch between databases - it is DB-specific.

Jeb · Post by **Jeb** » Thu 19 Feb 2009 11:51

Oh Thanks!
i worked with Linq to SQL.....