Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

SqlConnectionStringBuilder Properties

  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 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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.