| Name | Description | |
|---|---|---|
 | SqlConnectionStringBuilder Constructor | Overloaded. Initializes a new instance of the SqlConnectionStringBuilder class. |
SqlConnectionStringBuilder Class Members
In This Topic
The following tables list the members exposed by SqlConnectionStringBuilder.
Public Constructors
Public Properties
| Name | Description | |
|---|---|---|
 | ApplicationIntent | Declares the application workload type when connecting to a database - read write or read only. |
| 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 file. This includes the full path name of an attachable database. |
| Authentication | Gets or sets the authentication method to use for connecting to SQL Azure. |
| ColumnEncryptionSetting | Gets or sets a Boolean value that determines whether the Always Encrypted feature is enabled for a connection. |
| ConnectionLifetime | Gets or sets time span in seconds for connection to live. |
| ConnectionReset | 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 System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder) |
| ConnectTimeout | Gets or sets the time to wait while trying to establish a connection 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 System.Data.Common.DbConnectionStringBuilder.ConnectionString property. (Inherited from System.Data.Common.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. |
| DefaultCommandTimeout | Gets or sets the time in seconds to wait while trying to execute a command before terminating the attempt and generating an error. |
| 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 server, where database mirroring is configured, to connect to if the primary server is down. |
| InitialCatalog | Gets or sets the name of the database associated with the connection. |
| InitializationCommand | Specifies a data source-specific command that should be executed immediately after establishing the connection. (Inherited from Devart.Common.DbConnectionStringBuilder) |
| IntegratedSecurity | Gets or sets a Boolean value that indicates how the connection is authenticated. |
| IsFixedSize | Overridden. Returns true. |
| IsReadOnly | Gets a value that indicates whether the System.Data.Common.DbConnectionStringBuilder is read-only. (Inherited from System.Data.Common.DbConnectionStringBuilder) |
| Item | Overridden. Returns the value of given key. |
| Keys | Overridden. Collection of keys in the SqlConnectionStringBuilder. |
| LoadBalanceTimeout | Gets or sets the minimum time, in seconds, for the connection to live in the connection pool before being destroyed. |
| MaxPoolSize | The maximum number of connections allowed in the pool. |
| MinPoolSize | The minimum number of connections allowed in the pool. |
| MultipleActiveResultSets | Determines whether the application can maintain multiple active result sets (MARS) or all result sets from one batch must be processsed or cancelled before any other batch can be executed on a connection. |
| MultiSubnetFailover | Specifies whether to enable faster failover for all Availability Groups and or Failover Cluster Instance in SQL Server 2012. |
| 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 user's password to connect. |
| PersistSecurityInfo | Gets or sets a value indicating whether password is stored in connection string after connection is opened. |
| Pooling | Gets or sets pooling mode. |
| Replication | Gets or sets a Boolean value that indicates whether replication is supported using the connection. |
| RunOnceCommand | Specifies 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) |
| TransactionScopeLocal | Enables support for non-distributed transactions in the TransactionScope implementation. |
| 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. |
| ValidateConnection | Indicates whether to validate connections that are being taken from the pool. |
| Values | Overridden. Collection of values in the SqlConnectionStringBuilder. |
| WorkstationID | Gets or sets the name of the workstation connecting to SQL Server. |
Public Methods
| Name | Description | |
|---|---|---|
 | Add | Adds an entry with the specified key and value into the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder) |
| Clear | Overridden. Sets all SqlConnectionStringBuilder properties to default values. |
| ContainsKey | Overridden. Indicates whether specified key is set in the SqlConnectionStringBuilder object. |
| EquivalentTo | Overloaded. Compares the specified connection information in this Devart.Common.DbConnectionStringBuilder object with the specified connection information in the supplied Devart.Common.DbConnectionStringBuilder object. (Inherited from Devart.Common.DbConnectionStringBuilder) |
| Remove | Overridden. Sets value of the specified key to default. |
| ShouldSerialize | Overridden. Determines whether the key will be serialized if required. |
| ToString | Returns the connection string associated with this System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder) |
| TryGetValue | Overridden. Attempts to get a key value. |
See Also