Public Static (Shared) Properties
  CommandType | Changes the default CommandType. Default CommandType is Text. |
| Connection | An open connection to a SQL Server database. |
| DefaultDatabase | Changes the default database. |
Public Static (Shared) Methods
 ExecuteDataTable | Overloaded. Sends the System.Data.SqlClient.SqlCommand.CommandText to the System.Data.SqlClient.SqlCommand.Connection, and builds a System.Data.DataTable. |
| ExecuteNonQuery | Overloaded. Executes a Transact-SQL statement against the connection and returns the number of rows affected. |
| ExecuteReader | Overloaded. Sends the System.Data.SqlClient.SqlCommand.CommandText to the System.Data.SqlClient.SqlCommand.Connection, and builds a System.Data.SqlClient.SqlDataReader. |
| ExecuteScalar | Overloaded. Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored. |
Public Instance Methods
| Equals (inherited from Object) | Determines whether the specified Object is equal to the current Object. |
| GetHashCode (inherited from Object) | Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table. |
| GetType (inherited from Object) | Gets the Type of the current instance. |
| ToString (inherited from Object) | Returns a String that represents the current Object. |
Protected Instance Methods
 Finalize (inherited from Object) | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. |
| MemberwiseClone (inherited from Object) | Creates a shallow copy of the current Object. |