SqlConnectionStringBuilder Properties
.NET Framework 3.5
The SqlConnectionStringBuilder type exposes the following members.
| Name | Description | |
|---|---|---|
|
ApplicationName | Gets or sets the name of the application associated with the connection string. |
|
|
AsynchronousProcessing | Gets or sets a Boolean value that indicates whether asynchronous processing is allowed by the connection created by using this connection string. |
|
|
AttachDBFilename | Gets or sets a string that contains the name of the primary data file. This includes the full path name of an attachable database. |
|
|
BrowsableConnectionString | Gets or sets a value that indicates whether the ConnectionString property is visible in Visual Studio designers. (Inherited from DbConnectionStringBuilder.) |
|
|
ConnectionReset | Obsolete. Gets or sets a Boolean value that indicates whether the connection is reset when drawn from the connection pool. |
|
|
ConnectionString | Gets or sets the connection string associated with the DbConnectionStringBuilder. (Inherited from DbConnectionStringBuilder.) |
|
|
ConnectTimeout | Gets or sets the length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. |
|
|
ContextConnection | Gets or sets a value that indicates whether a client/server or in-process connection to SQL Server should be made. |
|
|
Count | Gets the current number of keys that are contained within the ConnectionString property. (Inherited from DbConnectionStringBuilder.) |
|
|
CurrentLanguage | Gets or sets the SQL Server Language record name. |
|
|
DataSource | Gets or sets the name or network address of the instance of SQL Server to connect to. |
|
|
Encrypt | Gets or sets a Boolean value that indicates whether SQL Server uses SSL encryption for all data sent between the client and server if the server has a certificate installed. |
|
|
Enlist | Gets or sets a Boolean value that indicates whether the SQL Server connection pooler automatically enlists the connection in the creation thread's current transaction context. |
|
|
FailoverPartner | Gets or sets the name or address of the partner server to connect to if the primary server is down. |
|
|
InitialCatalog | Gets or sets the name of the database associated with the connection. |
|
|
IntegratedSecurity | Gets or sets a Boolean value that indicates whether User ID and Password are specified in the connection (when false) or whether the current Windows account credentials are used for authentication (when true). |
|
|
IsFixedSize | Gets a value that indicates whether the SqlConnectionStringBuilder has a fixed size. (Overrides DbConnectionStringBuilder.IsFixedSize.) |
|
|
IsReadOnly | Gets a value that indicates whether the DbConnectionStringBuilder is read-only. (Inherited from DbConnectionStringBuilder.) |
|
|
Item | Gets or sets the value associated with the specified key. In C#, this property is the indexer. (Overrides DbConnectionStringBuilder.Item[String].) |
|
|
Keys | Gets an ICollection that contains the keys in the SqlConnectionStringBuilder. (Overrides DbConnectionStringBuilder.Keys.) |
|
|
LoadBalanceTimeout | Gets or sets the minimum time, in seconds, for the connection to live in the connection pool before being destroyed. |
|
|
MaxPoolSize | Gets or sets the maximum number of connections allowed in the connection pool for this specific connection string. |
|
|
MinPoolSize | Gets or sets the minimum number of connections allowed in the connection pool for this specific connection string. |
|
|
MultipleActiveResultSets | Gets or sets a Boolean value that indicates whether multiple active result sets can be associated with the associated connection. |
|
|
NetworkLibrary | Gets or sets a string that contains the name of the network library used to establish a connection to the SQL Server. |
|
|
PacketSize | Gets or sets the size in bytes of the network packets used to communicate with an instance of SQL Server. |
|
|
Password | Gets or sets the password for the SQL Server account. |
|
|
PersistSecurityInfo | Gets or sets a Boolean value that indicates if security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. |
|
|
Pooling | Gets or sets a Boolean value that indicates whether the connection will be pooled or explicitly opened every time that the connection is requested. |
|
|
Replication | Gets or sets a Boolean value that indicates whether replication is supported using the connection. |
|
|
TransactionBinding | Gets or sets a string value that indicates how the connection maintains its association with an enlisted System.Transactions transaction. |
|
|
TrustServerCertificate | Gets or sets a value that indicates whether the channel will be encrypted while bypassing walking the certificate chain to validate trust. |
|
|
TypeSystemVersion | Gets or sets a string value that indicates the type system the application expects. |
|
|
UserID | Gets or sets the user ID to be used when connecting to SQL Server. |
|
|
UserInstance | Gets or sets a value that indicates whether to redirect the connection from the default SQL Server Express instance to a runtime-initiated instance running under the account of the caller. |
|
|
Values | Gets an ICollection that contains the values in the SqlConnectionStringBuilder. (Overrides DbConnectionStringBuilder.Values.) |
|
|
WorkstationID | Gets or sets the name of the workstation connecting to SQL Server. |
| Name | Description | |
|---|---|---|
|
ICollection.IsSynchronized | (Inherited from DbConnectionStringBuilder.) |
|
|
IDictionary.Item | (Inherited from DbConnectionStringBuilder.) |
|
|
ICollection.SyncRoot | (Inherited from DbConnectionStringBuilder.) |
