dotConnect for PostgreSQL Components

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

Class

Description

Core ADO.NET Classes
PgSqlConnection

Establishes a connection to PostgreSQL database and manages transactions.

PgSqlCommand

Executes SQL statements and stored procedures at PostgreSQL database.

PgSqlDataReader

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

PgSqlDataAdapter*

Populates a DataSet and resolves updates with PostgreSQL database.

PgSqlTransaction

Starts, commits, or rolls back server transactions.

PgSqlParameter

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

PgSqlException

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

Complementary ADO.NET Classes
PgSqlCommandBuilder*

A helper object that automatically generates command properties of PgSqlDataAdapter and populates the PgSqlParameter collection of PgSqlCommand object.

PgSqlConnectionStringBuilder

Constructs a connection string by assigning values to appropriate properties.

PgSqlDataSourceEnumerator*

Retrieves list of available servers in the network.

PgSqlDataSource*

Enables flexible data binding for ASP.NET applications.

dotConnect for PostgreSQL Advanced Classes
PgSqlDataTable*

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

PgSqlDataSet*

Represents typed and untyped PostgreSQL-specific datasets. Bases on PgSqlDataTable objects to build the schema.

DataLink*

Serves to establish flexible cross-form data binding.

dotConnect for PostgreSQL Auxiliary Classes
PgSqlScript

Serves to execute series of SQL statements.

PgSqlLoader

Serves to load external data into the PostgreSQL database.

PgSqlDump*

Serves to store a database or its parts as a script and also to restore database from the received script.

PgSqlMonitor

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

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