ServerConnection Methods

Include Protected Members
Include Inherited Members

The ServerConnection type exposes the following members.

Methods

  Name Description
Public method BeginTransaction Starts a transaction on the referenced connection.
Public method Cancel Cancels the connection.
Public method ChangePassword(SecureString) Changes the login password that is used with standard authentication.
Public method ChangePassword(String) Changes the logon password that is used with standard authentication.
Public method CommitTransaction Commits the current transaction on the referenced connection.
Public method Connect Connects to the instance of SQL Server. (Inherited from ConnectionManager.)
Public method Copy Returns a copy of the ServerConnection object.
Public method Disconnect Disconnects from the instance of SQL Server. (Inherited from ConnectionManager.)
Public method Equals (Inherited from Object.)
Public method ExecuteNonQuery(StringCollection) Executes a batch of statements that do not return a result set.
Public method ExecuteNonQuery(String) Executes a statement that does not return a result set.
Public method ExecuteNonQuery(StringCollection, ExecutionTypes) Executes a batch of statements with the specified execution options that does not return a result set.
Public method ExecuteNonQuery(String, ExecutionTypes) Executes a statement with the specified execution options that does not return a result set.
Public method ExecuteReader(String) Executes Transact-SQL statements that return one or multiple result sets.
Public method ExecuteReader(String, SqlCommand%) Executes a reader using a SqlDataReader object value that contains one or more result sets.
Public method ExecuteScalar(StringCollection) Executes a batch of Transact-SQL statements and returns the first column of the first row as an object value.
Public method ExecuteScalar(String) Executes a Transact-SQL statement and returns the first column of the first row as an object value.
Public method ExecuteWithResults(StringCollection) Executes a batch of Transact-SQL statements that return multiple result sets.
Public method ExecuteWithResults(String) Executes a Transact-SQL statement that returns a result set.
Public method ForceDisconnected Forces a disconnect from the instance of SQL Server. (Inherited from ConnectionManager.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Public method IsInFixedServerRole Tests whether the logon associated with the referenced connection is a member of the specified fixed server role.
Public methodStatic member NormalizeQuery(String) Uses a string input that represents the query text.
Public methodStatic member NormalizeQuery(String, Boolean) Normalizes the query that controls the server connection.
Public method RollBackTransaction Rolls back the current transaction.
Public method ToString Returns the referenced object name as a string. (Inherited from ConnectionSettings.)

Top

Explicit Interface Implementations

  Name Description
Explicit interface implemetationPrivate method ISfcConnection.Connect Returns a value that indicates the server to connect using an SFC connection.
Explicit interface implemetationPrivate method ISfcConnection.Copy Uses the SFC connection to copy the server connection.
Explicit interface implemetationPrivate method ISfcConnection.Disconnect Disconnects the connection.
Explicit interface implemetationPrivate method ISfcConnection.ToEnumeratorObject Renders an enumerator object for the server connection.

Top

See Also

Reference

ServerConnection Class

Microsoft.SqlServer.Management.Common Namespace