Using LINQ to SQL with Oracle [closed]

Closed. This question needs to be more focused. It is not currently accepting answers.

---

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

开发者_如何学编程

Closed 6 years ago.

Improve this 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.

---

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.

---

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

Building a LINQ Provider

---

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.

---

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.