I've got to look at the ORM solution for a new ASP.NET Web App with an Oracle backend.
Has anyone had good/bad experience with using Entity Framework with Oracle?
Are there any (free preferably) alternatives?
+1
A:
I dont have any experience with EF but nhibernate is a very good alternative.
Have a look at the screen casts by Stephen Bohlen at summer of nhibernate for a great introduction to nhibernate.
Nathan Fisher
2009-07-09 03:31:34
+1
A:
Microsoft doesn't have a supported option for Oracle for the Entity Framework - all the current options are non-free 3rd party providers.
NHibernate works very well with Oracle in my experiences, as does LLBLGenPro (not free, but has a reasonably priced per-developer license for the entity mapping designer).
jspru
2009-07-09 03:47:01
I had a feeling MS doesn't have a supported option - the documentation mentions that EF will work against **any** datasource, but I couldn't find any specifics. Thanks very much for clearing that up.
2009-07-09 03:56:13
A:
Both Microsoft Oracle Client and ODP.NET does not support Entity Framework and LINQ to SQL. DataDirect in their new Beta version supports Entity Framework but does not support LINQ to SQL. Devart dotConnect for Oracle supports both Entity Framework (and LINQ to Entities) and LINQ to Oracle (Oracle-specific implementation of LINQ to SQL).
Devart
2009-07-09 06:42:12
A:
J A
2009-09-21 00:54:43
+1
A:
We've had great success with Oracle 11g and Entity Framework 1.0 (Visual Studio 2008 SP1) on my current project. To bridge the gap with the out of the box functionality, I've implemented a free tool from CodePlex called the EF Oracle ODP Provider. This leverages the latest Oracle data providers and provides a wrapper to enable Entity Data Model generation. Unfortunately, it does not integrate well with the Entity Designer built into Visual Studio, so you have to run a few command line utilities to get your model stood up and maintained.
You can find out more here: http://eforacleodpprovider.codeplex.com/.
ValueCoder
2010-05-07 15:02:15
+1
A:
During June, 2010, Oracle released a statement of direction regarding support for Microsoft ADO.NET Entity Framework:
Oracle plans to enhance Oracle Data Provider for .NET (ODP.NET) to support ADO.NET Entity Framework. Oracle database developers will be able to use Visual Studio tools and APIs that are a standard part of the ADO.NET Entity Framework.
ADO.NET Entity Framework is a client-side/middle-tier technology. As such, the Oracle’s client software and ODP.NET will integrate directly with Entity Framework to support data access with the Oracle Database.
Oracle plans on releasing a beta "Around the end of 2010" and to production in 2011.
More information can be found by downloading the Statement of Direction itself.
dnorthut
2010-07-13 23:00:41