23 out of 31 rated this helpful - Rate this topic

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 Note

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

  Class Description
Public class SqlBulkCopy Lets you efficiently bulk load a SQL Server table with data from another source.
Public class SqlBulkCopyColumnMapping Defines the mapping between a column in a SqlBulkCopy instance's data source and a column in the instance's destination table.
Public class SqlBulkCopyColumnMappingCollection Collection of SqlBulkCopyColumnMapping objects that inherits from CollectionBase.
Public class SqlClientFactory Represents a set of methods for creating instances of the System.Data.SqlClient provider's implementation of the data source classes.
Public class SqlClientMetaDataCollectionNames Provides a list of constants for use with the GetSchema method to retrieve metadata collections.
Public class 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.
Public class SqlClientPermissionAttribute Associates a security action with a custom security attribute.
Public class SqlCommand Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.
Public class 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.
Public class SqlConnection Represents an open connection to a SQL Server database. This class cannot be inherited.
Public class SqlConnectionStringBuilder Provides a simple way to create and manage the contents of connection strings used by the SqlConnection class.
Public class SqlCredential SqlCredential provides a more secure way to specify the password for a login attempt using SQL Server Authentication.SqlCredential is comprised of a user id and a password that will be used for SQL Server Authentication. The password in a SqlCredential object is of type SecureString.SqlCredential cannot be inherited.Windows Authentication (Integrated Security = true) remains the most secure way to log in to a SQL Server database.
Public 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.
Public class SqlDataReader Provides a way of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.
Public class SQLDebugging Infrastructure. Included to support debugging applications. Not intended for direct use.
Public class SqlDependency The SqlDependency object represents a query notification dependency between an application and an instance of SQL Server. An application can create a SqlDependency object and register to receive notifications via the OnChangeEventHandler event handler.
Public class SqlError Collects information relevant to a warning or error returned by SQL Server.
Public class SqlErrorCollection Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited.
Public class SqlException The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited.
Public class SqlInfoMessageEventArgs Provides data for the InfoMessage event.
Public class SqlNotificationEventArgs Represents the set of arguments passed to the notification event handler.
Public class SqlParameter Represents a parameter to a SqlCommand and optionally its mapping to DataSet columns. This class cannot be inherited. For more information on parameters, see Configuring Parameters and Parameter Data Types.
Public class SqlParameterCollection Represents a collection of parameters associated with a SqlCommand and their respective mappings to columns in a DataSet. This class cannot be inherited.
Public class SqlProviderServices The DbProviderServices implementation for the SqlClient provider for SQL Server.
Public class SqlRowsCopiedEventArgs Represents the set of arguments passed to the SqlRowsCopiedEventHandler.
Public class SqlRowUpdatedEventArgs Provides data for the RowUpdated event.
Public class SqlRowUpdatingEventArgs Provides data for the RowUpdating event.
Public class SqlTransaction Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited.
  Delegate Description
Public delegate OnChangeEventHandler Handles the OnChange event that is fired when a notification is received for any of the commands associated with a SqlDependency object.
Public delegate SqlInfoMessageEventHandler Represents the method that will handle the InfoMessage event of a SqlConnection.
Public delegate SqlRowsCopiedEventHandler Represents the method that handles the SqlRowsCopied event of a SqlBulkCopy.
Public delegate SqlRowUpdatedEventHandler Represents the method that will handle the RowUpdated event of a SqlDataAdapter.
Public delegate SqlRowUpdatingEventHandler Represents the method that will handle the RowUpdating event of a SqlDataAdapter.
  Enumeration Description
Public enumeration ApplicationIntent Specifies a value for ApplicationIntent. Possible values are ReadWrite and ReadOnly.
Public enumeration SortOrder Specifies how rows of data are sorted.
Public enumeration SqlBulkCopyOptions Bitwise flag that specifies one or more options to use with an instance of SqlBulkCopy.
Public enumeration SqlNotificationInfo This enumeration provides additional information about the different notifications that can be received by the dependency event handler.
Public enumeration SqlNotificationSource Indicates the source of the notification received by the dependency event handler.
Public enumeration SqlNotificationType Describes the different notification types that can be received by an OnChangeEventHandler event handler through the SqlNotificationEventArgs parameter.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.