Classe ConnectionSettings
The ConnectionSettings class represents the settings used by a connection to an instance of a server, such as SQL Server. The ServerConnection class inherits ConnectionSettings class.
Hiérarchie d'héritage
System.Object
Microsoft.SqlServer.Management.Common.ConnectionSettings
Microsoft.SqlServer.Management.Common.ConnectionManager
Espace de noms : Microsoft.SqlServer.Management.Common
Assembly : Microsoft.SqlServer.ConnectionInfo (en Microsoft.SqlServer.ConnectionInfo.dll)
Syntaxe
'Déclaration
Public Class ConnectionSettings
'Utilisation
Dim instance As ConnectionSettings
public class ConnectionSettings
public ref class ConnectionSettings
type ConnectionSettings = class end
public class ConnectionSettings
Le type ConnectionSettings expose les membres suivants.
Propriétés
Nom | Description | |
---|---|---|
ApplicationName | Gets or sets the name of the application that has established the connection with the server. | |
ConnectAsUser | Gets or sets the Boolean property value that specifies whether the connection is established using impersonation. | |
ConnectAsUserName | Gets or sets the name of the user when connecting using impersonation. | |
ConnectAsUserPassword | Gets or sets the password for the user when connecting using impersonation. | |
ConnectionString | Gets or sets the connection string used to establish a connection with a specified data source. | |
ConnectTimeout | Gets or sets the connection time-out period in seconds. | |
DatabaseName | Gets or sets the database required by the connection. | |
EncryptConnection | Gets or sets the Boolean property value that specifies whether the connection is encrypted. | |
Login | Gets or sets the logon required to establish a connection with the instance of the server. | |
LoginSecure | Gets or sets the Boolean property that specifies whether the connection is established to the server by using Windows Authentication or SQL Server Authentication. | |
MaxPoolSize | Gets or sets the maximum number of connections in a connection pool that the specified connection accepts when establishing a connection with a server. | |
MinPoolSize | Gets or sets the minimum number of connections in a connection pool that the specified connection accepts when establishing a connection with a server. | |
MultipleActiveResultSets | Gets or sets the Boolean property value that specifies whether more than one active result set is permitted. | |
NetworkProtocol | Gets or sets the network protocol used to establish the connection to the server. | |
NonPooledConnection | Gets or sets the Boolean property value that specifies whether the connection may be pooled or nonpooled. | |
PacketSize | Gets or sets the packets of data sent between the client and the server over the network in bytes. | |
Password | Gets or sets the password used with the logon to establish a connection with the server when SQL Server Authentication is used. | |
PooledConnectionLifetime | Gets or sets the lifetime of the pooled connection. | |
ResetConnectionString | Gets or sets a Boolean value that specifies whether a node in the connection string has been changed. | |
SecureConnectionString | Gets or sets an encrypted version of the connection string. | |
SecurePassword | Gets or sets the secure password used with the logon to establish a connection with the server when SQL Server Authentication is used. | |
ServerInstance | Gets or sets the name of the server. | |
WorkstationId | Gets or sets the ID value that uniquely identifies the workstation. |
Haut de la page
Méthodes
Nom | Description | |
---|---|---|
Equals | (hérité de Object.) | |
Finalize | (hérité de Object.) | |
GetHashCode | (hérité de Object.) | |
GetType | (hérité de Object.) | |
MemberwiseClone | (hérité de Object.) | |
ThrowIfPropertyNotSet(String, String) | Throws an exception if the specified connection property is null or empty. | |
ThrowIfPropertyNotSet(String, String, Boolean) | Throws an exception if the specified connection property is null or, optionally, empty. | |
ToString | Returns the referenced object name as a string. (remplace Object.ToString().) |
Haut de la page
Champs
Nom | Description | |
---|---|---|
NoConnectionTimeout | Gets or sets the Int32 value that specifies the time the connection takes to time out in seconds. |
Haut de la page
Notes
Thread Safety
Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.
Sécurité des threads
Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.