CODEWITHSUNDEEP
linq-to-sql
Alex
Alex

Reputation: 40395

What database vendors does LINQ to SQL support?

I'm kind of new using LINQ to SQL and when ever I try to use a non sql server dbs I get an error that it is an unsupported data provider. Is there a way to get LINQ to work with dbs like Oracle and SQL sdf files?

Upvotes: 4

Views: 4334

Answers (6)

Devart
Devart

Reputation: 121922

Take a look at the Devart LINQ to Oracle tutorial.
But please note that you are not able to mix data from SQL Server and Oracle datacontexts.

Upvotes: 0

ali62b
ali62b

Reputation: 5403

If you want start a new project that is not SQL Server and you want to use a Microsoft ORM I recommend you to start using Entity Framework which supports MySQL and Oracle and ... and also you can use LINQ to Entity to communicate between your application and EF generated classes. Hope this helps

Upvotes: 0

Ahmad Mageed
Ahmad Mageed

Reputation: 96487

Although you specified LINQ to SQL you might also want to consider the Entity Framework which does support different databases. You can find some supported providers here. The first 3 providers on that page support ORACLE.

Upvotes: 0

kersny
kersny

Reputation: 2807

The DbLinq project supports all of Linq to Sql's features over MySQL, PostgreSQL, Oracle and SQLite, as well as some unique features. It is also the base of Mono's implementation of Linq to Sql.

Upvotes: 3

Mark Byers
Mark Byers

Reputation: 838226

Not officially, but there are a variety of projects implementing LINQ to SQL for other databases, for example: http://www.codeplex.com/LinqToOracle

Upvotes: 1

JaredPar
JaredPar

Reputation: 754745

In order to use LINQ to communicate with a given DB backend, you need to get a DB specific provider. For oracle, try the following project on codeplex

Upvotes: 3

Related Questions