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

In This Topic
    PgSqlConnectionStringBuilder Class Members
    In This Topic

    The following tables list the members exposed by PgSqlConnectionStringBuilder.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded. Initializes a new instance of the PgSqlConnectionStringBuilder class.  
    Top
    Public Properties
     NameDescription
    Public PropertyDetermines whether to use the System.DateTimeOffset type instead of System.DateTime when PgSqlDataReader returns a timestamptz value.  
    Public PropertyGets or sets the client application name.  
    Public PropertyGets or sets charset that will be used on the client side.  
    Public PropertyGets or sets time span in seconds for connection to live.  
    Public PropertyGets or sets the connection string associated with the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyGets or sets the time to wait while trying to establish a connection before terminating the attempt and generating an error.  
    Public PropertyGets the current number of keys that are contained within the System.Data.Common.DbConnectionStringBuilder.ConnectionString property. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyGets or sets the name of the database to be used once a connection is open.  
    Public PropertyGets or sets the time in seconds to wait while trying to execute a command before terminating the attempt and generating an error.  
    Public PropertyDetermines the default value of the FetchAll property of PgSqlCommand instances, created via the PgSqlConnection.CreateCommand method. If the FetchAll mode is enabled, PgSqlDataReader object retrieves all the querried data from the server on execution.  
    Public PropertyGets or sets a Boolean value that indicates whether the connection is automatically enlisted in the current transaction context.  
    Public PropertyDetermines whether authentication by IPv6 address is allowed, or IPv4 address is always used.  
    Public PropertyGets or sets name or IP address of host of PostgreSQL database to which to connect.  
    Public PropertyDetermines whether to treat the '?' character in CommandText as an unnamed parameter.  
    Public PropertySpecifies a data source-specific command that should be executed immediately after establishing the connection. (Inherited from Devart.Common.DbConnectionStringBuilder)
    Public PropertyDetermines whether to use a secure authentication with single sign-on (GSSAPI or SSPI, depending on the server).  
    Public PropertyOverridden. Returns true.  
    Public PropertyGets a value that indicates whether the System.Data.Common.DbConnectionStringBuilder is read-only. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyOverridden. Returns the value of given key.  
    Public PropertyDetermines whether all the notices, raised during the statement execution, will be returned together in one PgSqlConnection.InfoMessage event after the statement execution, or each notice will be returned in a separate PgSqlConnection.InfoMessage event.  
    Public PropertySpecifies whether to send TCP keep-alive packets and the interval at which they are sent in seconds. Default value is 0, which means that the packets are not sent.  
    Public PropertySpecifies whether to perform periodic ping calls to PostgreSQL when a connection is inactive (in order to avoid PostgreSQL closing connection because of inactivity and to always know if the connection is still valid) and the interval at which the calls are made in seconds. Default value is 0, which means that the calls are not made.  
    Public PropertyOverridden. Collection of keys in the PgSqlConnectionStringBuilder.  
    Public PropertyThe maximum number of connections allowed in the pool.  
    Public PropertyThe minimum number of connections allowed in the pool.  
    Public PropertyGets or sets the user's password to connect.  
    Public PropertyGets or sets a value indicating whether password is stored in connection string after connection is opened.  
    Public PropertyGets or sets pooling mode.  
    Public PropertyGets or sets port of PostgreSQL database to which to connect.  
    Public PropertyGets or sets version of protocol to be used.  
    Public PropertyGets or sets the host name or IP address of the proxy server to which to connect.  
    Public PropertyGets or sets the password for the proxy server account.  
    Public PropertyGets or sets the port number of the proxy server.  
    Public PropertyGets or sets the proxy server account name.  
    Public PropertySpecifies a data source-specific command that should be executed immediately after first establishing the connection. Unlike InitializationCommand, this command is not executed when a connection is taken from the pool. (Inherited from Devart.Common.DbConnectionStringBuilder)
    Public PropertyGets or sets PostgreSQL schema to use.  
    Public PropertyGets or sets the client authentication method.  
    Public PropertyList of ciphers that client agrees to use.  
    Public PropertyGets or sets name or ip address of SSH server.  
    Public PropertyGets or sets the location of the public key on the client side to verify the server host key during establishing connection.  
    Public PropertyGets or sets the client key passphrase.  
    Public PropertyGets or sets user password on SSH server.  
    Public PropertyGets ot sets number of port on SSH server to connect.  
    Public PropertyGets or sets the location of the client private key.  
    Public PropertyIndicates whether the host key is verified during establishing connection.  
    Public PropertyGets or sets user id on SSH server.  
    Public PropertyGets or sets location of authority certificate.  
    Public PropertyGets or sets the location of the client SSL certificate.  
    Public PropertyGets or sets list of ciphers that client agrees to use.  
    Public PropertyGets or sets location of user's private key.  
    Public PropertyGets or sets SSL connection priority.  
    Public PropertyDetermines the preferred TLS protocol version reported to a server when establishing a secure connection.  
    Public PropertyDetermines 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.  
    Public PropertyDetermines whether to roll back a transaction automatically when an error occurs inside the transaction.  
    Public PropertyEnables support for non-distributed transactions in the TransactionScope implementation.  
    Public PropertyGets or sets a value indicating whether the UTF8 charset will be used.  
    Public PropertySets the default value of the PgSqlCommand.UnpreparedExecute property of PgSqlCommand instances.  
    Public PropertyGets or sets the name of the user to connect.  
    Public PropertyIndicates whether to validate connections that are being taken from the pool.  
    Public PropertyOverridden. Collection of values in the PgSqlConnectionStringBuilder.  
    Top
    Public Methods
     NameDescription
    Public MethodAdds an entry with the specified key and value into the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public MethodOverridden. Sets all PgSqlConnectionStringBuilder properties to default values.  
    Public MethodOverridden. Indicates whether specified key is set in the PgSqlConnectionStringBuilder object.  
    Public MethodOverloaded. Overridden. Returns a value indicating whether this PgSqlConnectionStringBuilder has same parameters as given DbConnectionStringBuilder.  
    Public MethodOverridden. Sets value of the specified key to default.  
    Public MethodOverridden. Determines whether the key will be serialized if required.  
    Public MethodReturns the connection string associated with this System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public MethodOverridden. Attempts to get a key value.  
    Top
    See Also