dotConnect for SQL Server Documentation
Devart.Data.SqlServer Namespace / SqlConnectionStringBuilder Class
Properties Methods

In This Topic
    SqlConnectionStringBuilder Class Members
    In This Topic

    The following tables list the members exposed by SqlConnectionStringBuilder.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded. Initializes a new instance of the SqlConnectionStringBuilder class.  
    Top
    Public Properties
     NameDescription
    Public PropertyDeclares the application workload type when connecting to a database - read write or read only.  
    Public PropertyGets or sets the name of the application associated with the connection string.  
    Public PropertyGets or sets a Boolean value that indicates whether asynchronous processing is allowed by the connection created by using this connection string.  
    Public PropertyGets or sets a string that contains the name of the primary file. This includes the full path name of an attachable database.  
    Public PropertyGets or sets the authentication method to use for connecting to SQL Azure.  
    Public PropertyGets or sets a Boolean value that determines whether the Always Encrypted feature is enabled for a connection.  
    Public PropertyGets or sets time span in seconds for connection to live.  
    Public PropertyGets or sets a Boolean value that indicates whether the connection is reset when drawn from the connection pool.  
    Public PropertyGets or sets the connection string associated with the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyGets or sets the time to wait while trying to establish a connection before terminating the attempt and generating an error.  
    Public PropertyGets or sets a value that indicates whether a client/server or in-process connection to SQL Server should be made.  
    Public PropertyGets the current number of keys that are contained within the System.Data.Common.DbConnectionStringBuilder.ConnectionString property. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyGets or sets the SQL Server Language record name.  
    Public PropertyGets or sets the name or network address of the instance of SQL Server to connect to.  
    Public PropertyGets or sets the time in seconds to wait while trying to execute a command before terminating the attempt and generating an error.  
    Public PropertyGets 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.  
    Public PropertyGets 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.  
    Public PropertyGets or sets the name or address of the server, where database mirroring is configured, to connect to if the primary server is down.  
    Public PropertyGets or sets the name of the database associated with the connection.  
    Public PropertySpecifies a data source-specific command that should be executed immediately after establishing the connection. (Inherited from Devart.Common.DbConnectionStringBuilder)
    Public PropertyGets or sets a Boolean value that indicates how the connection is authenticated.  
    Public PropertyOverridden. Returns true.  
    Public PropertyGets a value that indicates whether the System.Data.Common.DbConnectionStringBuilder is read-only. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyOverridden. Returns the value of given key.  
    Public PropertyOverridden. Collection of keys in the SqlConnectionStringBuilder.  
    Public PropertyGets or sets the minimum time, in seconds, for the connection to live in the connection pool before being destroyed.  
    Public PropertyThe maximum number of connections allowed in the pool.  
    Public PropertyThe minimum number of connections allowed in the pool.  
    Public PropertyDetermines 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.  
    Public PropertySpecifies whether to enable faster failover for all Availability Groups and or Failover Cluster Instance in SQL Server 2012.  
    Public PropertyGets or sets a string that contains the name of the network library used to establish a connection to the SQL Server.  
    Public PropertyGets or sets the size in bytes of the network packets used to communicate with an instance of SQL Server.  
    Public PropertyGets or sets the user's password to connect.  
    Public PropertyGets or sets a value indicating whether password is stored in connection string after connection is opened.  
    Public PropertyGets or sets pooling mode.  
    Public PropertyGets or sets a Boolean value that indicates whether replication is supported using the connection.  
    Public PropertySpecifies 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 PropertyEnables support for non-distributed transactions in the TransactionScope implementation.  
    Public PropertyGets or sets a value that indicates whether the channel will be encrypted while bypassing walking the certificate chain to validate trust.  
    Public PropertyGets or sets a string value that indicates the type system the application expects.  
    Public PropertyGets or sets the user ID to be used when connecting to SQL Server.  
    Public PropertyGets 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.  
    Public PropertyIndicates whether to validate connections that are being taken from the pool.  
    Public PropertyOverridden. Collection of values in the SqlConnectionStringBuilder.  
    Public PropertyGets or sets the name of the workstation connecting to SQL Server.  
    Top
    Public Methods
     NameDescription
    Public MethodAdds an entry with the specified key and value into the System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public MethodOverridden. Sets all SqlConnectionStringBuilder properties to default values.  
    Public MethodOverridden. Indicates whether specified key is set in the SqlConnectionStringBuilder object.  
    Public MethodOverloaded. 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)
    Public MethodOverridden. Sets value of the specified key to default.  
    Public MethodOverridden. Determines whether the key will be serialized if required.  
    Public MethodReturns the connection string associated with this System.Data.Common.DbConnectionStringBuilder. (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public MethodOverridden. Attempts to get a key value.  
    Top
    See Also