dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlConnection Class
Properties Methods Events

PgSqlConnection Class Members

The following tables list the members exposed by PgSqlConnection.

Public Constructors
 NameDescription
Public ConstructorOverloaded. Initializes a new instance of the PgSqlConnection class.  
Top
Public Properties
 NameDescription
Public PropertyObsolete. Determines whether modifications will be committed automatically at the server or not.  
Public PropertyGets or sets charset that will be used on the client side.  
Public PropertyGets the time to wait for the PgSqlTransaction.Commit method to execute before terminating the attempt and generating an error.  
Public PropertyOverridden. Gets or sets the string used to open a PostgreSQL connection.  
Public PropertyGets the time to wait while trying to establish a connection before terminating the attempt and generating an error.  
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyGets or sets the name of the database to be used once a connection is open.  
Public PropertyOverridden. Returns the value of the Host property.  
Public PropertyGets or sets name or IP address of host of PostgreSQL database to which to connect.  
Public PropertyIndicates whether the connection is enlisted in a distributed transaction. (Inherited from Devart.Common.DbConnectionBase)
Public PropertyDetermines whether the ConnectionLost event, which allows implicit reconnecting and reexectuting the corresponding operation, occurs after connection is lost.  
Public PropertyGets or sets the name of the component.  
Public PropertyGets or sets a form or other container that the PgSqlConnection instance belongs to.  
Public PropertyGets or sets the user's password to connect.  
Public PropertyGets or sets port of PostgreSQL database to which to connect.  
Public PropertyGets the version of protocol to be used.  
Public PropertyGets or sets proxy server settings.  
Public PropertyGets or sets the name of the schema to be used once a connection is open.  
Public PropertyGets a string containing the version of the instance of PostgreSQL to which the client is connected.  
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyGets or sets SshOptions object which is used to establish secure connection with server.  
Public PropertyGets or sets Devart.Data.PgSql.SslOptions object which is used to establish secure connection with server.  
Public PropertyGets the current state of the connection.  
Public PropertyGets or sets a value indicating whether the UTF8 charset will be used.  
Public PropertyGets or sets the name of the user to connect.  
Top
Public Methods
 NameDescription
Public MethodStarts an asynchronous invocation of an Open method. (Inherited from Devart.Common.DbConnectionBase)
Public MethodOverloaded. Begins a transaction at the database.  
Public MethodOverridden. Changes the current database associated with an open PgSqlConnection.  
Public Methodstatic (Shared in Visual Basic)Overloaded. Clears all pools associated with the connection.  
Public Methodstatic (Shared in Visual Basic)Clears the pool matching ConnectionString of provided PgSqlConnection object.  
Public MethodCreates a new object that is a copy of the current instance.  
Public MethodOverridden. Closes the connection to the data source. This is the preferred method of closing any open connection.  
Public MethodCommits the database transaction.  
Public MethodCreates and returns a PgSqlCommand object associated with the PgSqlConnection.  
Public Method (Inherited from System.MarshalByRefObject)
Public Method (Inherited from System.ComponentModel.Component)
Public MethodEnds an asynchronous invocation of the Open method. (Inherited from Devart.Common.DbConnectionBase)
Public MethodEnlists in the specified transaction. (Inherited from Devart.Common.DbConnectionBase)
Public Method (Inherited from System.MarshalByRefObject)
Public MethodOverloaded. Returns list of metadata collections and number of restrictions for a collection. (Inherited from Devart.Common.DbConnectionBase)
Public Method (Inherited from System.MarshalByRefObject)
Public MethodOverridden. Opens a PostgreSQL connection with the property settings specified by the ConnectionString.  
Public MethodDetermines whether connection to PostgreSQL server is valid.  
Public MethodRolls back a transaction from a pending state.  
Public Method (Inherited from System.ComponentModel.Component)
Top
Public Events
 NameDescription
Public EventThe event occurs when performing keyboard-interactive authentication.  
Public EventOccurs 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 Event (Inherited from System.ComponentModel.Component)
Public EventOccurs when PostgreSQL server sends an error message.  
Public EventOccurs when PostgreSQL returns a warning or informational message.  
Public EventOccurs when PostgreSQL server provides a notification message.  
Public EventThe event occurs when host key verification during establishing connection failed.  
Public EventOccurs when the state of the connection changes. (Inherited from Devart.Common.DbConnectionBase)
Public EventOccurs when the state of the transaction is changed. (Inherited from Devart.Common.DbConnectionBase)
Public EventOccurs when the state of the transaction is changing. (Inherited from Devart.Common.DbConnectionBase)
Top
See Also