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


The following tables list the members exposed by PgSqlConnectionStringBuilder.

Public Constructors

 NameDescription
public ConstructorPgSqlConnectionStringBuilder ConstructorOverloaded. Initializes a new instance of the PgSqlConnectionStringBuilder class.  
Top

Public Properties

 NameDescription
public PropertyAllowDateTimeOffsetDetermines whether to use the System.DateTimeOffset type instead of System.DateTime when PgSqlDataReader returns a timestamptz value.  
public PropertyApplicationNameGets or sets the client application name.  
public PropertyCharsetGets or sets charset that will be used on the client side.  
public PropertyConnectionLifetimeGets or sets time span in seconds for connection to live.  
public PropertyConnectionStringGets or sets the connection string associated with the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
public PropertyConnectionTimeoutGets or sets the time to wait while trying to establish a connection before terminating the attempt and generating an error.  
public PropertyCountGets the current number of keys that are contained within the System.Data.Common.DbConnectionStringBuilder.ConnectionString property. (Inherited from System.Data.Common.DbConnectionStringBuilder)
public PropertyDatabaseGets or sets the name of the database to be used once a connection is open.  
public PropertyDefaultCommandTimeoutGets or sets the time in seconds to wait while trying to execute a command before terminating the attempt and generating an error.  
public PropertyDefaultFetchAllDetermines 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 PropertyEnlistGets or sets a Boolean value that indicates whether the connection is automatically enlisted in the current transaction context.  
public PropertyForceIPv4Determines whether authentication by IPv6 address is allowed, or IPv4 address is always used.  
public PropertyHostGets or sets name or IP address of host of PostgreSQL database to which to connect.  
public PropertyIgnoreUnnamedParametersDetermines whether to treat the '?' character in CommandText as an unnamed parameter.  
public PropertyInitializationCommandSpecifies a data source-specific command that should be executed immediately after establishing the connection. (Inherited from Devart.Common.DbConnectionStringBuilder)
public PropertyIntegratedSecurityDetermines whether to use a secure authentication with single sign-on (GSSAPI or SSPI, depending on the server).  
public PropertyIsFixedSizeOverridden. Returns true.  
public PropertyIsReadOnlyGets a value that indicates whether the System.Data.Common.DbConnectionStringBuilder is read-only. (Inherited from System.Data.Common.DbConnectionStringBuilder)
public PropertyItemOverridden. Returns the value of given key.  
public PropertyJoinStatementNoticesDetermines 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 PropertyKeepAliveSpecifies 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 PropertyKeysOverridden. Collection of keys in the PgSqlConnectionStringBuilder.  
public PropertyMaxPoolSizeThe maximum number of connections allowed in the pool.  
public PropertyMinPoolSizeThe minimum number of connections allowed in the pool.  
public PropertyPasswordGets or sets the user's password to connect.  
public PropertyPersistSecurityInfoGets or sets a value indicating whether password is stored in connection string after connection is opened.  
public PropertyPoolingGets or sets pooling mode.  
public PropertyPortGets or sets port of PostgreSQL database to which to connect.  
public PropertyProtocolGets or sets version of protocol to be used.  
public PropertyProxyHostGets or sets the host name or IP address of the proxy server to which to connect.  
public PropertyProxyPasswordGets or sets the password for the proxy server account.  
public PropertyProxyPortGets or sets the port number of the proxy server.  
public PropertyProxyUserGets or sets the proxy server account name.  
public PropertyRunOnceCommandSpecifies a data source-specific command that should be executed immediately after first establishing the connection. Unlike Devart.Common.DbConnectionStringBuilder.InitializationCommand, this command is not executed when a connection is taken from the pool. (Inherited from Devart.Common.DbConnectionStringBuilder)
public PropertySchemaGets or sets PostgreSQL schema to use.  
public PropertySshAuthenticationTypeGets or sets the client authentication method.  
public PropertySshCipherListList of ciphers that client agrees to use.  
public PropertySshHostGets or sets name or ip address of SSH server.  
public PropertySshHostKeyGets or sets the location of the public key on the client side to verify the server host key during establishing connection.  
public PropertySshPassphraseGets or sets the client key passphrase.  
public PropertySshPasswordGets or sets user password on SSH server.  
public PropertySshPortGets ot sets number of port on SSH server to connect.  
public PropertySshPrivateKeyGets or sets the location of the client private key.  
public PropertySshStrictHostKeyCheckingIndicates whether the host key is verified during establishing connection.  
public PropertySshUserGets or sets user id on SSH server.  
public PropertySslCACertGets or sets location of authority certificate.  
public PropertySslCertGets or sets the location of the client SSL certificate.  
public PropertySslCipherListGets or sets list of ciphers that client agrees to use.  
public PropertySslKeyGets or sets location of user's private key.  
public PropertySslModeGets or sets SSL connection priority.  
public PropertySslTlsProtocolDetermines the preferred TLS protocol version reported to a server when establishing a secure connection.  
public PropertyTransactionErrorBehaviorDetermines whether to roll back a transaction automatically when an error occurs inside the transaction.  
public PropertyTransactionScopeLocalEnables support for non-distributed transactions in the TransactionScope implementation.  
public PropertyUnicodeGets or sets a value indicating whether the UTF8 charset will be used.  
public PropertyUnpreparedExecuteSets the default value of the PgSqlCommand.UnpreparedExecute property of PgSqlCommand instances.  
public PropertyUserIdGets or sets the name of the user to connect.  
public PropertyValidateConnectionIndicates whether to validate connections that are being taken from the pool.  
public PropertyValuesOverridden. Collection of values in the PgSqlConnectionStringBuilder.  
Top

Public Methods

 NameDescription
public MethodAddAdds an entry with the specified key and value into the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
public MethodClearOverridden. Sets all PgSqlConnectionStringBuilder properties to default values.  
public MethodContainsKeyOverridden. Indicates whether specified key is set in the PgSqlConnectionStringBuilder object.  
public MethodEquivalentToOverloaded. Overridden. Returns a value indicating whether this PgSqlConnectionStringBuilder has same parameters as given DbConnectionStringBuilder.  
public MethodRemoveOverridden. Sets value of the specified key to default.  
public MethodShouldSerializeOverridden. Determines whether the key will be serialized if required.  
public MethodTryGetValueOverridden. Attempts to get a key value.  
Top

See Also