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

Core ADO.NET Classes

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

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

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

Class	Description
PgSqlScript	Serves to execute series of SQL statements.
PgSqlLoader	Serves to load external data into the PostgreSQL database.
PgSqlAlerter	Manages PostgreSQL notifications with LISTEN and NOTIFY commands.
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 not available in the dotConnect for PostgreSQL .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 PostgreSQL .NET Standard compatible assemblies.