The System.Data.SqlClient namespace is the.NET Framework Data Provider for SQL Server.
Remarks
The.NET Framework Data Provider for SQL Server describes a collection of classes used to access a SQL Server database in the managed space. Using the System.Data.SqlClient.SqlDataAdapter, you can fill a memory-resident System.Data.DataSet that you can use to query and update the database.
For conceptual information about using this namespace when programming with the .NET Framework, see Using the .NET Framework Data Provider for SQL Server.
Classes
| Type | Reason |
|---|---|
| OnChangeEventHandler |
Handles the System.Data.SqlClient.SqlDependency.OnChange event that is fired when a notification is received for any of the commands associated with a System.Data.SqlClient.SqlDependency object. |
| SqlBulkCopy |
Lets you efficiently bulk load a SQL Server table with data from another source. |
| SqlBulkCopyColumnMapping |
Defines the mapping between a column in a System.Data.SqlClient.SqlBulkCopy instance's data source and a column in the instance's destination table. |
| SqlBulkCopyColumnMappingCollection |
Collection of System.Data.SqlClient.SqlBulkCopyColumnMapping objects that inherits from CollectionBase. |
| SqlBulkCopyOptions |
Bitwise flag that specifies one or more options to use with an instance of System.Data.SqlClient.SqlBulkCopy. |
| SqlClientFactory |
Represents a set of methods for creating instances of the System.Data.SqlClient provider's implementation of the data source classes. |
| SqlClientMetaDataCollectionNames |
Provides a list of constants for use with the GetSchema method to retrieve metadata collections. |
| SqlClientPermission |
Enables the .NET Framework Data Provider for SQL Server to help make sure that a user has a security level sufficient to access a data source. |
| SqlClientPermissionAttribute |
Associates a security action with a custom security attribute. |
| SqlCommand |
Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited. |
| SqlCommandBuilder |
Automatically generates single-table commands that are used to reconcile changes made to a System.Data.DataSet with the associated SQL Server database. This class cannot be inherited. |
| SqlConnection |
Represents an open connection to a ssNoVersion database. This class cannot be inherited. |
| SqlConnectionStringBuilder |
Provides a simple way to create and manage the contents of connection strings used by the System.Data.SqlClient.SqlConnection class. |
| SqlDataAdapter |
Represents a set of data commands and a database connection that are used to fill the System.Data.DataSet and update a SQL Server database. This class cannot be inherited. |
| SqlDataReader |
Provides a way of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited. |
| SQLDebugging |
Included to support debugging applications. Not intended for direct use. |
| SqlDependency |
The System.Data.SqlClient.SqlDependency object represents a query notification dependency between an application and an instance of SQL Server. An application can create a System.Data.SqlClient.SqlDependency object and register to receive notifications via the System.Data.SqlClient.OnChangeEventHandler event handler. |
| SqlError |
Collects information relevant to a warning or error returned by SQL Server. |
| SqlErrorCollection |
Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited. |
| SqlException |
The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited. |
| SqlInfoMessageEventArgs |
Provides data for the System.Data.SqlClient.SqlConnection.InfoMessage event. |
| SqlInfoMessageEventHandler |
Represents the method that will handle the System.Data.SqlClient.SqlConnection.InfoMessage event of a System.Data.SqlClient.SqlConnection. |
| SqlNotificationEventArgs |
Represents the set of arguments passed to the notification event handler. |
| SqlNotificationInfo |
This enumeration provides additional information about the different notifications that can be received by the dependency event handler. |
| SqlNotificationSource |
Indicates the source of the notification received by the dependency event handler. |
| SqlNotificationType |
Describes the different notification types that can be received by an System.Data.SqlClient.OnChangeEventHandler event handler through the System.Data.SqlClient.SqlNotificationEventArgs parameter. |
| SqlParameter |
Represents a parameter to a System.Data.SqlClient.SqlCommand and optionally its mapping to System.Data.DataSet columns. This class cannot be inherited. For more information on parameters, see Configuring Parameters and Parameter Data Types (ADO.NET). |
| SqlParameterCollection |
Represents a collection of parameters associated with a System.Data.SqlClient.SqlCommand and their respective mappings to columns in a System.Data.DataSet. This class cannot be inherited. |
| SqlRowsCopiedEventArgs |
Represents the set of arguments passed to the System.Data.SqlClient.SqlRowsCopiedEventHandler. |
| SqlRowsCopiedEventHandler |
Represents the method that handles the System.Data.SqlClient.SqlBulkCopy.SqlRowsCopied event of a System.Data.SqlClient.SqlBulkCopy. |
| SqlRowUpdatedEventArgs |
Provides data for the System.Data.SqlClient.SqlDataAdapter.RowUpdated event. |
| SqlRowUpdatedEventHandler |
Represents the method that will handle the System.Data.SqlClient.SqlDataAdapter.RowUpdated event of a System.Data.SqlClient.SqlDataAdapter. |
| SqlRowUpdatingEventArgs |
Provides data for the System.Data.SqlClient.SqlDataAdapter.RowUpdating event. |
| SqlRowUpdatingEventHandler |
Represents the method that will handle the System.Data.SqlClient.SqlDataAdapter.RowUpdating event of a System.Data.SqlClient.SqlDataAdapter. |
| SqlTransaction |
Represents a tsql transaction to be made in a ssNoVersion database. This class cannot be inherited. |