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 | (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 | (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 | (Inherited from System.MarshalByRefObject) |
![]() | Dispose | (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 | (Inherited from System.MarshalByRefObject) |
![]() | GetSchema | Overloaded. Returns list of metadata collections and number of restrictions for a collection. (Inherited from Devart.Common.DbConnectionBase) |
![]() | InitializeLifetimeService | (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 | (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 | (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) |