Generated dbml-Files for use with other DBs ?

Generated dbml-Files for use with other DBs ?

Postby 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 ?
Jeb
 
Posts: 4
Joined: Wed 18 Feb 2009 19:15

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby Jeb » Thu 19 Feb 2009 11:51

Oh Thanks!
i worked with Linq to SQL.....
Jeb
 
Posts: 4
Joined: Wed 18 Feb 2009 19:15


Return to LinqConnect (LINQ to SQL support)