System.Data.SqlClient Namespace
.NET Framework 2.0
The System.Data.SqlClient namespace is the.NET Framework Data Provider for SQL Server.
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 SqlDataAdapter, you can fill a memory-resident DataSet that you can use to query and update the database.
Note |
|---|
| For conceptual information about using this namespace when programming with the .NET Framework, see Using the .NET Framework Data Provider for SQL Server. |
| Class | Description | |
|---|---|---|
![]() | SqlBulkCopy | Lets you efficiently bulk load a SQL Server table with data from another source. |
![]() | SqlBulkCopyColumnMapping | Defines the mapping between a column in a SqlBulkCopy instance's data source and a column in the instance's destination table. |
![]() | SqlBulkCopyColumnMappingCollection | Collection of SqlBulkCopyColumnMapping objects that inherits from CollectionBase. |
![]() | 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 DataSet with the associated SQL Server database. This class cannot be inherited. |
![]() | SqlConnection | Represents an open connection to a SQL Server database. This class cannot be inherited. |
![]() | SqlConnectionStringBuilder | Provides a simple way to create and manage the contents of connection strings used by the SqlConnection class. |
![]() | SqlDataAdapter | Represents a set of data commands and a database connection that are used to fill the 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 SqlDependency object represents a query notification dependency between an application and an instance of SQL Server 2005. An application can create a SqlDependency object and register to receive notifications via the 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 InfoMessage event. |
![]() | SqlNotificationEventArgs | Represents the set of arguments passed to the notification event handler. |
![]() | SqlParameter | Represents a parameter to a SqlCommand and optionally its mapping to DataSet columns. This class cannot be inherited. |
![]() | SqlParameterCollection | Represents a collection of parameters associated with a SqlCommand and their respective mappings to columns in a DataSet. This class cannot be inherited. |
![]() | SqlRowsCopiedEventArgs | Represents the set of arguments passed to the SqlRowsCopiedEventHandler. |
![]() | SqlRowUpdatedEventArgs | Provides data for the RowUpdated event. |
![]() | SqlRowUpdatingEventArgs | Provides data for the RowUpdating event. |
![]() | SqlTransaction | Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited. |
| Delegate | Description | |
|---|---|---|
![]() | OnChangeEventHandler | Handles the OnChange event that is fired when a notification is received for any of the commands associated with a SqlDependency object. |
![]() | SqlInfoMessageEventHandler | Represents the method that will handle the InfoMessage event of a SqlConnection. |
![]() | SqlRowsCopiedEventHandler | Represents the method that handles the SqlRowsCopied event of a SqlBulkCopy. |
![]() | SqlRowUpdatedEventHandler | Represents the method that will handle the RowUpdated event of a SqlDataAdapter. |
![]() | SqlRowUpdatingEventHandler | Represents the method that will handle the RowUpdating event of a SqlDataAdapter. |
| Enumeration | Description | |
|---|---|---|
![]() | SqlBulkCopyOptions | Bitwise flag that specifies one or more options to use with an instance of SqlBulkCopy. |
![]() | 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 OnChangeEventHandler event handler through the SqlNotificationEventArgs parameter. |
Community Additions
ADD
Show:
Note 

