94

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

Cyrus
  • 1,913
  • 2
  • 17
  • 34
Xerx
  • 3,663
  • 7
  • 29
  • 28
  • http://code.msdn.microsoft.com/EFOracleProvider/Release/ProjectReleases.aspx?ReleaseId=1395 –  Nov 03 '09 at 19:35

7 Answers7

79

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
  • 4,633
  • 6
  • 39
  • 46
Venkat
  • 1,085
  • 1
  • 8
  • 12
  • Oracle will likely release a beta refresh at some point in the future. In case the link above breaks, keep an eye on http://www.oracle.com/technetwork/topics/dotnet/whatsnew/index.html for announcements. – Christian Shay Mar 15 '11 at 17:44
  • 1
    Note that Code-First is NOT supported – Pierluc SS Apr 25 '13 at 15:10
  • 1
    now, in 2013, any driver fully managed .NET for Oracle (EF included) ? – Kiquenet Aug 02 '13 at 11:19
  • @Kiquenet - In 2015 (and probably earlier) Oracle has a managed driver that supports Entity Framework. It's available in NuGet. – Theophilus May 18 '15 at 16:57
27

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

Arno
  • 1,947
  • 1
  • 13
  • 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
  • 19,739
  • 21
  • 90
  • 126
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
  • 55,135
  • 22
  • 172
  • 222
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,191
  • 21
  • 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
  • 49,287
  • 10
  • 99
  • 143
  • 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