OraDirect .NET Data Provider (ID #20092)

Core Lab

OraDirect .NET is data provider to direct access to Oracle database server for the Microsoft .NET Framework. It completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data. OraDirect .NET data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider.
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.

With core objects that make up a OraDirect .NET data provider such as:
- OraConnection to establish a connection to Oracle database and begin a transaction;
- OraCommand to execute a SQL or PL/SQL statements and stored procedures, and expose parameters;
- OraDataReader to expose and read a forward-only stream of data from Oracle database;
- OraDataAdapter to populate a DataSet and resolve updates with Oracle database.

OraDirect .NET provides additional functionality with OraCommandBuilder for automatic generation of update, insert and delete SQL statements, OraException, OraParameter to define input, output, and return value parameters for commands and stored procedures, OraTransaction, OraScript that allows to execute SQL scripts and OraLoader for fast loading data into the database.
It enables you to monitor SQL execution with help of special utility DBMonitor.
Provides advanced design-time abilities. OraDirect .NET has editors for OraCommand, OraDataAdapter, OraParameter, design-time generation of commands for update, insert and delete, dataset generation wizard, preview data dialog.
For visual building of the queries it supports Query Builder integrated at design-time and also allows to navigate through database schema.

OraDirect .NET Data Provider home page