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.
There are four core objects that make up a OraDirect .NET data
provider. Following is the description of those objects and their
function.
OraConnection - Establishes a connection to Oracle database and
can begin a transaction.
OraCommand - Executes a SQL or PL/SQL statements and stored
procedures at Oracle database, and exposes parameters.
OraDataReader - Exposes and reads a forward-only stream of data
from Oracle database.
OraDataAdapter - Populates a DataSet and resolves updates with
( Average rating:
4
)
: