System.Data.SqlClient
TOC
Collapse the table of content
Expand the table of content

System.Data.SqlClient Namespace

 

The System.Data.SqlClient namespace is the.NET Framework Data Provider for SQL Server.

ClassDescription
System_CAPS_pubclassSqlBulkCopy

Lets you efficiently bulk load a SQL Server table with data from another source.

System_CAPS_pubclassSqlBulkCopyColumnMapping

Defines the mapping between a column in a SqlBulkCopy instance's data source and a column in the instance's destination table.

System_CAPS_pubclassSqlBulkCopyColumnMappingCollection

Collection of SqlBulkCopyColumnMapping objects that inherits from CollectionBase.

System_CAPS_pubclassSqlClientFactory

Represents a set of methods for creating instances of the System.Data.SqlClient provider's implementation of the data source classes.

System_CAPS_pubclassSqlClientMetaDataCollectionNames

Provides a list of constants for use with the GetSchema method to retrieve metadata collections.

System_CAPS_pubclassSqlClientPermission

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.

System_CAPS_pubclassSqlClientPermissionAttribute

Associates a security action with a custom security attribute.

System_CAPS_pubclassSqlColumnEncryptionCertificateStoreProvider

The implementation of the key store provider for Windows Certificate Store. This class enables using certificates stored in the Windows Certificate Store as column master keys. For details, see Always Encrypted.

System_CAPS_pubclassSqlColumnEncryptionCngProvider

The CMK Store provider implementation for using the Microsoft Cryptography API: Next Generation (CNG) with Always Encrypted.

System_CAPS_pubclassSqlColumnEncryptionCspProvider

The CMK Store provider implementation for using Microsoft CAPI based Cryptographic Service Providers (CSP) with Always Encrypted.

System_CAPS_pubclassSqlColumnEncryptionKeyStoreProvider

Base class for all key store providers. A custom provider must derive from this class and override its member functions and then register it using SqlConnection.RegisterColumnEncryptionKeyStoreProviders(). For details see, Always Encrypted.

System_CAPS_pubclassSqlCommand

Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.

System_CAPS_pubclassSqlCommandBuilder

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.

System_CAPS_pubclassSqlConnection

Represents an open connection to a SQL Server database. This class cannot be inherited.

System_CAPS_pubclassSqlConnectionStringBuilder

Provides a simple way to create and manage the contents of connection strings used by the SqlConnection class.

System_CAPS_pubclassSqlCredential

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.

System_CAPS_pubclassSqlDataAdapter

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.

System_CAPS_pubclassSqlDataReader

Provides a way of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.

System_CAPS_pubclassSQLDebugging

This API supports the product infrastructure and is not intended to be used directly from your code. Included to support debugging applications. Not intended for direct use.

System_CAPS_pubclassSqlDependency

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.

System_CAPS_pubclassSqlError

Collects information relevant to a warning or error returned by SQL Server.

System_CAPS_pubclassSqlErrorCollection

Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited.

System_CAPS_pubclassSqlException

The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited.

System_CAPS_pubclassSqlInfoMessageEventArgs

Provides data for the InfoMessage event.

System_CAPS_pubclassSqlNotificationEventArgs

Represents the set of arguments passed to the notification event handler.

System_CAPS_pubclassSqlParameter

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.

System_CAPS_pubclassSqlParameterCollection

Represents a collection of parameters associated with a SqlCommand and their respective mappings to columns in a DataSet. This class cannot be inherited.

System_CAPS_pubclassSqlProviderServices

The DbProviderServices implementation for the SqlClient provider for SQL Server.

System_CAPS_pubclassSqlRowsCopiedEventArgs

Represents the set of arguments passed to the SqlRowsCopiedEventHandler.

System_CAPS_pubclassSqlRowUpdatedEventArgs

Provides data for the RowUpdated event.

System_CAPS_pubclassSqlRowUpdatingEventArgs

Provides data for the RowUpdating event.

System_CAPS_pubclassSqlTransaction

Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited.

DelegateDescription
System_CAPS_pubdelegateOnChangeEventHandler

Handles the OnChange event that is fired when a notification is received for any of the commands associated with a SqlDependency object.

System_CAPS_pubdelegateSqlInfoMessageEventHandler

Represents the method that will handle the InfoMessage event of a SqlConnection.

System_CAPS_pubdelegateSqlRowsCopiedEventHandler

Represents the method that handles the SqlRowsCopied event of a SqlBulkCopy.

System_CAPS_pubdelegateSqlRowUpdatedEventHandler

Represents the method that will handle the RowUpdated event of a SqlDataAdapter.

System_CAPS_pubdelegateSqlRowUpdatingEventHandler

Represents the method that will handle the RowUpdating event of a SqlDataAdapter.

EnumerationDescription
System_CAPS_pubenumApplicationIntent

Specifies a value for ApplicationIntent. Possible values are ReadWrite and ReadOnly.

System_CAPS_pubenumPoolBlockingPeriod

Specifies a value for PoolBlockingPeriod Property.

System_CAPS_pubenumSortOrder

Specifies how rows of data are sorted.

System_CAPS_pubenumSqlAuthenticationMethod

Describes the different SQL authentication methods that can be used by a client connecting to Azure SQL Database. For details, see Connecting to SQL Database By Using Azure Active Directory Authentication.

System_CAPS_pubenumSqlBulkCopyOptions

Bitwise flag that specifies one or more options to use with an instance of SqlBulkCopy.

System_CAPS_pubenumSqlCommandColumnEncryptionSetting

Specifies how data will be sent and received when reading and writing encrypted columns. Depending on your specific query, performance impact may be reduced by bypassing the Always Encrypted driver’s processing when non-encrypted columns are being used. Note that these settings cannot be used to bypass encryption and gain access to plaintext data. For details, see Always Encrypted (Database Engine)

System_CAPS_pubenumSqlConnectionColumnEncryptionSetting

Specifies that Always Encrypted functionality is enabled in a connection. Note that these settings cannot be used to bypass encryption and gain access to plaintext data. For details, see Always Encrypted (Database Engine).

System_CAPS_pubenumSqlNotificationInfo

This enumeration provides additional information about the different notifications that can be received by the dependency event handler.

System_CAPS_pubenumSqlNotificationSource

Indicates the source of the notification received by the dependency event handler.

System_CAPS_pubenumSqlNotificationType

Describes the different notification types that can be received by an OnChangeEventHandler event handler through the SqlNotificationEventArgs parameter.

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.

System_CAPS_noteNote

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

Return to top
Show:
© 2016 Microsoft