ConnectionSettings-Klasse

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.

Vererbungshierarchie

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

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

Syntax

'Declaration
Public Class ConnectionSettings
'Usage
Dim instance As ConnectionSettings
public class ConnectionSettings
public ref class ConnectionSettings
type ConnectionSettings =  class end
public class ConnectionSettings

Der ConnectionSettings-Typ macht folgende Elemente verfügbar.

Eigenschaften

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

Zum Anfang

Methoden

  Name Beschreibung
Öffentliche Methode Equals (Geerbt von Object.)
Geschützte Methode Finalize (Geerbt von Object.)
Öffentliche Methode GetHashCode (Geerbt von Object.)
Öffentliche Methode GetType (Geerbt von Object.)
Geschützte Methode MemberwiseClone (Geerbt von Object.)
Geschützte Methode ThrowIfPropertyNotSet(String, String) Throws an exception if the specified connection property is null or empty.
Geschützte Methode ThrowIfPropertyNotSet(String, String, Boolean) Throws an exception if the specified connection property is null or, optionally, empty.
Öffentliche Methode ToString Returns the referenced object name as a string. (Überschreibt Object. . :: . .ToString() () () ().)

Zum Anfang

Felder

  Name Beschreibung
Öffentliches FeldStatisches Element NoConnectionTimeout Gets or sets the Int32 value that specifies the time the connection takes to time out in seconds.

Zum Anfang

Hinweise

Thread Safety

Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Für Instanzelemente kann nicht sichergestellt werden, dass sie für Threads sicher sind.

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.