Devart.Data.PostgreSql Namespace

In This Topic

Classes

	Class	Description
	MemCryptStorage	This 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.
	PgSqlAlerter	Manages PostgreSQL notifications with LISTEN and NOTIFY commands.
	PgSqlAlerterAlertEventArgs	Provides data for the PgSqlAlerter.Alert event.
	PgSqlAlerterErrorEventArgs	Provides data for the PgSqlAlerter.Error event.
	PgSqlAlerterStoppedEventArgs	Provides data for the PgSqlAlerter.Stopped event.
	PgSqlAttribute	Represents PostgreSQL column in a composite type.
	PgSqlAttributeCollection	Represents collection of PgSqlAttribute objects.
	PgSqlAuthenticationPromptEventArgs	Provides data for the PgSqlConnection.AuthenticationPrompt event.
	PgSqlBigIntRange	Represents the PostgreSQL int8range type. Each object of the PgSqlBigIntRange class stores a range of integer values.
	PgSqlBlob	Represents a variable-length stream of binary data to be stored in or retrieved from a database.
	PgSqlCommand	Represents a SQL statement or stored procedure to execute against PostgreSQL.
	PgSqlCommandBuilder	Automatically generates single-table commands used to reconcile changes made to a System.Data.DataSet with the PostgreSQL.
	PgSqlConnection	Represents an open connection to PostgreSQL.
	PgSqlConnectionStringBuilder	Generates automatically connection strings used to connect to PostgreSQL.
	PgSqlCursor	Represents a PostgreSQL REF CURSOR and value of cursor field.
	PgSqlDataAdapter	Represents a set of data commands and a data source connection that are used to fill the System.Data.DataSet and update a PostgreSQL data.
	PgSqlDataReader	Reads a forward-only stream of rows from PostgreSQL.
	PgSqlDataSet	Represents an in-memory cache of data with support for PostgreSQL-specific features.
	PgSqlDataSourceEnumerator	Retrieves list of available servers in the network.
	PgSqlDataTable	Represents a single object that provides all of the functionality needed to retrieve and manipulate data from a PostgreSQL data source.
	PgSqlDateRange	Represents the PostgreSQL daterange type. Each object of the PgSqlDateRange class stores a range of date values.
	PgSqlDependency	Tracks changes on the server.
	PgSqlDependencyErrorEventArgs	Provides data for the PgSqlDependency.Error event of the PgSqlDependency class.
	PgSqlDump	Serves to store a database or its parts as a script and also to restore database from the received script.
	PgSqlError	Represents a PostgreSQL notice, warning, and error messages.
	PgSqlErrorCollection	Represents a collection of PgSqlError objects.
	PgSqlErrorEventArgs	Provides data for the PgSqlConnection.Error event.
	PgSqlException	The exception that is generated when PostgreSQL returns a warning or error.
	PgSqlInfoMessageEventArgs	Provides data for the PgSqlConnection.InfoMessage event.
	PgSqlIntRange	Represents the PostgreSQL int4range type. Each object of the PgSqlIntRange class stores a range of integer values.
	PgSqlLargeObject	Represents a PostgreSQL large object.
	PgSqlLoader	Serves to load external data into PostgreSQL.
	PgSqlLoaderColumn	Represents the attributes for column loading.
	PgSqlLoaderColumnCollection	Represents a collection of columns relevant to a PgSqlLoader.
	PgSqlLoaderErrorEventArgs	Provides data for the PgSqlLoader.Error event of the PgSqlLoader class.
	PgSqlLocalization	This static class allows configuring localization settings.
	PgSqlMetaDataCollectionNames	Enumerates collection names you can use for metadata retrieval purposes.
	PgSqlMonitor	Monitors dynamic SQL execution in applications that use dotConnect for PostgreSQL.
	PgSqlNotificationEventArgs	Provides data for the PgSqlConnection.Notification event of the PgSqlConnection class.
	PgSqlNumericRange	Represents the PostgreSQL numrange type. Each object of the PgSqlNumericRange class stores a range of integer values.
	PgSqlParameter	Represents a parameter to a PgSqlCommand, and optionally, its mapping to System.Data.DataSet columns.
	PgSqlParameterCollection	Collects all parameters relevant to a PgSqlCommand as well as their respective mappings to System.Data.DataSet columns.
	PgSqlProviderFactory	Represents a factory required to create inheritors of generic base classes to use with dotConnect for PostgreSQL.
	PgSqlRangeType<T>	Generic base type for classes, representing PostgreSQL range types.
	PgSqlRow	Represents PostgreSQL composite type data.
	PgSqlRowType	Represents PostgreSQL row data type.
	PgSqlRowUpdatedEventArgs	Provides data for the PgSqlDataAdapter.RowUpdated event.
	PgSqlRowUpdatingEventArgs	Provides data for the PgSqlDataAdapter.RowUpdating event. This class cannot be inherited.
	PgSqlScript	Serves to execute series of SQL statements separated by special symbols.
	PgSqlSelectLimit	Represents PostgreSQL LIMIT clause.
	PgSqlSelectStatement	Represents PostgreSQL SELECT statement.
	PgSqlStatementExecuteEventArgs	Provides data for the PgSqlScript.PgSqlStatementExecute event of the PgSqlScript class.
	PgSqlTableChangeEventArgs	Provides data for the PgSqlDependency.OnChange event of the PgSqlDependency class.
	PgSqlText	Represents a variable-length stream of characters to be stored in or retrieved from the database.
	PgSqlTimeStampRange	Represents the PostgreSQL tsrange type. Each object of the PgSqlTimeStampRange class stores a range of integer values.
	PgSqlTimeStampTZRange	Represents the PostgreSQL tstzrange type. Each object of the PgSqlTimeStampTZRange class stores a range of integer values.
	PgSqlTransaction	Represents a SQL transaction to be made in the PostgreSQL database.
	RestoreProgressEventArgs	Provides data for the PgSqlDump.RestoreProgress event of the PgSqlDump class.
	SshOptions	Represents information required to establish a SSH connection.
	SslOptions	Represents information required to establish a SSL connection.

Structures

	Structure	Description
	PgSqlArray	Represents a PostgreSQL ARRAY value.
	PgSqlBox	Represents PostgreSQL box geometric data type.
	PgSqlCircle	Represents PostgreSQL circle geometric data type.
	PgSqlInet	Represents the PostgreSQL inet or cidr data type that stores an IPv4 or IPv6 address and optionally its subnet.
	PgSqlInterval	Represents 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.
	PgSqlLine	Represents PostgreSQL line geometric data type.
	PgSqlLSeg	Represents PostgreSQL lseg geometric data type.
	PgSqlMacAddr	Represents the PostgreSQL macaddr data type that stores MAC addresses.
	PgSqlPath	Represents PostgreSQL path geometric data type.
	PgSqlPoint	Represents PostgreSQL point geometric data type.
	PgSqlPolygon	Represents PostgreSQL polygon geometric data type.
	PgSqlTime	Represents the PostgreSQL date and timestamp data types.
	PgSqlTimeStamp	Represents the PostgreSQL date and timestamp data types.

Delegates

	Delegate	Description
	OnChangeEventHandler	Represents the method that will handle the PgSqlDependency.OnChange event of a PgSqlDependency.
	PgSqlAlerterAlertEventHandler	Represents the method that will handle the PgSqlAlerter.Alert event of PgSqlAlerter.
	PgSqlAlerterErrorEventHandler	Represents the method that will handle the PgSqlAlerter.Error event of PgSqlAlerter.
	PgSqlAlerterStoppedEventHandler	Represents the method that will handle the PgSqlAlerter.Stopped event of PgSqlAlerter.
	PgSqlAuthenticationPromptHandler	Represents the method that will handle the PgSqlConnection.AuthenticationPrompt event of PgSqlConnection.
	PgSqlDependencyErrorEventHandler	Represents the method that will handle the PgSqlDependency.Error event of PgSqlDependency.
	PgSqlErrorEventHandler	Represents the method that will handle the PgSqlConnection.Error event of a PgSqlConnection.
	PgSqlInfoMessageEventHandler	Represents the method that will handle the PgSqlConnection.InfoMessage event of PgSqlConnection.
	PgSqlLoaderErrorEventHandler	Represents the method that will handle the PgSqlLoader.Error event of a PgSqlLoader.
	PgSqlNotificationEventHandler	Represents the method that will handle the PgSqlConnection.Notification event of a PgSqlConnection.
	PgSqlRowUpdatedEventHandler	Represents the method that will handle the PgSqlDataAdapter.RowUpdated event of an PgSqlDataAdapter.
	PgSqlRowUpdatingEventHandler	Represents the method that will handle the PgSqlDataAdapter.RowUpdating event of an PgSqlDataAdapter.
	PgSqlStatementExecuteEventHandler	Represents the method that will handle the PgSqlScript.PgSqlStatementExecute event of an PgSqlScript.
	RestoreProgressEventHandler	Represents the method that will handle the PgSqlDump.RestoreProgress event of the PgSqlDump class.
	SshHostKeyConfirmationHandler	Represents the method that will handle the PgSqlConnection.SshHostKeyConfirmation event of PgSqlConnection.

Enumerations

	Enumeration	Description
	PgSqlDumpObjects	Determines which database objects will be included in the dump.
	PgSqlLargeObjectOpenMode	Specifies how to open an existing large object - for reading or for writing.
	PgSqlLoaderMode	Determines the operating mode of the PgSqlLoader.
	PgSqlType	Specifies the data type of a field, property, PgSqlParameter or PgSqlAttribute.
	ProtocolVersion	Specifies version of protocol to be used when more than one is available.
	Severity	Specifies a severity of occurred event.
	SshAuthenticationType	Specifies a type of the SSH protocol authentication.
	SslMode	Determines SSL connection priority.
	TargetSession	Determines 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.
	TransactionErrorBehavior	Determines how dotConnect for PostgreSQL handles errors, which occur within a transaction.

Reference

Devart.Data.PostgreSql Assembly

Send Feedback