dotConnect for PostgreSQL Documentation
PgSqlConnection Class Members
See Also  Properties  Methods  Events support@devart.com
Devart.Data.PostgreSql Namespace : PgSqlConnection Class


The following tables list the members exposed by PgSqlConnection.

Public Constructors

 NameDescription
public ConstructorPgSqlConnection ConstructorOverloaded. Initializes a new instance of the PgSqlConnection class.Initializes a new instance of the PgSqlConnection class.  
Top

Public Properties

 NameDescription
public PropertyAutoCommitObsolete. Determines whether modifications will be committed automatically at the server or not.  
public PropertyCharsetGets or sets charset that will be used on the client side.  
public PropertyCommitTimeoutGets the time to wait for the PgSqlTransaction.Commit method to execute before terminating the attempt and generating an error.  
public PropertyConnectionStringOverridden. Gets or sets the string used to open a PostgreSQL connection.  
public PropertyConnectionTimeoutGets the time to wait while trying to establish a connection before terminating the attempt and generating an error.  
public PropertyContainerGets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
public PropertyDatabaseGets or sets the name of the database to be used once a connection is open.  
public PropertyDataSourceOverridden. Returns the value of the Host property.  
public PropertyHostGets or sets name or IP address of host of PostgreSQL database to which to connect.  
public PropertyInDistributedTransactionIndicates whether the connection is enlisted in a distributed transaction. (Inherited from Devart.Common.DbConnectionBase)
public PropertyLocalFailoverDetermines whether the ConnectionLost event, which allows implicit reconnecting and reexectuting the corresponding operation, occurs after connection is lost.  
public PropertyNameGets or sets the name of the component.  
public PropertyOwnerGets or sets a form or other container that the PgSqlConnection instance belongs to.  
public PropertyPasswordGets or sets the user's password to connect.  
public PropertyPortGets or sets port of PostgreSQL database to which to connect.  
public PropertyProtocolVersionGets the version of protocol to be used.  
public PropertyProxyOptionsGets or sets proxy server settings.  
public PropertySchemaGets or sets the name of the schema to be used once a connection is open.  
public PropertyServerVersionGets a string containing the version of the instance of PostgreSQL to which the client is connected.  
public PropertySiteGets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
public PropertySshOptionsGets or sets SshOptions object which is used to establish secure connection with server.  
public PropertySslOptionsGets or sets T:Devart.Data.PgSql.SslOptions object which is used to establish secure connection with server.  
public PropertyStateGets the current state of the connection.  
public PropertyUnicodeGets or sets a value indicating whether the UTF8 charset will be used.  
public PropertyUserIdGets or sets the name of the user to connect.  
Top

Public Methods

 NameDescription
public MethodBeginOpenStarts an asynchronous invocation of an Open method. (Inherited from Devart.Common.DbConnectionBase)
public MethodBeginTransactionOverloaded. Begins a transaction at the database.  
public MethodChangeDatabaseOverridden. Changes the current database associated with an open PgSqlConnection.  
public Methodstatic (Shared in Visual Basic)ClearAllPoolsOverloaded. Clears all pools associated with the connection.  
public Methodstatic (Shared in Visual Basic)ClearPoolClears the pool matching ConnectionString of provided PgSqlConnection object.  
public MethodCloneCreates a new object that is a copy of the current instance.  
public MethodCloseOverridden. Closes the connection to the data source. This is the preferred method of closing any open connection.  
public MethodCommitCommits the database transaction.  
public MethodCreateCommandCreates and returns a PgSqlCommand object associated with the PgSqlConnection.  
public MethodCreateObjRefCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
public MethodDisposeReleases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
public MethodEndOpenEnds an asynchronous invocation of the Open method. (Inherited from Devart.Common.DbConnectionBase)
public MethodEnlistTransactionEnlists in the specified transaction. (Inherited from System.Data.Common.DbConnection)
public MethodGetLifetimeServiceRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
public MethodGetSchemaOverloaded. Returns schema information for the data source of this System.Data.Common.DbConnection. (Inherited from System.Data.Common.DbConnection)
public MethodInitializeLifetimeServiceObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
public MethodOpenOverridden. Opens a PostgreSQL connection with the property settings specified by the ConnectionString.  
public MethodPingDetermines whether connection to PostgreSQL server is valid.  
public MethodRollbackRolls back a transaction from a pending state.  
Top

Public Events

 NameDescription
public EventAuthenticationPromptThe event occurs when performing keyboard-interactive authentication.  
public EventConnectionLostOccurs 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.  
public EventDisposedOccurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component)
public EventErrorOccurs when PostgreSQL server sends an error message.  
public EventInfoMessageOccurs when PostgreSQL returns a warning or informational message.  
public EventNotificationOccurs when PostgreSQL server provides a notification message.  
public EventSshHostKeyConfirmationThe event occurs when host key verification during establishing connection failed.  
public EventStateChangeOccurs when the state of the connection changes. (Inherited from Devart.Common.DbConnectionBase)
public EventTransactionStateChangedOccurs when the state of the transaction is changed. (Inherited from Devart.Common.DbConnectionBase)
public EventTransactionStateChangingOccurs when the state of the transaction is changing. (Inherited from Devart.Common.DbConnectionBase)
Top

See Also