How to connect to Oracle from a .NET Application

Use this:

ODP.NET, Managed Driver - Official

https://www.nuget.org/packages/Oracle.ManagedDataAccess/

This short post is just because most of the information you will find on this topic is out-of-date.

Oracle finally wrote a 100% managed code ADO.NET provider and it's available on NuGet.  So you can just right-click on your references and grab the NuGet package.  Not install, no bitness headaches.

David

Comments

• Anonymous
  July 24, 2014

1. Note that the nuget package is not officially maintained or uploaded by Oracle.  (Which they refuse to do due to licensing issues).   That is a 3rd party that has taken the Oracle release off of OTN and reuploaded it to NuGet
2. There are a large number of features that are not yet available in the managed driver. docs.oracle.com/.../intro004.htm

• Anonymous
  July 24, 2014
  Thanks fedak!

• Anonymous
  July 24, 2014
  See this OTN discussion:  community.oracle.com/.../11149050

• Anonymous
  March 05, 2015
  The official Oracle NuGet Packages are out.  I've updated the link above to reflect.