For those of you who have been working with Entity Framework and were wondering if there are any providers for Oracle, there are a couple of providers that might suite you, you can see a list of them in EF’s MSDN web site:
http://msdn.microsoft.com/en-us/data/dd363565.aspx
A new player has just joined the play ground – DataDirect and their new beta version of EF provider. You can read and download from here:
http://www.datadirect.com/products/net/beta/index.ssp
As for now, we are using Devart’s EF provider for oracle (dotConnect):
http://www.devart.com/dotconnect/entityframework.html
Devart’s provider has a few problems when trying to do things that aren’t basic, such as using stored procedures for CUD operations and having problematic LOB types that Oracle has problems with as part of the storage model, but there are some workarounds and Devart is releasing new version every once in a while, so we are hoping for brighter future
I promise to take a look at DataDirect’s provider to see if some of Devart’s problems were solved there and I will publish my findings later on.