dotConnect for Oracle Documentation
In This Topic
    Components
    In This Topic

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

    Core ADO.NET Classes

    Class Description
    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

    Class Description
    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

    Class Description
    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

    Class Description
    OracleScript Serves to execute series of SQL statements.
    OracleLoader Serves to load external data into the Oracle database.
    OracleAlerter Transfers messages between connections or client applications.
    OraclePackage Provides access to packages stored in the Oracle database.
    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/2.1.

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