Migrating devart.Oracle to ODP.NET

Hi!

I'm evaluating the migration process from 8.1.3 to 8.2 . Our scripts use Devart.Oracle to execute stored procedures in one of our target system databases, as shown:

#If Not SCRIPTDEBUGGER Then
References Devart.Data.Oracle.dll
Imports Devart.Data.Oracle

(...)

As per the 8.2 SDK ,  we should use System.Data.Oracleclient. Now , upon compilation, the system complains that some types (such as OracleConnection) are being deprecated. The link provided in the warning message points to a Microsoft article that recommends moving even further on to ODP.NET.

How can I reference and import ODP?  I've tried :

#If Not SCRIPTDEBUGGER Then
References Oracle.ManagedDataAccess.dll (this .dll is in the One Identity folder)

Imports Oracle.DataAccess.Types
Imports Oracle.DataAccess.Client

, unsuccessfuly. Types such as OracleConnection are no longer found. 

Any ideas or examples I could use?
Thanks!

 

Parents Reply Children
No Data