Can you use Microsoft Entity Framework with Oracle?

.NetOracleEntity Frameworkodp.net

.Net Problem Overview


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

.Net Solutions


Solution 1 - .Net

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.

Solution 2 - .Net

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

Solution 3 - .Net

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

[1]: http://www.oracle.com/technetwork/topics/dotnet/whatsnew/oracle-entity-framework-sod-130214.pdf "Statement of direction: Oracle Database and Microsoft Entity Framework"

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

Solution 4 - .Net

Solution 5 - .Net

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

Solution 6 - .Net

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.

Solution 7 - .Net

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionXerxView Question on Stackoverflow
Solution 1 - .NetVenkatView Answer on Stackoverflow
Solution 2 - .NetArnoView Answer on Stackoverflow
Solution 3 - .NetGazmoView Answer on Stackoverflow
Solution 4 - .Nettim theobaldView Answer on Stackoverflow
Solution 5 - .NetkimskView Answer on Stackoverflow
Solution 6 - .NetgbjbaanbView Answer on Stackoverflow
Solution 7 - .NetMateus BenettiView Answer on Stackoverflow