Dela via


Microsoft.Data.SqlClient Namespace

Classes

ActiveDirectoryAuthenticationProvider

This class implements SqlAuthenticationProvider and is used for active directory federated authentication mechanisms.

SqlAuthenticationInitializer

Called from constructors in derived classes to initialize the SqlAuthenticationInitializer class.

SqlAuthenticationParameters

Represents AD authentication parameters passed by a driver to authentication providers.

SqlAuthenticationProvider

Defines the core behavior of authentication providers and provides a base class for derived classes.

SqlAuthenticationToken

Represents an AD authentication token.

SqlBatch
SqlBatchCommand

SqlBatchCommand allows for the execution of multiple SQL commands in a SqlBatch.

SqlBatchCommandCollection

A collection of instances of SqlBatchCommand, contained within a SqlBatch.

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.

SqlBulkCopyColumnOrderHint

Defines the sort order for a column in a SqlBulkCopy instance's destination table, according to the clustered index on the table.

SqlBulkCopyColumnOrderHintCollection

Collection of SqlBulkCopyColumnOrderHint objects that inherits from CollectionBase.

SqlClientFactory

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

SqlClientLogger

Represents a SQL client logger.

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.

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.

SqlColumnEncryptionEnclaveProvider
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 RegisterColumnEncryptionKeyStoreProviders(IDictionary<String,SqlColumnEncryptionKeyStoreProvider>), RegisterColumnEncryptionKeyStoreProvidersOnConnection(IDictionary<String,SqlColumnEncryptionKeyStoreProvider>) or RegisterColumnEncryptionKeyStoreProvidersOnCommand(IDictionary<String,SqlColumnEncryptionKeyStoreProvider>). For details see, 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 DataSet 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 SqlConnection 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.

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. An application can create a SqlDependency object and register to receive notifications via the OnChangeEventHandler event handler.

SqlEnclaveAttestationParameters
SqlEnclaveSession
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. For more information on parameters, see Configuring parameters.

SqlParameterCollection

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

SqlRetryingEventArgs

Represents the set of arguments passed to the Retrying event.

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 Execute or ExecuteAsync function.

SqlRetryLogicOption

Provides the retry logic parameters to create an instance of the SqlRetryLogicBaseProvider class by using SqlConfigurableRetryFactory methods.

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.

Enums

ApplicationIntent

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

PoolBlockingPeriod

Specifies a value for the PoolBlockingPeriod property.

SortOrder

Specifies how rows of data are sorted.

SqlAuthenticationMethod

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.

SqlBulkCopyOptions

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

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 OnChangeEventHandler event handler through the SqlNotificationEventArgs parameter.

Delegates

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