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
- 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
- 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/.../11149050Anonymous
March 05, 2015
The official Oracle NuGet Packages are out. I've updated the link above to reflect.