Entity Framework provider for Oracle

Question

I want to use linq to sql classes generated by VS or entitty framework, for Oracle databases, how can i do it?

Answer 1

If you have Visual Studio 2008 and use Oracle 10g, then you can use a provider for Oracle from MSDN Code Gallery. It is compatible with EF.

You can't access Oracle with LINQ only, without using Entity Framework.

There is another provider on CodePlex, based on the sample provided below, which works also with Oracle 9i.

Finally, you may be interested in the related Stack Overflow question: Can you use Microsoft Entity Framework with Oracle?

Answer 2

"You can't access Oracle with LINQ only, without using Entity Framework."

Why not? Try to use third party providers - Devart or DataDirect.

I recommend you to try Devart provider - http://www.devart.com/dotconnect/oracle/.