Databases
StackOverflow2013
Postsdbo
POWhat are the data access options a .NET application that uses an Oracle database in late 2013?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhat are the data access options a .NET application that uses an Oracle database in late 2013?
    text
    copied!<p>I'm currently working on a new version of an ASP.NET MVC application that has a Oracle database back-end. When I started development I was surprised to find that it just used ADO.NET commands to connect to Oracle. After speaking to another developer, I found out that they tried switching to the Entity Framework last year, but had a number of performance issues with the framework and they don't want to repeat those issues again. </p> <p>I'm trying to figure out the other options:</p> <ol> <li>Keep using ADO.NET and build a wrapper class the encapsulates the database calls. Basically a custom light-version of Enterprise Library DAAB.</li> <li>Use Enterprise Library DAAB</li> <li>Use NHibernate </li> <li>Entity Framework (Not an option because of performance issues) </li> </ol> <p>Each approach has drawbacks. Since Microsoft's OracleClient provider is deprecated in version 4.0 of the .NET Framework, it only makes sense to use Oracle's ODP.NET provider. This is an issue with Enterprise Library since the current version (6.0) still uses the Microsoft's OracleClient. It looks like there have been people that have swapped out OracleClient for a reference to the ODP.NET, but it doesn't appear to be large group so I'm concerned that we'll run into issues and have little resources if we run into issues.</p> <p>NHibernate uses ODP.NET but development has slowed down and they still haven't released an updated version based on .NET 4.0, even though it has been out for 3 years. It doesn't seem wise to start a new NHibernate effort.</p> <p>Creating a wrapper class would allow us to use ODP.NET, but it is a good deal of work. I hate to spend time recreating the wheel if a better solution exists. </p> <p>Currently this leaves us just creating a light wrapper for ADO.NET. Are there any other valid options in late 2013? I need an option that is supported by a company or has an active community so that we aren't flying solo when we run into issues. </p> <p><strong>UPDATE</strong> Looking at the Enterprise Library DAAB with Oracle ODP.NET Data Provider v6.0 from the Enterprise Library Contrib Project. Anyone have experience with this option? </p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload