Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 64 down vote favorite
19

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

share|improve this question
code.msdn.microsoft.com/EFOracleProvider/Release/… – user202021 Nov 3 '09 at 19:35

9 Answers

up vote 17 down vote accepted

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

share|improve this answer
1  
Devart dotConnect for Oracle (formerly OraDirect .NET) now provides support for Entity Framework v4 Release Candidate devart.com/blogs/dotconnect/?p=2062 – Devart Apr 2 '10 at 11:16
You can read more and download trial version of Devart dotConnect for Oracle here - devart.com/dotconnect/oracle. – JackD Dec 7 '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 2:17
up vote 47 down vote

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.

share|improve this answer
3  
+1 I'm deleting my answer. I didn't realize your answer was here. -10 for me, but, you know...maybe I'll get some SO karma... – Brett Mar 11 '11 at 2:19
Oracle will likely release a beta refresh at some point in the future. In case the link above breaks, keep an eye on oracle.com/technetwork/topics/dotnet/whatsnew/index.html for announcements. – Christian Shay Mar 15 '11 at 17:44
Note that Code-First is NOT supported – Burnzy Apr 25 at 15:10
up vote 10 down vote

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.

share|improve this answer
4  
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 6 '10 at 8: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: oracle.com/technetwork/topics/dotnet/whatsnew/… – Christian Shay Sep 4 '10 at 0:01
up vote 7 down vote

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

share|improve this answer
up vote 5 down vote

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.

share|improve this answer
the project "EFOracleProvider" was abandoned at 25/05/2010 – itsho Sep 25 '11 at 19:33
confirmed, I have abandoned it! – Janaka Oct 10 '11 at 14:03
@JA Is this answer still helpful today? If not, we should probably delete it. – Tim Post♦ Dec 13 '11 at 13:24
Would be nice to leave for historical purposes. – Janaka Aug 1 '12 at 14:15
up vote 2 down vote

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

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/dotnet/EntityFrameworkOBE/EntityFrameworkOBE.htm

Hope this helps.

Tim T.

share|improve this answer
up vote 1 down vote

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.

share|improve this answer
what EF provider are you using? – Lucas Jan 21 '11 at 3:29
up vote 1 down vote

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

share|improve this answer
up vote 0 down vote

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.

share|improve this answer
1  
The DataDirect drivers are quite expensive. Devart is moderatly priced and works fine, it is also a lot faster. – vzczc Sep 21 '08 at 8:30
Can Entity framework for oracle support VS2008 Sp1 ? – Niks Jan 21 at 4:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.