Export (0) Print
Expand All

SqlConnectionStringBuilder Members

Provides a simple way to create and manage the contents of connection strings used by the SqlConnection class.

The following tables list the members exposed by the SqlConnectionStringBuilder type.

  Name Description
Public method SqlConnectionStringBuilder Overloaded. Initializes a new instance of the SqlConnectionStringBuilder class.
Top

  Name Description
Public property ApplicationName Gets or sets the name of the application associated with the connection string.
Public property AsynchronousProcessing Gets or sets a Boolean value that indicates whether asynchronous processing is allowed by the connection created by using this connection string.
Public property 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.
Public property BrowsableConnectionString  Gets or sets a value that indicates whether the ConnectionString property is visible in Visual Studio designers.(inherited from DbConnectionStringBuilder)
Public property ConnectionReset Gets or sets a Boolean value that indicates whether the connection is reset when drawn from the connection pool.
Public property ConnectionString  Gets or sets the connection string associated with the DbConnectionStringBuilder.(inherited from DbConnectionStringBuilder)
Public property ConnectTimeout Gets or sets the connection timeout.
Public property ContextConnection Gets or sets a value that indicates whether a client/server or in-process connection to SQL Server should be made.
Public property Count  Gets the current number of keys that are contained within the ConnectionString property.(inherited from DbConnectionStringBuilder)
Public property CurrentLanguage Gets or sets the SQL Server Language record name.
Public property DataSource Gets or sets the name or network address of the instance of SQL Server to connect to.
Public property 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.
Public property 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.
Public property FailoverPartner Gets or sets the name or address of the partner server to connect to if the primary server is down.
Public property InitialCatalog Gets or sets the name of the database associated with the connection.
Public property 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).
Public property IsFixedSize Overridden. Gets a value that indicates whether the SqlConnectionStringBuilder has a fixed size.
Public property IsReadOnly  Gets a value that indicates whether the DbConnectionStringBuilder is read-only.(inherited from DbConnectionStringBuilder)
Public property Item Overridden. Gets or sets the value associated with the specified key. In C#, this property is the indexer.
Public property Keys Overridden. Gets an ICollection that contains the keys in the SqlConnectionStringBuilder.
Public property LoadBalanceTimeout Gets or sets the minimum time, in seconds, for the connection to live in the connection pool before being destroyed.
Public property MaxPoolSize Gets or sets the maximum number of connections allowed in the connection pool for this specific connection string.
Public property MinPoolSize Gets or sets the minimum number of connections allowed in the connection pool for this specific connection string.
Public property MultipleActiveResultSets Gets or sets a Boolean value that indicates whether multiple active result sets can be associated with the associated connection.
Public property NetworkLibrary Gets or sets a string that contains the name of the network library used to establish a connection to the SQL Server.
Public property PacketSize Gets or sets the size in bytes of the network packets used to communicate with an instance of SQL Server.
Public property Password Gets or sets the password for the SQL Server account.
Public property 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.
Public property 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.
Public property Replication Gets or sets a Boolean value that indicates whether replication is supported using the connection.
Public property TrustServerCertificate Gets or sets a value that indicates whether the channel will be encrypted while bypassing walking the certificate chain to validate trust.
Public property TypeSystemVersion Gets or sets a string value that indicates the type system the application expects.
Public property UserID Gets or sets the user ID to be used when connecting to SQL Server.
Public property 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.
Public property Values Overridden. Gets an ICollection that contains the values in the SqlConnectionStringBuilder.
Public property WorkstationID Gets or sets the name of the workstation connecting to SQL Server.
Top

(see also Protected Methods )
  Name Description
Public method Add  Adds an entry with the specified key and value into the DbConnectionStringBuilder. (inherited from DbConnectionStringBuilder)
Public method Static AppendKeyValuePair  Overloaded. Provides an efficient and safe way to append a key and value to an existing StringBuilder object. (inherited from DbConnectionStringBuilder)
Public method Clear Overridden. Clears the contents of the SqlConnectionStringBuilder instance.
Public method ContainsKey Overridden. Determines whether the SqlConnectionStringBuilder contains a specific key.
Public method Equals  Overloaded. Determines whether two Object instances are equal. (inherited from Object)
Public method EquivalentTo  Compares the connection information in this DbConnectionStringBuilder object with the connection information in the supplied object. (inherited from DbConnectionStringBuilder)
Public method GetHashCode  Serves as a hash function for a particular type. (inherited from Object)
Public method GetType  Gets the Type of the current instance. (inherited from Object)
Public method Static ReferenceEquals  Determines whether the specified Object instances are the same instance. (inherited from Object)
Public method Remove Overridden. Removes the entry with the specified key from the SqlConnectionStringBuilder instance.
Public method ShouldSerialize Overridden. Indicates whether the specified key exists in this SqlConnectionStringBuilder instance.
Public method ToString  Returns the connection string associated with this DbConnectionStringBuilder. (inherited from DbConnectionStringBuilder)
Public method TryGetValue Overridden. Retrieves a value corresponding to the supplied key from this SqlConnectionStringBuilder.
Top

  Name Description
Protected method Finalize  Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (inherited from Object)
Protected method MemberwiseClone  Creates a shallow copy of the current Object. (inherited from Object)
Top

Community Additions

ADD
Show:
© 2014 Microsoft