Name | Description | |
---|---|---|
PgSqlConnection Constructor | Overloaded. Initializes a new instance of the PgSqlConnection class. |
The following tables list the members exposed by PgSqlConnection.
Name | Description | |
---|---|---|
PgSqlConnection Constructor | Overloaded. Initializes a new instance of the PgSqlConnection class. |
Name | Description | |
---|---|---|
AutoCommit | Obsolete. Determines whether modifications will be committed automatically at the server or not. | |
Charset | Gets or sets charset that will be used on the client side. | |
CommitTimeout | Gets the time to wait for the PgSqlTransaction.Commit method to execute before terminating the attempt and generating an error. | |
ConnectionString | Overridden. Gets or sets the string used to open a PostgreSQL connection. | |
ConnectionTimeout | Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error. | |
Container | Gets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
Database | Gets or sets the name of the database to be used once a connection is open. | |
DataSource | Overridden. Returns the value of the Host property. | |
Host | Gets or sets name or IP address of host of PostgreSQL database to which to connect. | |
InDistributedTransaction | Indicates whether the connection is enlisted in a distributed transaction. (Inherited from Devart.Common.DbConnectionBase) | |
LocalFailover | Determines whether the ConnectionLost event, which allows implicit reconnecting and reexectuting the corresponding operation, occurs after connection is lost. | |
Name | Gets or sets the name of the component. | |
Owner | Gets or sets a form or other container that the PgSqlConnection instance belongs to. | |
Password | Gets or sets the user's password to connect. | |
Port | Gets or sets port of PostgreSQL database to which to connect. | |
ProtocolVersion | Gets the version of protocol to be used. | |
ProxyOptions | Gets or sets proxy server settings. | |
Schema | Gets or sets the name of the schema to be used once a connection is open. | |
ServerVersion | Gets a string containing the version of the instance of PostgreSQL to which the client is connected. | |
Site | Gets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
SshOptions | Gets or sets SshOptions object which is used to establish secure connection with server. | |
SslOptions | Gets or sets Devart.Data.PgSql.SslOptions object which is used to establish secure connection with server. | |
State | Gets the current state of the connection. | |
Unicode | Gets or sets a value indicating whether the UTF8 charset will be used. | |
UserId | Gets or sets the name of the user to connect. |
Name | Description | |
---|---|---|
BeginOpen | Starts an asynchronous invocation of an Open method. (Inherited from Devart.Common.DbConnectionBase) | |
BeginTransaction | Overloaded. Begins a transaction at the database. | |
ChangeDatabase | Overridden. Changes the current database associated with an open PgSqlConnection. | |
ClearAllPools | Overloaded. Clears all pools associated with the connection. | |
ClearPool | Clears the pool matching ConnectionString of provided PgSqlConnection object. | |
Clone | Creates a new object that is a copy of the current instance. | |
Close | Overridden. Closes the connection to the data source. This is the preferred method of closing any open connection. | |
Commit | Commits the database transaction. | |
CreateCommand | Creates and returns a PgSqlCommand object associated with the PgSqlConnection. | |
CreateObjRef | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject) | |
Dispose | Releases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component) | |
EndOpen | Ends an asynchronous invocation of the Open method. (Inherited from Devart.Common.DbConnectionBase) | |
EnlistTransaction | Enlists in the specified transaction. (Inherited from Devart.Common.DbConnectionBase) | |
GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) | |
GetSchema | Overloaded. Returns list of metadata collections and number of restrictions for a collection. (Inherited from Devart.Common.DbConnectionBase) | |
InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) | |
Open | Overridden. Opens a PostgreSQL connection with the property settings specified by the ConnectionString. | |
Ping | Determines whether connection to PostgreSQL server is valid. | |
Rollback | Rolls back a transaction from a pending state. | |
ToString | Returns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.Component) |
Name | Description | |
---|---|---|
AuthenticationPrompt | The event occurs when performing keyboard-interactive authentication. | |
ConnectionLost | Occurs when connection to the data source is lost in case LocalFailover is set to true. You may use this event to implicitly reconnect and reexecute the current operation. | |
Disposed | Occurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component) | |
Error | Occurs when PostgreSQL server sends an error message. | |
InfoMessage | Occurs when PostgreSQL returns a warning or informational message. | |
Notification | Occurs when PostgreSQL server provides a notification message. | |
SshHostKeyConfirmation | The event occurs when host key verification during establishing connection failed. | |
StateChange | Occurs when the state of the connection changes. (Inherited from Devart.Common.DbConnectionBase) | |
TransactionStateChanged | Occurs when the state of the transaction is changed. (Inherited from Devart.Common.DbConnectionBase) | |
TransactionStateChanging | Occurs when the state of the transaction is changing. (Inherited from Devart.Common.DbConnectionBase) |