• Article

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.
Protected method CheckServerVersion(ServerVersion) Checks the version of the target instance of SQL Server. (Inherited from ConnectionManager.)
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(Object) (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 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.
Protected method Finalize() (Inherited from Object.)
Public method GetHashCode() (Inherited from Object.)
Public method GetType() (Inherited from Object.)
Public method IsInFixedServerRole(FixedServerRoles) Tests whether the logon associated with the referenced connection is a member of the specified fixed server role.
Protected method MemberwiseClone() (Inherited from Object.)
Public methodStatic member NormalizeQuery(String)
Public methodStatic member NormalizeQuery(String, Boolean)
Public method RollBackTransaction() Rolls back the current transaction.
Protected method ThrowIfPropertyNotSet(String, String) Throws an exception if the specified connection property is null or empty. (Inherited from ConnectionSettings.)
Protected method ThrowIfPropertyNotSet(String, String, Boolean) Throws an exception if the specified connection property is null or, optionally, empty. (Inherited from ConnectionSettings.)
Public method ToString() Returns the referenced object name as a string. (Inherited from ConnectionSettings.)

Top