Page 1 of 1

Generated dbml-Files for use with other DBs ?

Posted: Wed 18 Feb 2009 19:23
by Jeb
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 ?

Posted: Thu 19 Feb 2009 10:05
by AndreyR
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.

Posted: Thu 19 Feb 2009 11:51
by Jeb
Oh Thanks!
i worked with Linq to SQL.....