Is it possible to use Microsoft Entity Framework with Oracle database?
Take a look at the Sample Entity Framework Provider for Oracle and this blog posting.
DevArt's OraDirect provider now supports entity framework. See http://devart.com/news/2008/directs475.html
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.
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.
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.
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.