ServerConnection 成員
The ServerConnection object represents a connection to a server.
ServerConnection 型別公開下列成員。
建構函式
| 名稱 | 描述 | |
|---|---|---|
.gif "公用方法") |
ServerConnection() () () () | Initializes a new instance of the ServerConnection class. |
|
ServerConnection(SqlConnection) | Initializes a new instance of the ServerConnection class with the specified connection parameters. |
|
ServerConnection(String) | Initializes a new instance of the ServerConnection class with the specified server instance. |
|
ServerConnection(SqlConnectionInfo) | Initializes a new instance of the ServerConnection class with the specified connection information. |
|
ServerConnection(String, String, SecureString) | Initializes a new instance of the ServerConnection class with the specified server instance and logon credentials. |
|
ServerConnection(String, String, String) | Initializes a new instance of the ServerConnection class with the specified server instance and logon credentials. |
頂端
方法
| 名稱 | 描述 | |
|---|---|---|
|
BeginTransaction | Starts a transaction on the referenced connection. |
|
Cancel | Cancels the connection. |
|
ChangePassword(SecureString) | Changes the login password that is used with standard authentication. |
|
ChangePassword(String) | Changes the logon password that is used with standard authentication. |
.gif "受保護的方法") |
CheckServerVersion | Checks the version of the target instance of SQL Server. (繼承自 ConnectionManager。) |
|
CommitTransaction | Commits the current transaction on the referenced connection. |
|
Connect | Connects to the instance of SQL Server. (繼承自 ConnectionManager。) |
|
Copy | Returns a copy of the ServerConnection object. |
|
Disconnect | Disconnects from the instance of SQL Server. (繼承自 ConnectionManager。) |
|
Equals | (繼承自 Object。) |
|
ExecuteNonQuery(StringCollection) | Executes a batch of statements that do not return a result set. |
|
ExecuteNonQuery(String) | Executes a statement that does not return a result set. |
|
ExecuteNonQuery(StringCollection, ExecutionTypes) | Executes a batch of statements with the specified execution options that does not return a result set. |
|
ExecuteNonQuery(String, ExecutionTypes) | Executes a statement with the specified execution options that does not return a result set. |
|
ExecuteReader | Executes Transact-SQL statements that return one or multiple result sets. |
|
ExecuteScalar(StringCollection) | Executes a batch of Transact-SQL statements and returns the first column of the first row as an object value. |
|
ExecuteScalar(String) | Executes a Transact-SQL statement and returns the first column of the first row as an object value. |
|
ExecuteWithResults(StringCollection) | Executes a batch of Transact-SQL statements that return multiple result sets. |
|
ExecuteWithResults(String) | Executes a Transact-SQL statement that returns a result set. |
|
Finalize | (繼承自 Object。) |
|
GetHashCode | (繼承自 Object。) |
|
GetType | (繼承自 Object。) |
|
IsInFixedServerRole | Tests whether the logon associated with the referenced connection is a member of the specified fixed server role. |
|
MemberwiseClone | (繼承自 Object。) |
.gif "靜態成員") |
NormalizeQuery(String) | |
|
NormalizeQuery(String, Boolean) | |
|
RollBackTransaction | Rolls back the current transaction. |
|
ThrowIfPropertyNotSet(String, String) | Throws an exception if the specified connection property is null or empty. (繼承自 ConnectionSettings。) |
|
ThrowIfPropertyNotSet(String, String, Boolean) | Throws an exception if the specified connection property is null or, optionally, empty. (繼承自 ConnectionSettings。) |
|
ToString | Returns the referenced object name as a string. (繼承自 ConnectionSettings。) |
頂端
屬性
| 名稱 | 描述 | |
|---|---|---|
.gif "公用屬性") |
ApplicationName | Gets or sets the name of the application that has established the connection with the server. (繼承自 ConnectionSettings。) |
|
AutoDisconnectMode | Gets or sets the automatic disconnection mode of the referenced connection to the instance of SQL Server. (繼承自 ConnectionManager。) |
|
BatchSeparator | Gets or sets the string value used to separate batches in the referenced connection. |
|
CapturedSql | Gets the Transact-SQL statements that are captured when the connection is running in capture mode. (繼承自 ConnectionManager。) |
|
ConnectAsUser | Gets or sets the Boolean property value that specifies whether the connection is established using impersonation. (繼承自 ConnectionSettings。) |
|
ConnectAsUserName | Gets or sets the name of the user when connecting using impersonation. (繼承自 ConnectionSettings。) |
|
ConnectAsUserPassword | Gets or sets the password for the user when connecting using impersonation. (繼承自 ConnectionSettings。) |
|
ConnectionString | Gets or sets the connection string used to establish a connection with a specified data source. (繼承自 ConnectionSettings。) |
|
ConnectionType | |
|
ConnectTimeout | Gets or sets the connection time-out period in seconds. (繼承自 ConnectionSettings。) |
|
DatabaseName | Gets or sets the database required by the connection. (繼承自 ConnectionSettings。) |
|
EncryptConnection | Gets or sets the Boolean property value that specifies whether the connection is encrypted. (繼承自 ConnectionSettings。) |
|
FixedServerRoles | Gets the fixed server role associated with the referenced connection. |
|
InUse | Gets or sets the Boolean property value that specifies whether the connection is being used. (繼承自 ConnectionManager。) |
|
IsOpen | Gets the Boolean property value that specifies whether the connection is currently open. (繼承自 ConnectionManager。) |
|
LockTimeout | Gets or sets the time in seconds required for the connection to time out when the current transaction is locked. (繼承自 ConnectionManager。) |
|
Login | Gets or sets the logon required to establish a connection with the instance of the server. (繼承自 ConnectionSettings。) |
|
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. (繼承自 ConnectionSettings。) |
|
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. (繼承自 ConnectionSettings。) |
|
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. (繼承自 ConnectionSettings。) |
|
MultipleActiveResultSets | Gets or sets the Boolean property value that specifies whether more than one active result set is permitted. (繼承自 ConnectionSettings。) |
|
NetworkProtocol | Gets or sets the network protocol used to establish the connection to the server. (繼承自 ConnectionSettings。) |
|
NonPooledConnection | Gets or sets the Boolean property value that specifies whether the connection may be pooled or nonpooled. (繼承自 ConnectionSettings。) |
|
PacketSize | Gets or sets the packets of data sent between the client and the server over the network in bytes. (繼承自 ConnectionSettings。) |
|
ParameterizationMode | |
|
Password | Gets or sets the password used with the logon to establish a connection with the server when SQL Server Authentication is used. (繼承自 ConnectionSettings。) |
|
PooledConnectionLifetime | Gets or sets the lifetime of the pooled connection. (繼承自 ConnectionSettings。) |
|
ProcessID | Gets the ID value that uniquely identifies the process associated with the referenced connection to the server. |
|
SecureConnectionString | Gets or sets an encrypted version of the connection string. (繼承自 ConnectionSettings。) |
|
SecurePassword | Gets or sets the secure password used with the logon to establish a connection with the server when SQL Server Authentication is used. (繼承自 ConnectionSettings。) |
|
ServerInstance | Gets or sets the name of the server. (繼承自 ConnectionSettings。) |
|
ServerVersion | Gets the version of the connected instance of SQL Server. (繼承自 ConnectionManager。) |
|
SqlConnectionObject | Gets the connection object. (繼承自 ConnectionManager。) |
|
SqlExecutionModes | Gets or sets the execution mode associated with the referenced connection to the server. |
|
StatementTimeout | Gets or sets the number of seconds a statement is given to run before failing with a time-out error. |
|
TransactionDepth | Gets the current transaction depth for the referenced connection. |
|
TrueLogin | Gets the current logon record name used by the referenced connection. |
|
TrueName | Gets the name of the server. |
|
UseMode | |
|
UserProfile | Gets the user profile associated with the referenced connection. |
|
WorkstationId | Gets or sets the ID value that uniquely identifies the workstation. (繼承自 ConnectionSettings。) |
頂端
事件
| 名稱 | 描述 | |
|---|---|---|
.gif "公用事件") |
InfoMessage | The event that occurs when the instance of SQL Server generates an informational message. (繼承自 ConnectionManager。) |
|
RemoteLoginFailed | This event occurs when a remote login fails to connect to the instance of SQL Server. (繼承自 ConnectionManager。) |
|
ServerMessage | The event that occurs when SQL Server returns a warning or informational message on the current connection. (繼承自 ConnectionManager。) |
|
StateChange | The event that occurs when the instance of SQL Server changes state. (繼承自 ConnectionManager。) |
|
StatementExecuted | The event that occurs when the instance of SQL Server executes a statement on the current connection. (繼承自 ConnectionManager。) |
頂端
.gif "明確介面實作")
.gif "私用方法")
.gif "私用屬性")