| Class | Description | |
|---|---|---|
 | InvalidPageStatementException | Occurs when SQL Server returns the error 16938. |
| SelectStatementClause | Represents a SELECT statement clause. |
| SelectStatementToken | Represents a SELECT statement token. |
| SqlCommand | Represents a SQL statement or stored procedure to execute against SQL Server. |
| SqlCommandBuilder | Automatically generates single-table commands used to reconcile changes made to a System.Data.DataSet with the SQL Server. |
| SqlConnection | Represents an open connection to SQL Server. |
| SqlConnectionStringBuilder | Generates automatically connection strings used to connect to SQL Server. |
| SqlDataAdapter | Represents a set of data commands and a data source connection that are used to fill the System.Data.DataSet and update a SQL Server data. |
| SqlDataReader | Reads a forward-only stream of rows from SQL Server. |
| SqlDataSet | Represents an in-memory cache of data with support for SQL Server-specific features. |
| SqlDataSourceEnumerator | Enumerates all available instances of SQL Server within the local network. |
| SqlDataTable | Represents a single object that provides all of the functionality needed to retrieve and manipulate data from a SQL Server data source. |
| SqlError | Collects information relevant to a warning or error returned by SQL Server. |
| SqlErrorCollection | Collects all errors generated by SQL Server. |
| SqlException | The exception that is thrown when SQL Server returns a warning or error. |
| SqlInfoMessageEventArgs | Provides data for the SqlConnection.InfoMessage event. |
| SqlLoader | Serves to load external data into SQL Server. |
| SqlLoaderColumn | Represents the attributes for column loading. |
| SqlLoaderColumnCollection | Represents a collection of columns relevant to a SqlLoader. |
| SqlMonitor | Monitors dynamic SQL execution in applications that use dotConnect for SQL Server. |
| SqlParameter | Represents a parameter to a SqlCommand, and optionally, its mapping to System.Data.DataSet columns. |
| SqlParameterCollection | Collects all parameters relevant to a SqlCommand as well as their respective mappings to System.Data.DataSet columns. |
| SqlRowUpdatedEventArgs | Provides data for the SqlDataAdapter.RowUpdated event. |
| SqlRowUpdatingEventArgs | Provides data for the SqlDataAdapter.RowUpdating event. This class cannot be inherited. |
| SqlScript | Serves to execute series of SQL statements separated by special symbols. |
| SqlSelectComputeBy | Represents a COMPUTE BY clause of a SELECT statement. |
| SqlSelectFor | Represents a SELECT FOR clause of a SELECT statement. |
| SqlSelectGroupByInfo | Represents a GROUP BY clause parameters of a SELECT statement. |
| SqlSelectStatement | Represents a SELECT statement. |
| SqlSelectTop | Represents a TOP clause of a SELECT statement. |
| SqlServerMetaDataCollectionNames | Enumerates collection names you can use for metadata retrieval purposes. |
| SqlServerProviderFactory | Represents a factory required to create inheritors of generic base classes to use with dotConnect for SQL Server. |
| SqlStatementExecuteEventArgs | Provides data for the SqlScript.SqlStatementExecute event of the SqlScript class. |
| SqlTransaction | Represents a SQL transaction to be made in the SQL Server database. |
Devart.Data.SqlServer Namespace
In This Topic
Classes
Delegates
| Delegate | Description | |
|---|---|---|
 | SqlInfoMessageEventHandler | Represents the method that will handle the SqlConnection.InfoMessage event of SqlConnection. |
| SqlRowUpdatedEventHandler | Represents the method that will handle the SqlDataAdapter.RowUpdated event of an SqlDataAdapter. |
| SqlRowUpdatingEventHandler | Represents the method that will handle the SqlDataAdapter.RowUpdating event of an SqlDataAdapter. |
| SqlStatementExecuteEventHandler | Represents the method that will handle the SqlScript.SqlStatementExecute event of an SqlScript. |
Enumerations
| Enumeration | Description | |
|---|---|---|
 | SqlApplicationIntent | Allows declaring the application workload type when connecting to a database. |
| SqlAuthenticationMethod | Determines the authentication method to use when connecting to SQL Azure. |
| SqlConnectionColumnEncryptionSetting | Determines whether the Always Encrypted feature is enabled for a connection. |
| SqlSelectForType | Represents type of a SELECT FOR clause. |
| SqlType | Specifies the data type of a field or a SqlParameter. |
See Also