Partager via


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
Propriété publique ApplicationName Gets or sets the name of the application that has established the connection with the server.
Propriété publique ConnectAsUser Gets or sets the Boolean property value that specifies whether the connection is established using impersonation.
Propriété publique ConnectAsUserName Gets or sets the name of the user when connecting using impersonation.
Propriété publique ConnectAsUserPassword Gets or sets the password for the user when connecting using impersonation.
Propriété publique ConnectionString Gets or sets the connection string used to establish a connection with a specified data source.
Propriété publique ConnectTimeout Gets or sets the connection time-out period in seconds.
Propriété publique DatabaseName Gets or sets the database required by the connection.
Propriété publique EncryptConnection Gets or sets the Boolean property value that specifies whether the connection is encrypted.
Propriété publique Login Gets or sets the logon required to establish a connection with the instance of the server.
Propriété publique 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.
Propriété publique 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.
Propriété publique 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.
Propriété publique MultipleActiveResultSets Gets or sets the Boolean property value that specifies whether more than one active result set is permitted.
Propriété publique NetworkProtocol Gets or sets the network protocol used to establish the connection to the server.
Propriété publique NonPooledConnection Gets or sets the Boolean property value that specifies whether the connection may be pooled or nonpooled.
Propriété publique PacketSize Gets or sets the packets of data sent between the client and the server over the network in bytes.
Propriété publique Password Gets or sets the password used with the logon to establish a connection with the server when SQL Server Authentication is used.
Propriété publique PooledConnectionLifetime Gets or sets the lifetime of the pooled connection.
Propriété protégée ResetConnectionString Gets or sets a Boolean value that specifies whether a node in the connection string has been changed.
Propriété publique SecureConnectionString Gets or sets an encrypted version of the connection string.
Propriété publique SecurePassword Gets or sets the secure password used with the logon to establish a connection with the server when SQL Server Authentication is used.
Propriété publique ServerInstance Gets or sets the name of the server.
Propriété publique WorkstationId Gets or sets the ID value that uniquely identifies the workstation.

Haut de la page

Méthodes

  Nom Description
Méthode publique Equals (hérité de Object.)
Méthode protégée Finalize (hérité de Object.)
Méthode publique GetHashCode (hérité de Object.)
Méthode publique GetType (hérité de Object.)
Méthode protégée MemberwiseClone (hérité de Object.)
Méthode protégée ThrowIfPropertyNotSet(String, String) Throws an exception if the specified connection property is null or empty.
Méthode protégée ThrowIfPropertyNotSet(String, String, Boolean) Throws an exception if the specified connection property is null or, optionally, empty.
Méthode publique ToString Returns the referenced object name as a string. (remplace Object.ToString().)

Haut de la page

Champs

  Nom Description
Champ publicMembre statique 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.

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Management.Common