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 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.