Replacing System.Data.OracleClient to Oracle.DataAccess (ODP.NET)

c# .net oracle oracle11g odp.net
ria picture ria · Sep 21, 2011 · Viewed 30.7k times · Source

I have a project which is using System.Data.OracleClient at the moment and since it is being deprecated so I want to switch to the ODP.NET latest version for Oracle 11g. Please let me know if the following steps would work for me or there are certain other actions required to get it working without any errors:

  • Remove the reference to the SYstem.Data.OracleClient
  • Adding the reference to Oracle.DataAccess dll
  • Replacing OracleType enum with OracleDbType and updating the references to datatypes from VarChar to Varchar2 etc.

Answer

O. Jones picture O. Jones · Sep 21, 2011

You've pretty much got it.

Here's the Oracle writeup I followed when doing this: http://www.oracle.com/technetwork/topics/dotnet/code-154692.html

Two other things to do:

  1. Fix your connection string.

  2. Tell your OracleCommand instances you want to bind your parameters by name rather than position, using OracleCommand.BindByName = true

Suggestion: When you fix your connection string, get rid of any dependence on TNSNAMES.ORA by putting the whole connection string right in your program.

Related questions

Connecting to Oracle using Oracle.ManagedDataAccess

I am using Oracle.ManagedDataAccess Nuget Package Version 12.1.022 in my C# (.NET 4.0) project. The package automatically creates entries in the app.config file. How can I read the datasource string from this file to be able to connect to the …

Read More
How can I deploy a .NET application that uses ODAC without installing the whole component to the user?

I have written a C# application that connects to an Oracle 10g database. Using Oracle Data Access Component 11.2 "ODAC", it works perfectly on my machine. And now I want to deploy the application and install it in another "clean machine" …

Read More
Oracle.DataAccess.Client Dependencies

First of all, I want to use the Oracle.DataAccess.dll to use OracleBulkCopy. I want to know all the dlls that I need to be able to read from a database and then perform a bulkcopy in Oracle. Currently, …

Read More