98

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

Cyrus
  • 2,261
  • 2
  • 22
  • 37
Xerx
  • 3,755
  • 8
  • 32
  • 28
  • http://code.msdn.microsoft.com/EFOracleProvider/Release/ProjectReleases.aspx?ReleaseId=1395 –  Nov 03 '09 at 19:35

7 Answers7

81

Update:

Oracle now fully supports the Entity Framework. Oracle Data Provider for .NET Release 11.2.0.3 (ODAC 11.2) Release Notes: http://docs.oracle.com/cd/E20434_01/doc/win.112/e23174/whatsnew.htm#BGGJIEIC

More documentation on Linq to Entities and ADO.NET Entity Framework: http://docs.oracle.com/cd/E20434_01/doc/win.112/e23174/featLINQ.htm#CJACEDJG

Note: ODP.NET also supports Entity SQL.

Chris Weber
  • 5,555
  • 8
  • 44
  • 52
Venkat
  • 1,105
  • 1
  • 8
  • 12
27

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

Arno
  • 2,169
  • 1
  • 15
  • 12
  • 1
    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 Apr 02 '10 at 11:16
  • You can read more and download trial version of Devart dotConnect for Oracle here - http://www.devart.com/dotconnect/oracle/. – JackD Dec 07 '10 at 16:42
  • For Model-first, the devArt dotConnect DDL generation template makes a much more sensible stab at data types than the first-cut Oracle beta (eg: doesn't just make everything Numeric(38,0)). The Oracle template doesn't even generate sequences for identity fields... – piers7 Jun 29 '11 at 02:17
11

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

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

Sathyajith Bhat
  • 21,321
  • 22
  • 95
  • 134
Gazmo
  • 227
  • 2
  • 3
  • 5
    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 Aug 06 '10 at 08:30
  • 1
    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 Sep 04 '10 at 00:01
5

Yes. See this step by step tutorial of Entity Framework, LINQ, and Model-First for the Oracle database (11G), and using Visual Studio 2010 with .NET 4.

Ruben Bartelink
  • 59,778
  • 26
  • 187
  • 249
tim theobald
  • 51
  • 1
  • 1
4

In case you don't know it already, Oracle has released ODP.NET which supports Entity Framework. It doesn't support code first yet though.

http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

kimsk
  • 2,221
  • 22
  • 23
1

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
  • 51,617
  • 12
  • 104
  • 148
  • what EF provider are you using? – Lucas Jan 21 '11 at 03:29
  • FYI - The APPLY SQL keyword was added to Oracle Database 12c. So eventually this issue will fade away as people move to this version of the database. The scenarios where APPLY shows up are not that common. – Christian Shay Feb 23 '14 at 00:02
1

Now has a new nuget package, try use it: https://www.nuget.org/packages/Oracle.ManagedDataAccess.EntityFramework/

Mateus Benetti
  • 173
  • 1
  • 1
  • 9