dotConnect for PostgreSQL Documentation
Inheritance Hierarchy
In This Topic
    Devart.Data.PostgreSql Namespace
    In This Topic
    Classes
     ClassDescription
    ClassThis class represents an in-memory storage for keys and certificates for establishing a protected SSL or SSH connection. It allows you to upload certificates and keys into memory once when the application starts and don't load certificate and key from some external sources (for example, files) each time when a connection is opened.
    ClassManages PostgreSQL notifications with LISTEN and NOTIFY commands.
    ClassProvides data for the PgSqlAlerter.Alert event.
    ClassProvides data for the PgSqlAlerter.Error event.
    ClassProvides data for the PgSqlAlerter.Stopped event.
    ClassRepresents PostgreSQL column in a composite type.
    ClassRepresents collection of PgSqlAttribute objects.
    ClassProvides data for the PgSqlConnection.AuthenticationPrompt event.
    ClassRepresents the PostgreSQL int8range type. Each object of the PgSqlBigIntRange class stores a range of integer values.
    ClassRepresents a variable-length stream of binary data to be stored in or retrieved from a database.
    ClassRepresents a SQL statement or stored procedure to execute against PostgreSQL.
    ClassAutomatically generates single-table commands used to reconcile changes made to a System.Data.DataSet with the PostgreSQL.
    ClassRepresents an open connection to PostgreSQL.
    ClassGenerates automatically connection strings used to connect to PostgreSQL.
    ClassRepresents a PostgreSQL REF CURSOR and value of cursor field.
    ClassRepresents a set of data commands and a data source connection that are used to fill the System.Data.DataSet and update a PostgreSQL data.
    ClassReads a forward-only stream of rows from PostgreSQL.
    ClassRepresents an in-memory cache of data with support for PostgreSQL-specific features.
    ClassRetrieves list of available servers in the network.
    ClassRepresents a single object that provides all of the functionality needed to retrieve and manipulate data from a PostgreSQL data source.
    ClassRepresents the PostgreSQL daterange type. Each object of the PgSqlDateRange class stores a range of date values.
    ClassTracks changes on the server.
    ClassProvides data for the PgSqlDependency.Error event of the PgSqlDependency class.
    ClassServes to store a database or its parts as a script and also to restore database from the received script.
    ClassRepresents a PostgreSQL notice, warning, and error messages.
    ClassRepresents a collection of PgSqlError objects.
    ClassProvides data for the PgSqlConnection.Error event.
    ClassThe exception that is generated when PostgreSQL returns a warning or error.
    ClassProvides data for the PgSqlConnection.InfoMessage event.
    ClassRepresents the PostgreSQL int4range type. Each object of the PgSqlIntRange class stores a range of integer values.
    ClassRepresents a PostgreSQL large object.
    ClassServes to load external data into PostgreSQL.
    ClassRepresents the attributes for column loading.
    ClassRepresents a collection of columns relevant to a PgSqlLoader.
    ClassProvides data for the PgSqlLoader.Error event of the PgSqlLoader class.
    ClassThis static class allows configuring localization settings.
    ClassEnumerates collection names you can use for metadata retrieval purposes.
    ClassMonitors dynamic SQL execution in applications that use dotConnect for PostgreSQL.
    ClassProvides data for the PgSqlConnection.Notification event of the PgSqlConnection class.
    ClassRepresents the PostgreSQL numrange type. Each object of the PgSqlNumericRange class stores a range of integer values.
    ClassRepresents a parameter to a PgSqlCommand, and optionally, its mapping to System.Data.DataSet columns.
    ClassCollects all parameters relevant to a PgSqlCommand as well as their respective mappings to System.Data.DataSet columns.
    ClassRepresents a factory required to create inheritors of generic base classes to use with dotConnect for PostgreSQL.
    ClassGeneric base type for classes, representing PostgreSQL range types.
    ClassRepresents PostgreSQL composite type data.
    ClassRepresents PostgreSQL row data type.
    ClassProvides data for the PgSqlDataAdapter.RowUpdated event.
    ClassProvides data for the PgSqlDataAdapter.RowUpdating event. This class cannot be inherited.
    ClassServes to execute series of SQL statements separated by special symbols.
    ClassRepresents PostgreSQL LIMIT clause.
    ClassRepresents PostgreSQL SELECT statement.
    ClassProvides data for the PgSqlScript.PgSqlStatementExecute event of the PgSqlScript class.
    ClassProvides data for the PgSqlDependency.OnChange event of the PgSqlDependency class.
    ClassRepresents a variable-length stream of characters to be stored in or retrieved from the database.
    ClassRepresents the PostgreSQL tsrange type. Each object of the PgSqlTimeStampRange class stores a range of integer values.
    ClassRepresents the PostgreSQL tstzrange type. Each object of the PgSqlTimeStampTZRange class stores a range of integer values.
    ClassRepresents a SQL transaction to be made in the PostgreSQL database.
    ClassProvides data for the PgSqlDump.RestoreProgress event of the PgSqlDump class.
    ClassRepresents information required to establish a SSH connection.
    ClassRepresents information required to establish a SSL connection.
    Structures
     StructureDescription
    StructureRepresents a PostgreSQL ARRAY value.
    StructureRepresents PostgreSQL box geometric data type.
    StructureRepresents PostgreSQL circle geometric data type.
    StructureRepresents the PostgreSQL inet or cidr data type that stores an IPv4 or IPv6 address and optionally its subnet.
    StructureRepresents the PostgreSQL INTERVAL data type. Each object of the PgSqlInterval class stores a period of time in years, months, days, hours, minutes, seconds, and milliseconds.
    StructureRepresents PostgreSQL line geometric data type.
    StructureRepresents PostgreSQL lseg geometric data type.
    StructureRepresents the PostgreSQL macaddr data type that stores MAC addresses.
    StructureRepresents PostgreSQL path geometric data type.
    StructureRepresents PostgreSQL point geometric data type.
    StructureRepresents PostgreSQL polygon geometric data type.
    StructureRepresents the PostgreSQL date and timestamp data types.
    StructureRepresents the PostgreSQL date and timestamp data types.
    Delegates
     DelegateDescription
    DelegateRepresents the method that will handle the PgSqlDependency.OnChange event of a PgSqlDependency.
    DelegateRepresents the method that will handle the PgSqlAlerter.Alert event of PgSqlAlerter.
    DelegateRepresents the method that will handle the PgSqlAlerter.Error event of PgSqlAlerter.
    DelegateRepresents the method that will handle the PgSqlAlerter.Stopped event of PgSqlAlerter.
    DelegateRepresents the method that will handle the PgSqlConnection.AuthenticationPrompt event of PgSqlConnection.
    DelegateRepresents the method that will handle the PgSqlDependency.Error event of PgSqlDependency.
    DelegateRepresents the method that will handle the PgSqlConnection.Error event of a PgSqlConnection.
    DelegateRepresents the method that will handle the PgSqlConnection.InfoMessage event of PgSqlConnection.
    DelegateRepresents the method that will handle the PgSqlLoader.Error event of a PgSqlLoader.
    DelegateRepresents the method that will handle the PgSqlConnection.Notification event of a PgSqlConnection.
    DelegateRepresents the method that will handle the PgSqlDataAdapter.RowUpdated event of an PgSqlDataAdapter.
    DelegateRepresents the method that will handle the PgSqlDataAdapter.RowUpdating event of an PgSqlDataAdapter.
    DelegateRepresents the method that will handle the PgSqlScript.PgSqlStatementExecute event of an PgSqlScript.
    DelegateRepresents the method that will handle the PgSqlDump.RestoreProgress event of the PgSqlDump class.
    DelegateRepresents the method that will handle the PgSqlConnection.SshHostKeyConfirmation event of PgSqlConnection.
    Enumerations
     EnumerationDescription
    EnumerationDetermines which database objects will be included in the dump.
    EnumerationSpecifies how to open an existing large object - for reading or for writing.
    EnumerationDetermines the operating mode of the PgSqlLoader.
    EnumerationSpecifies the data type of a field, property, PgSqlParameter or PgSqlAttribute.
    EnumerationSpecifies version of protocol to be used when more than one is available.
    EnumerationSpecifies a severity of occurred event.
    EnumerationSpecifies a type of the SSH protocol authentication.
    EnumerationDetermines SSL connection priority.
    EnumerationDetermines how the host to connect to is selected from the list when multiple hosts are specified in the Host connection string parameter. See Load Balancing and Failover for more information.
    EnumerationDetermines how dotConnect for PostgreSQL handles errors, which occur within a transaction.
    See Also