MySQL Connector/Net
| MySqlConnectionStringBuilder Properties |
The MySqlConnectionStringBuilder type exposes the following members.
Properties
| 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.) |
See Also