MySQL Connector/Net
| MySqlConnectionStringBuilder Class |
Inheritance HierarchySystemObject System.Data.CommonDbConnectionStringBuilder
MySql.Data.MySqlClientMySqlConnectionStringBuilder
MySql.Data.MySqlClientMySqlConnectionStringBuilder
Namespace: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll) Version: 6.9.9
Syntaxpublic sealed class MySqlConnectionStringBuilder : DbConnectionStringBuilder
Public NotInheritable Class MySqlConnectionStringBuilder Inherits DbConnectionStringBuilder
public ref class MySqlConnectionStringBuilder sealed : public DbConnectionStringBuilder
[<SealedAttribute>] type MySqlConnectionStringBuilder = class inherit DbConnectionStringBuilder end
The MySqlConnectionStringBuilder type exposes the following members.
ConstructorsProperties| Name | Description | |
|---|---|---|
 | AllowBatch |
Gets or sets a boolean value that indicates whether this connection will allow
commands to send multiple SQL statements in one execution.
|
| AllowUserVariables | |
| AllowZeroDateTime |
Gets or sets a boolean value that indicates if zero date time values are supported.
|
| AutoEnlist | |
| BlobAsUTF8ExcludePattern |
Gets or sets the pattern that matches the columns that should not be treated as UTF8
|
| BlobAsUTF8IncludePattern |
Gets or sets the pattern that matches the columns that should be treated as UTF8
|
| BrowsableConnectionString | Gets or sets a value that indicates whether the ConnectionString property is visible in Visual Studio designers. (Inherited from DbConnectionStringBuilder.) |
| CacheServerProperties | |
| CertificateFile | |
| CertificatePassword | |
| CertificateStoreLocation | |
| CertificateThumbprint | |
| CharacterSet |
Gets or sets the character set that should be used for sending queries to the server.
|
| CheckParameters | |
| CommandInterceptors | |
| ConnectionLifeTime |
Gets or sets the lifetime of a pooled connection.
|
| ConnectionProtocol |
Gets or sets the protocol that should be used for communicating
with MySQL.
|
| ConnectionReset |
Gets or sets a boolean value indicating if the connection should be reset when retrieved
from the pool.
|
| ConnectionString | Gets or sets the connection string associated with the DbConnectionStringBuilder. (Inherited from DbConnectionStringBuilder.) |
| ConnectionTimeout |
Gets or sets the connection timeout.
|
| ConvertZeroDateTime |
Gets or sets a boolean value indicating if zero datetime values should be
converted to DateTime.MinValue.
|
| Count | Gets the current number of keys that are contained within the ConnectionString property. (Inherited from DbConnectionStringBuilder.) |
| Database |
Gets or sets the name of the database the connection should
initially connect to.
|
| DefaultCommandTimeout |
Gets or sets the default command timeout.
|
| DefaultTableCacheAge | |
| ExceptionInterceptors | |
| FabricGroup | |
| FabricScope | |
| FabricServerMode | |
| FunctionsReturnString | |
| IgnorePrepare |
Gets or sets a boolean value indicating if calls to Prepare() should be ignored.
|
| IncludeSecurityAsserts | |
| IntegratedSecurity | |
| InteractiveSession | |
| IsFixedSize | Gets a value that indicates whether the DbConnectionStringBuilder has a fixed size. (Inherited from DbConnectionStringBuilder.) |
| IsReadOnly | Gets a value that indicates whether the DbConnectionStringBuilder is read-only. (Inherited from DbConnectionStringBuilder.) |
| Item | (Overrides DbConnectionStringBuilderItemString.) |
| Keepalive | |
| Keys | Gets an ICollection that contains the keys in the DbConnectionStringBuilder. (Inherited from DbConnectionStringBuilder.) |
| Logging |
Gets or sets a boolean value that indicates whether logging is enabled.
|
| MaximumPoolSize |
Gets or sets the maximum connection pool setting.
|
| MinimumPoolSize |
Gets the minimum connection pool size.
|
| OldGuids | |
| Password |
Gets or sets the password that should be used to connect with.
|
| PersistSecurityInfo |
Gets or sets a boolean value that indicates if the password should be persisted
in the connection string.
|
| PipeName |
Gets or sets the name of the named pipe that should be used
for communicating with MySQL.
|
| Pooling |
Gets or sets a boolean value indicating if connection pooling is enabled.
|
| Port |
Gets or sets the port number that is used when the socket
protocol is being used.
|
| ProcedureCacheSize |
Gets or sets the size of the stored procedure cache.
|
| Replication | |
| RespectBinaryFlags | |
| Server |
Gets or sets the name of the server.
|
| ShardingKey | |
| ShardingTable | |
| SharedMemoryName |
Gets or sets the base name of the shared memory objects used to
communicate with MySQL when the shared memory protocol is being used.
|
| SqlServerMode | |
| SslMode |
Indicates whether to use SSL connections and how to handle server certificate errors.
|
| TableCaching | |
| TreatBlobsAsUTF8 |
Indicates whether the driver should treat binary blobs as UTF8
|
| TreatTinyAsBoolean | |
| UseAffectedRows | |
| UseCompression |
Gets or sets a boolean value that indicates whether this connection
should use compression.
|
| UseDefaultCommandTimeoutForEF | |
| UseOldSyntax | Obsolete.
Gets or sets a boolean value that indicates whether this connection uses
the old style (@) parameter markers or the new (?) style.
|
| UsePerformanceMonitor |
Gets or sets a boolean value indicating if the permon hooks should be enabled.
|
| UseProcedureBodies | Obsolete. |
| UserID |
Gets or sets the user id that should be used to connect with.
|
| UseUsageAdvisor |
Gets or sets a boolean value indicating if the Usage Advisor should be enabled.
|
| Values | Gets an ICollection that contains the values in the DbConnectionStringBuilder. (Inherited from DbConnectionStringBuilder.) |
Methods| Name | Description | |
|---|---|---|
 | Add | Adds an entry with the specified key and value into the DbConnectionStringBuilder. (Inherited from DbConnectionStringBuilder.) |
| Clear | (Overrides DbConnectionStringBuilderClear.) |
 | ClearPropertyDescriptors | Clears the collection of PropertyDescriptor objects on the associated DbConnectionStringBuilder. (Inherited from DbConnectionStringBuilder.) |
| ContainsKey | (Overrides DbConnectionStringBuilderContainsKey(String).) |
| Equals | (Overrides ObjectEquals(Object).) |
| EquivalentTo | Compares the connection information in this DbConnectionStringBuilder object with the connection information in the supplied object. (Inherited from DbConnectionStringBuilder.) |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetConnectionString | |
| GetHashCode | Serves as the default hash function. (Inherited from Object.) |
| GetProperties | Fills a supplied Hashtable with information about all the properties of this DbConnectionStringBuilder. (Inherited from DbConnectionStringBuilder.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| Remove | (Overrides DbConnectionStringBuilderRemove(String).) |
| ShouldSerialize | Indicates whether the specified key exists in this DbConnectionStringBuilder instance. (Inherited from DbConnectionStringBuilder.) |
| ToString | Returns the connection string associated with this DbConnectionStringBuilder. (Inherited from DbConnectionStringBuilder.) |
| TryGetValue | Retrieves a value corresponding to the supplied key from this DbConnectionStringBuilder. (Inherited from DbConnectionStringBuilder.) |
See Also