System.Data.SqlClient Namespace ()

Switch on low bandwidth view

Collapse All

This page is specific to

Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:

.NET Framework Class Library

System.Data.SqlClient Namespace

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 SQL Server and ADO.NET. Caution ADO.NET 2.0 does not support Asynchronous commands over shared memory for SQL Server 2000 or lower. However, you can force TCP instead of shared memory. You can do that by prefixing tcp: to the server name in the connection string or you can use localhost .

Note:

For conceptual information about using this namespace when programming with the .NET Framework, see SQL Server and ADO.NET.

Caution ADO.NET 2.0 does not support Asynchronous commands over shared memory for SQL Server 2000 or lower. However, you can force TCP instead of shared memory. You can do that by prefixing tcp: to the server name in the connection string or you can use localhost .

Classes

	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	Infrastructure. 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.

Delegates

	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.

Enumerations

	Enumeration	Description
	SortOrder	Specifies how rows of data are sorted.
	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.