Microsoft.Data.SqlClient
Namespace with 58 public types
Classes
SqlBulkCopy
Lets you efficiently bulk load a SQL Server table with data from another source.
SqlBulkCopyColumnMapping
Defines the mapping between a column in a instance's data source and a column in the instance's destination table.
SqlBulkCopyColumnMappingCollection
Collection of objects that inherits from .
SqlBulkCopyColumnOrderHint
Defines the sort order for a column in a instance's destination table, according to the clustered index on the table.
SqlBulkCopyColumnOrderHintCollection
Collection of objects that inherits from .
SqlClientFactory
Represents a set of methods for creating instances of the provider's implementation of the data source classes.
SqlClientLogger
Represents a SQL client logger.
SqlColumnEncryptionCertificateStoreProvider
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.
SqlColumnEncryptionCngProvider
The CMK Store provider implementation for using the Microsoft Cryptography API: Next Generation (CNG) with Always Encrypted.
SqlColumnEncryptionCspProvider
The CMK Store provider implementation for using Microsoft CAPI based Cryptographic Service Providers (CSP) with Always Encrypted.
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 with the associated SQL Server database. This class cannot be inherited.
SqlConfigurableRetryFactory
Provides different retry logic providers with a common list of transient errors.
SqlConnection
Represents a connection to a SQL Server database. This class cannot be inherited.
SqlConnectionEncryptOption
These options are used to control encryption behavior of the communication between the server and the client.
SqlConnectionStringBuilder
Provides a simple way to create and manage the contents of connection strings used by the class.
SqlCredential
provides a more secure way to specify the password for a login attempt using SQL Server Authentication. is comprised of a user id and a password that will be used for SQL Server Authentication. The password in a object is of type . cannot be inherited. Windows Authentication (Integrated Security = true) remains the most secure way to log in to a SQL Server database.
SqlDataAdapter
Represents a set of data commands and a database connection that are used to fill the 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.
SqlDependency
The object represents a query notification dependency between an application and an instance of SQL Server. An application can create a object and register to receive notifications via the 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 event.
SqlNotificationEventArgs
Represents the set of arguments passed to the notification event handler.
SqlParameter
Represents a parameter to a and optionally its mapping to columns. This class cannot be inherited. For more information on parameters, see Configuring parameters
SqlParameterCollection
Represents a collection of parameters associated with a and their respective mappings to columns in a . This class cannot be inherited.
SqlRetryingEventArgs
Represents the set of arguments passed to the event.
SqlRetryLogicOption
Provides the retry logic parameters to create an instance of the class by using methods.
SqlRowsCopiedEventArgs
Represents the set of arguments passed to the .
SqlRowUpdatedEventArgs
Provides data for the event.
SqlRowUpdatingEventArgs
Provides data for the event.
SqlTransaction
Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited.
SspiAuthenticationParameters
Provides parameters used during SSPI authentication.
Enumerations
ApplicationIntent
Specifies a value for . Possible values are and .
PoolBlockingPeriod
Specifies a value for the property.
SortOrder
Specifies how rows of data are sorted.
SqlBulkCopyOptions
Bitwise flag that specifies one or more options to use with an instance of .
SqlCommandColumnEncryptionSetting
Note that these settings cannot be used to bypass encryption and gain access to plaintext data. For details, see Always Encrypted (Database Engine).
SqlConnectionAttestationProtocol
Specifies a value for Attestation Protocol.
SqlConnectionColumnEncryptionSetting
Note that these settings cannot be used to bypass encryption and gain access to plaintext data. For details, see Always Encrypted (Database Engine).
SqlConnectionIPAddressPreference
Specifies a value for IP address preference during a TCP connection.
SqlConnectionOverrides
Specifies a value for Overrides.
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 event handler through the parameter.
Static Classes
SqlClientMetaDataCollectionNames
Provides a list of constants for use with the method to retrieve metadata collections.
Abstract Classes
SqlAuthenticationInitializer
Called during the opening of the first instance to specify an Authentication connection string attribute.
SqlColumnEncryptionKeyStoreProvider
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 , or . For details see, Always Encrypted.
SqlRetryIntervalBaseEnumerator
Generates a sequence of time intervals.
SqlRetryLogicBase
Retrieves the next time interval with respect to the number of retries if a transient condition occurs.
SqlRetryLogicBaseProvider
Applies retry logic on an operation through the or function.
SspiContextProvider
Provides the ability to customize SSPI context generation.