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!