dotConnect for Oracle Components

See a brief description of the classes and components included in dotConnect for Oracle. Click on the name of each component for more information.

Class

Description

Core ADO.NET Classes
OracleConnection

Establishes a connection to Oracle database and manages transactions.

OracleCommand

Executes SQL statements and stored procedures at Oracle database.

OracleDataReader

Exposes and reads a forward-only stream of data from Oracle database.

OracleDataAdapter

Populates a DataSet and resolves updates with Oracle database.

OracleTransaction

Starts, commits, or rolls back server transactions.

OracleParameter

Represents input, output, and return value parameters for commands.

OracleException

Represents an error encountered at Oracle database. For an error encountered at the client, dotConnect for Oracle throws a .NET Framework exception.

Complementary ADO.NET Classes
OracleCommandBuilder

A helper object that automatically generates command properties of OracleDataAdapter and populates the OracleParameter collection of OracleCommand object.

OracleConnectionStringBuilder

Constructs a connection string by assigning values to appropriate properties.

DbDataSourceEnumerator

Retrieves list of available servers in the network.

OracleDataSource

Enables flexible data binding for ASP.NET applications.

dotConnect for Oracle Advanced Classes
OracleDataTable

Provides all of the functionality needed to retrieve and manipulate data from an Oracle server data source. Combines connected and disconnected data access models.

OracleDataSet

Represents typed and untyped Oracle-specific datasets. Bases on OracleDataTable objects to build the schema.

DataLink

Serves to establish flexible cross-form data binding.

dotConnect for Oracle Toolkit Classes
OracleScript

Serves to execute series of SQL statements.

OracleLoader

Serves to load external data into the Oracle database.

OraclePackage

Provides access to packages stored in the Oracle database.

OracleAlerter

Transfers messages between connections or client applications.

OraclePipe

Transfers data between connections or client applications.

OracleTrace

Traces command execution on Oracle server.

OracleQueue

Represents named data queue in the Oracle database, manages queue items.

OracleQueueTable

Manages queue tables in the Oracle database.

OracleQueueAdmin

Creates, drops, starts, stops, and customizes the Oracle queues.

OracleMonitor

Serves to monitor dynamic SQL execution in applications that use dotConnect for Oracle.