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.

OracleDataSourceEnumerator*

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.

* This class is not available in the dotConnect for Oracle .Net Standard 1.3 compatible assemblies. It is supported only for full .NET Framework and .NET Standard 2.0.

** This class is supported only for full .NET Framework. It is not available in the dotConnect for Oracle .Net Standard compatible assemblies.