Share via


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.