Thenamespace is the.NET Framework Data Provider for SQL Server.
Lets you efficiently bulk load a SQL Server table with data from another source.
Defines the mapping between a column in a SqlBulkCopy instance's data source and a column in the instance's destination table.
Represents a set of methods for creating instances of theprovider's implementation of the data source classes.
Provides a list of constants for use with the GetSchema method to retrieve metadata collections.
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.
Associates a security action with a custom security attribute.
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.
The CMK Store provider implementation for Microsoft Cryptography API: Next Generation (CNG).
The CMK Store provider implementation for Microsoft CAPI based Cryptographic Service Providers (CSP).
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().
Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.
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.
Represents an open connection to a SQL Server database. This class cannot be inherited.
Provides a simple way to create and manage the contents of connection strings used by the SqlConnection class.
SqlCredential provides a more secure way to specify the password for a login attempt using SQL Server Authentication.
SqlCredential cannot be inherited.
Windows Authentication (Integrated Security = true) remains the most secure way to log in to a SQL Server database.
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.
Provides a way of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.
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.
Collects information relevant to a warning or error returned by SQL Server.
Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited.
The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited.
Provides data for the InfoMessage event.
Represents the set of arguments passed to the notification event handler.
The DbProviderServices implementation for the SqlClient provider for SQL Server.
Represents the set of arguments passed to the SqlRowsCopiedEventHandler.
Provides data for the RowUpdated event.
Provides data for the RowUpdating event.
Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited.
Specifies a value for ApplicationIntent. Possible values are ReadWrite and ReadOnly.
Specifies how rows of data are sorted.
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.
Bitwise flag that specifies one or more options to use with an instance of SqlBulkCopy.
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.
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.
This enumeration provides additional information about the different notifications that can be received by the dependency event handler.
Indicates the source of the notification received by the dependency event handler.
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.
For conceptual information about using this namespace when programming with the .NET Framework, see SQL Server and ADO.NET.