dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlConnectionStringBuilder Class
Properties Methods

In This Topic
    MySqlConnectionStringBuilder Class Members
    In This Topic

    The following tables list the members exposed by MySqlConnectionStringBuilder.

    Public Constructors
     NameDescription
    Public ConstructorMySqlConnectionStringBuilder ConstructorOverloaded. Initializes a new instance of the MySqlConnectionStringBuilder class.  
    Top
    Public Properties
     NameDescription
    Public PropertyBackslashEscapesMode  
    Public PropertyBinaryAsGuidDetermines whether the provider should treat BINARY(16) columns as guid.  
    Public PropertyBinaryUuidOrderEnables processing UUID using binary MySQL UUID order of bytes when converting binary(16) to System.Guid.  
    Public PropertyCharAsGuidDetermines whether the provider should treat CHAR(36) columns as guid.  
    Public PropertyCharsetGets or sets charset that will be used on the client side.  
    Public PropertyClientInteractiveDetermines the inactivity timeout before the server breaks the connection.  
    Public PropertyCompressGets or sets a value indicating whether to enable transferred data compression.  
    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 PropertyDefaultAuthPluginGets or set the name of the authentication plugin to be used.  
    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 MySqlCommand.FetchAll property of MySqlCommand instances, created via the MySqlConnection.CreateCommand method. If the FetchAll mode is enabled, MySqlDataReader object retrieves all the querried data from the server on execution.  
    Public PropertyDirectGets or sets a value indicating whether the MySQL client library (libmysql.dll) will be used.  
    Public PropertyDisableCharsetSendingEnables or disables explicit charset resetting for the session taken from a pool.  
    Public PropertyEmbeddedSpecifies what server will be used to connect - MySQL server or Embedded MySQL server.  
    Public PropertyEnlistGets or sets a Boolean value that indicates whether the connection is automatically enlisted in the current transaction context.  
    Public PropertyFoundRowsSpecifies whether the provider will return the number of rows matched by the WHERE condition of the UPDATE statement instead of the rows actually changed as the number of changed rows.  
    Public PropertyHostGets or sets name or IP address of host of MySQL database to which to connect.  
    Public PropertyHttpBase64Specifies whether to encode data to MIME base64 format before sending them with the POST Request.  
    Public PropertyHttpContentLengthGets or sets the Content-Length HTTP header parameter. This is the size of message body in bytes for both client and server.  
    Public PropertyHttpHostGets or sets the host name or IP address of HTTP tunnel server.  
    Public PropertyHttpKeepAliveGets or sets the timeout in seconds to send Keep-Alive HTTP packets.  
    Public PropertyHttpMaxConnectionAgeGets or sets the maximum connection age in seconds after which the tunnel will be closed.  
    Public PropertyHttpPasswordGets or sets the password for HTTP authorization.  
    Public PropertyHttpPortGets or sets the port number of HTTP tunnel server.  
    Public PropertyHttpStrictContentLengthGets or sets a value indicating whether data padding is enabled when message size is smaller than Devart.Common.HttpOptions.ContentLength.  
    Public PropertyHttpUrlGets or sets url of the tunneling PHP script. For example, if the script is in the server root, the url can be the following: http://localhost/tunnel.php.  
    Public PropertyHttpUserGets or sets the user name for HTTP authorization.  
    Public PropertyIgnoreFractionalSecondsSpecifies whether the provider will ignore fractional parts of seconds in TIME, DATETIME, and TIMESTAMP values.  
    Public PropertyIgnorePrepareSpecifies whether the provider must ignore all MySqlCommand.Prepare calls.  
    Public PropertyInitializationCommandSpecifies a data source-specific command that should be executed immediately after establishing the connection. (Inherited from Devart.Common.DbConnectionStringBuilder)
    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 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 MySqlConnectionStringBuilder.  
    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 PropertyPingIntervalGets or sets the interval (in seconds) between pinging MySQL server and reopening the connection if required.  
    Public PropertyPipeNameGets or sets the name of the pipe to use when connecting via a named pipe.  
    Public PropertyPluginDirGets or sets the directory, where the plugin is located.  
    Public PropertyPoolingGets or sets pooling mode.  
    Public PropertyPortGets or sets port of MySQL server to which to connect.  
    Public PropertyProtocolGets or sets a MySqlProtocol of the MySqlConnectionStringBuilder.  
    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 InitializationCommand, this command is not executed when a connection is taken from the pool. (Inherited from Devart.Common.DbConnectionStringBuilder)
    Public PropertyServerParametersGets or sets parameters for launching MySQL embedded server.  
    Public PropertySqlModesGets or sets the value of MySQL sql_mode system variable to be set for the session.  
    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 location of client certificate.  
    Public PropertySslCipherListGets or sets list of ciphers that client agrees to use.  
    Public PropertySslKeyGets or sets location of user's private key.  
    Public PropertySslTlsProtocolDetermines the preferred TLS protocol version reported to a server when establishing a secure connection.  
    Public PropertyTinyAsBooleanThe provider should treat TINYINT(1) columns as boolean.  
    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 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 MySqlConnectionStringBuilder.  
    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 MySqlConnectionStringBuilder properties to default values.  
    Public MethodContainsKeyOverridden. Indicates whether specified key is set in the MySqlConnectionStringBuilder object.  
    Public MethodEquivalentToOverloaded. Overridden. Returns a value indicating whether this MySqlConnectionStringBuilder 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 MethodToStringReturns the connection string associated with this System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public MethodTryGetValueOverridden. Attempts to get a key value.  
    Top
    See Also

    Reference

    MySqlConnectionStringBuilder Class
    Devart.Data.MySql Namespace
    ConnectionString Property

     

     

    © 2002 - 2024 Devart. All Rights Reserved.

    Send Feedback