A Database API Control/Component by Core Lab

OraDirect .NET uses Oracle Call Interface (OCI) directly. OCI is low-level native application programming interface to access to Oracle database. Using OCI allows to create lightweight and fast applications working with Oracle.

OraDirect .NET provides functionality for connecting to Oracle database, executing commands, and retrieving results. Those results can be processed directly, or placed in an ADO.NET DataSet for further processing while in a disconnected state. While in the DataSet, data can be exposed to the user, combined with other data from multiple sources, or passed remotely between tiers. Any processing performed on the data while in the DataSet can then be reconciled to Oracle database.

OraDirect .NET data provider is designed to be lightweight. It consists of a minimal layer between Oracle database and your code. This extends functionality without sacrificing performance.

There are core classes that make up OraDirect .NET data provider. The following table describes those classes and their functions.

Following the main features of the OraDirect .NET Data Provider.

• 100% managed code


• High performance


• Supports Oracle 9i, 8i and 8.0


• All Oracle 9i data types support


• Support Oracle object types OBJECT, VARRAY, TABLE, REF


• Easy to deploy


• OracleScript component to execute scripts


• OracleLoader component for fast loading data


• OraclePackage component for easy working with PL/SQL packages


• Ability of monitoring query and stored procedures execution


• Array binding feature


• PL/SQL tables support


• OS authentication enabled


• DBA privileges to open a session with


• Fill DataSet with several REF CURSOR


• Fill DataSet with object, array and nested table data


• Advanced design-time editors


• Integrated OraTools to design, debug and try SQL and PL/SQL and browse schema objects


• Migration wizard from MS OracleClient and ODP.NET


• Help integrated into Visual Studio .NET


• Free support for registered users


• Licensed per a developer without royalty fee