Oracle Odac Drivers Are Another#
Oracle Odac Download Page If#
Oracle Odac Driver You Should#

Oracle Odac Driver You Should

Install the 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio. That's the driver you should make your DSN from. Go to the Drivers tab of the ODBC Adminstrator and you should see something along the lines of 'Oracle in OraClient11ghome1' with a version of 11.something. There should be an additional ODBC driver available after installing the Oracle ODAC.

The Oracle.ManagedDataAccess nuget package is a fully-managed. Confusingly, at one point this was labeled a managed driver (because it is, just has some significant non-managed local dependencies). Net driver, so requires an existing Instant Client install (ie uses OCI). The Oracle.DataAccess nuget package is a version of the ODAC.

Oracle Odac Drivers Are Another

DevArt's dotConnect drivers are another (very good) option here.There's also a nuget package for the Oracle instant client, but I have no idea what that is for. I'm told the EF support is much better than it used to be also. If you are just reading and writing with SELECT/INSERT, or vanilla ADO.Net you will be fine. Net drivers, possibly also ODT.For the nugets, it's worth pointing out that even now (Jan 2017) the Oracle.ManagedDataAccess driver still can't do a bunch of stuff, so Oracle.DataAccess + InstantClient is not a totally obsolete option. Net people, 'Oracle Client' means OUI-installed ODAC Instant Client +.

Oracle Odac Download Page If

SQL*Plus would presumably be little used at runtime, though there is a separate installer listed on the Instant Client download page if you want to to add it to an existing ODAC install.