Oracle Managed Driver

1). Launch Visual Studio and install OMD

– Click Tools > NuGet Package Manager > Package Manager Console
– Type: Install-Package Oracle.ManagedDataAccess
– Locate the dll Oracle.ManagedDataAccess.dll and copy it into the Dlls directory of your VS project
For me, the dll could be found in \packages\Oracle.ManagedDataAccess.12.1.2400\lib\net40\

2). Create a new project in a manner similar to the ODP.Net way of doing things
– Reference the OMD dll
– Implement all the same methods as before
– Sign the project in the Properties panel (same as ODP.Net), in fact I selected the same snk file

3). in AIMS DBA, create an override for OMD
– Define the constants for database type and connection type

4). Format the connection string in database.config properly

// connect like this for a common user
c.ConnectionString = "User Id=C##USER1; Password=secret; Data Source=LOKI:1521/LOKI;";
c.ConnectionString = "User Id=C##USER1; Password=secret; Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL = TCP)(HOST = loki)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = LOKI));";

// connect like this for a PDB user
c.ConnectionString = "User Id=AIMSUSER; Password=secret; Data Source=LOKI:1521/orapdb;";

Leave a Reply