Which database providers support LINQ to SQL?

Question

I'm kind of new using LINQ to SQL, and when I try to use db servers without sql, I get an error that it is an unsupported data provider. Is there a way to get LINQ to work with dbs, such as sdf and Oracle and SQL files?

Answer 1

To use LINQ to communicate with this base database, you need to obtain a specific database provider. For oracle try the following codeplex project

• http://www.codeplex.com/LinqToOracle

Answer 2

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

Answer 3

Not officially, but there are many projects that implement LINQ to SQL for other databases, for example: http://www.codeplex.com/LinqToOracle

Answer 4

Although you have specified LINQ to SQL, you can also consider the Entity Framework , which supports different databases. Here you can find supported providers . The first 3 providers on this page support ORACLE.

Answer 5

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

Answer 6

Take a look at the Devart LINQ to Oracle tutorial .

But keep in mind that you cannot mix data from SQL Server and Oracle datacontexts.