views:

13789

answers:

7

Is it possible to use Microsoft Entity Framework with Oracle database?

+3  A: 

Take a look at the Sample Entity Framework Provider for Oracle and this blog posting.

sixlettervariables
+4  A: 

DevArt's OraDirect provider now supports entity framework. See http://devart.com/news/2008/directs475.html

Arno
Devart dotConnect for Oracle (formerly OraDirect .NET) now provides support for Entity Framework v4 Release Candidate http://www.devart.com/blogs/dotconnect/?p=2062
Devart
A: 

You may also want to take a look at DataDirect who has announced that they will support the Entity Framework in their Oracle provider in Q3 of 2008.

YeahStu
The DataDirect drivers are quite expensive. Devart is moderatly priced and works fine, it is also a lot faster.
vzczc
+4  A: 

Hi, We have taken the Sample provider mentioned above (EFOracleProvider) and converted it (very quickly) to use ODP.net 11.1 rather than system.data.oracleclient (this is deprecated in .net 4.0). The project EFOracleOdpProvider is available at http://eforacleodpprovider.codeplex.com/ . Any contributions and feebback would be useful to everybody.

J A
+5  A: 

Oracle have announced a "statement of direction" for ODP.net and the Entity Framework: link text

In summary, ODP.Net beta around the end of 2010, production sometime in 2011.

Gazmo
By then V5 of the EF would have shipped, oracle seems to be doing what ever it can get away with to mark it hard to use .net with oracle and Microsoft is doing what ever it can get away with it make it hard to use oracle with .net
Ian Ringrose
The Oracle website got redesigned and some links got broken. Here is the new link for the Oracle and Entity Framework statement of direction:http://www.oracle.com/technetwork/topics/dotnet/whatsnew/oracle-entity-framework-sod-130214.pdf
Christian Shay
+1  A: 

The answer is "mostly".

We've hit a problem using it where the EF generates code that uses the CROSS and OUTER APPLY operators. This link shows that MS knows its a problem with SQL Server previous to 2005 however, they forget to mention that these operators are not supported by Oracle either.

gbjbaanb