Compartir a través de


Clase 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.

Jerarquía de herencia

System.Object
  Microsoft.SqlServer.Management.Common.ConnectionSettings
    Microsoft.SqlServer.Management.Common.ConnectionManager

Espacio de nombres:  Microsoft.SqlServer.Management.Common
Ensamblado:  Microsoft.SqlServer.ConnectionInfo (en Microsoft.SqlServer.ConnectionInfo.dll)

Sintaxis

'Declaración
Public Class ConnectionSettings
'Uso
Dim instance As ConnectionSettings
public class ConnectionSettings
public ref class ConnectionSettings
type ConnectionSettings =  class end
public class ConnectionSettings

El tipo ConnectionSettings expone los siguientes miembros.

Propiedades

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

Arriba

Métodos

  Nombre Descripción
Método público Equals (Se hereda de Object.)
Método protegido Finalize (Se hereda de Object.)
Método público GetHashCode (Se hereda de Object.)
Método público GetType (Se hereda de Object.)
Método protegido MemberwiseClone (Se hereda de Object.)
Método protegido ThrowIfPropertyNotSet(String, String) Throws an exception if the specified connection property is null or empty.
Método protegido ThrowIfPropertyNotSet(String, String, Boolean) Throws an exception if the specified connection property is null or, optionally, empty.
Método público ToString Returns the referenced object name as a string. (Invalida Object.ToString().)

Arriba

Campos

  Nombre Descripción
Campo públicoMiembro estático NoConnectionTimeout Gets or sets the Int32 value that specifies the time the connection takes to time out in seconds.

Arriba

Comentarios

Thread Safety

Todos los miembros estáticos (compartidos en Microsoft Visual Basic) públicos de este tipo son seguros para operaciones multiproceso. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Management.Common