Using LINQ to SQL with Oracle

Question

i know that linq to sql is really "LINQ to SQL Server". I also read that one can build his own LINQ Provider in order to connect to other database systems like oracle or mysql. my question is how to build a LINQ Provider and what are the advantages and disadvantages of using LINQ to SQL on databases other than SQL Server.

try looking at this post http://stackoverflow.com/questions/30790/is-there-a-way-to-use-linq-to-oracle — Dean Chalk, Nov 25 '10 at 11:30

score 12 · Answer 1 · answered Nov 25 '10 at 11:29

LINQ to SQL doesn't support Oracle, but the Entity Framework has a more open provider model, and there are Oracle drivers which support EF.

So basically, for non-SQL Server databases I would ignore LINQ to SQL completely and look to EF. LINQ to SQL simply wasn't built with a provider model for extensibility to arbitrary databases.

score 8 · Accepted Answer · edited Feb 05 '16 at 22:36

8

Here is a good article which describes how to build a LINQ provider:

Building a LINQ Provider

edited Feb 05 '16 at 22:36

Pragmateek

13,174
9
74
108

answered Nov 25 '10 at 13:40

Viper

2,216
1
21
41

1

Whilst this may theoretically answer the question, [it would be preferable](//meta.stackoverflow.com/q/8259) to include the essential parts of the answer here, and provide the link for reference. – Gert Arnold Feb 05 '16 at 16:04

score 5 · Answer 3 · answered Nov 25 '10 at 11:32

5

You can use this LINQ to Oracle

But Linq to SQL not so good for ORM as Nhibernate, or Entity Framework. Nhibernate works with Oracle, MS SQL server, My SQL et. EF - works with MS SQL Server.

answered Nov 25 '10 at 11:32

Sergey K

4,071
2
23
34

score 4 · Answer 4 · answered Dec 24 '10 at 15:03

4

You can try 3-rd party ORMs - for example, LinqConnect, NHibernate, etc. But as for me - LINQ to SQL is flexible and allows you to start quickly.

answered Dec 24 '10 at 15:03

JackD

597
4
7

Using LINQ to SQL with Oracle

4 Answers4

Linked