A newer version of this page is available. Switch to the current version.

DevExpress.DataAccess.Sql Namespace

Contains classes that support binding to SQL data sources.

Assembly: DevExpress.DataAccess.v18.2.dll

Classes

Name Description
AggregateQueryInvalidSortingValidationException An exception thrown when trying to execute an aggregate query with an invalid sorting criteria applied to it.
AggregationWithoutAliasValidationException An exception thrown when an aggregation has been used without specifying its alias.
AliasedBase The base for classes that provide the data column functionality.
AllColumns Corresponds to all columns from one or more data tables selected by a SelectQuery.
CircularRelationsValidationException An exception thrown when circular relations have been specified in a query.
Column A column of a data table retrieved by a SelectQuery.
ColumnBase The base for classes that provide the data column functionality.
ColumnBase.EqualityComparer
ColumnExpression A selected data column with or without an aggregate expression applied to it.
ColumnInfo Obsolete. Obsolete. Use the corresponding functionality of the SelectQuery class instead.
ColumnInfo.EqualityComparer
ColumnNotInSchemaValidationException An exception thrown when a query contains columns that are missing in the data source schema.
ColumnNullValidationException An exception thrown when a query references a column that is null.
ConfigureDataConnectionEventArgs Provides data for the ConfigureDataConnection events.
ConnectionErrorEventArgs Serves as the base for classes that provide data for the ConnectionError events.
ConnectionOptions Specifies the data connection options of a SqlDataSource.
CustomExpression A custom aggregate expression that can be applied to a data column or group/sorting criteria.
CustomExpressionWithAmbiguousColumnValidationException An exception thrown when a custom expression references a column with an ambiguous name.
CustomExpressionWithColumnOfMissingTableValidationException An exception thrown when a custom expression references a column contained in a table that has not been selected.
CustomExpressionWithMissingInSchemaColumnValidationException An exception thrown when a custom expression references a column that is missing in the data source schema.
CustomizeFilterExpressionEventArgs Provides data for the SqlDataSource.CustomizeFilterExpression event.
CustomSqlQuery A custom query.
CustomSqlQueryValidationException An exception thrown when a custom query validation fails.
DatabaseConnectionException The exception occurring after a data source connection has failed.
DBSchema An object schema that is used to manage database objects (e.g., DBTable objects or their descendants).
DBSchemaProviderEx Provides a default implementation of the IDBSchemaProviderEx interface exposing virtual methods, which you can override in derived classes.
DuplicatingColumnNamesValidationException An exception thrown when trying to select a column that has already been selected.
DuplicatingTableNamesValidationException An exception thrown when trying to select a table that has already been selected.
ExpressionBase The base for classes that provide expression functionality to SelectQuery.
ExpressionBase.EqualityComparer
ExpressionNullValidationException An exception thrown when a query contains an expression that does not reference either a column or custom expression.
ExpressionStringNullValidationException An exception thrown when an expression string is null.
FilterByAmbiguousColumnValidationException An exception thrown when a query contains a filter criteria that references a column with an ambiguous name.
FilterByColumnOfMissingTableValidationException An exception thrown when a query has a filter criteria that is not contained in any of the selected tables.
FilterByMissingInSchemaColumnValidationException An exception thrown when a query has a filter criteria that is missing in the data source schema.
Group Specifies the grouping options of a SelectQuery.
Group.EqualityComparer
GroupByAggregateColumnValidationException An exception thrown when a query has a grouping criteria that is an aggregate column.
GroupByWithoutAggregateValidationException An exception thrown when a query has a grouping criteria and some of the selected columns have not been assigned an aggregate expression.
GroupingInfo Obsolete. Obsolete. Use the corresponding functionality of the SelectQuery class instead.
GroupingInfo.EqualityComparer
GroupingInfoList Obsolete. Obsolete. Use the corresponding functionality of the SelectQuery class instead.
GroupingInfoList.EqualityComparer
GroupNullValidationException An exception thrown when a query has a grouping criteria that is null.
HavingWithoutGroupByValidationException An exception thrown when a query contains group filtering criteria and the data is not actually grouped.
IncompleteRelationValidationException An exception thrown when a query contains a relation for which not all required information has been provided.
InvalidExpressionStringValidationException An exception thrown when a query contains an invalid expression.
Join A relation between two data tables created using a join operation in a SelectQuery.
Join.EqualityComparer
MasterDetailInfo Identifies the master-detail relationship defined by associated SQL queries.
MasterDetailInfo.EqualityComparer
MasterDetailInfoCollection A collection of MasterDetailInfo objects.
NegativeTopSkipValidationException An exception thrown when a negative SelectQuery.Top or SelectQuery.Skip value has been specified.
NoColumnsValidationException An exception thrown when no columns have been selected for any of the selected tables.
NoRelationColumnsValidationException An exception thrown when a query contains a relation for which no key columns have been specified.
NoTablesValidationException An exception thrown when no tables have been selected by a query.
PartialAggregationValidationException An exception thrown when a grouping and/or aggregate expression has not been applied to each of the selected columns.
QueryExecutionException An exception thrown when a query execution has failed.
QueryParameter A parameter passed to a SqlQuery.
QueryParameter.EqualityComparer
RecordsCount The total number of records in selected data tables or in each group.
RelationColumnInfo Stores the master and nested keys of a data relation column.
RelationColumnInfo.EqualityComparer
RelationColumnNotInSchemaValidationException An exception thrown when a key column of a data relation is missing in the data source schema.
RelationColumnNullValidationException An exception thrown when the key column of a data relation is null.
RelationException An exception thrown when attempting to assign a data relation to unrelated columns.
RelationInfo Obsolete. Obsolete. Use the corresponding functionality of the SelectQuery class instead.
RelationInfo.EqualityComparer
RelationInfo.RelationColumnInfoList
RelationInfoList Obsolete. Obsolete. Use the corresponding functionality of the SelectQuery class instead.
RelationNullValidationException An exception thrown when a data relation is null.
RelationTableNotSelectedValidationException An exception thrown when a data relation references a table that has not been selected.
ResultSchemaProvider The default implementation of the IResultSchemaProvider interface.
SelectQuery A set of columns (from a single table or multiple joined tables) that forms a SELECT statement when executing a query.
SelectQueryFluentBuilder Provides methods that can be chained within a single statement specifying a SelectQuery.
SkipWithoutSortingValidationException An exception thrown when specifying the SelectQuery.Skip property without sorting the corresponding table.
SortByAggregateColumnValidationException An exception thrown when a query contains a sorting criterion that is an aggregate column.
Sorting Specifies the sorting options of a SelectQuery.
Sorting.EqualityComparer
SortingBySameColumnTwiceValidationException An exception thrown when the same sorting criterion has been applied multiple times.
SortingInfo Obsolete. Obsolete. Use the corresponding functionality of the SelectQuery class instead.
SortingInfo.EqualityComparer
SortingInfoList Obsolete. Obsolete. Use the corresponding functionality of the SelectQuery class instead.
SortingInfoList.EqualityComparer
SortingNullValidationException An exception thrown when a query contains a sorting criterion that is null.
SqlDataConnection A connection to a SqlDataSource.
SqlDataSource The data source that allows you to bind Windows Forms data-aware controls to a database (in read-only mode) using specified data connection options.
SqlQuery A formalized description of a database query used to select data from SqlDataSource.
SqlQuery.EqualityComparer
SqlQueryCollection A collection of SqlQuery objects in the SqlDataSource.
SqlStringEmptyValidationException An exception thrown when an SQL string is null or empty.
StoredProcNameNullValidationException An exception thrown when a stored procedure name has not been specified.
StoredProcNotInSchemaValidationException An exception thrown when a referenced stored procedure is missing in the data source schema.
StoredProcParamCountValidationException An exception thrown when there is a mismatch between the specified and expected number of parameters specified for a stored procedure.
StoredProcParamNameValidationException An exception thrown when there is a mismatch between the specified and expected stored procedure parameter names.
StoredProcParamNullValidationException An exception thrown when a stored procedure parameter is null.
StoredProcParamTypeValidationException An exception thrown when there is a mismatch between the specified and expected stored procedure parameter types.
StoredProcQuery A stored procedure call.
Table A data table retrieved by an associated SelectQuery.
Table.EqualityComparer
TableInfo Obsolete. Obsolete. Use the corresponding functionality of the SelectQuery class instead.
TableInfo.ColumnInfoList
TableInfo.EqualityComparer
TableInfoList Obsolete. Obsolete. Use the corresponding functionality of the SelectQuery class instead.
TableNotInSchemaValidationException An exception thrown when a query references a table that is missing in the data source schema.
TableNotSelectedValidationException An exception thrown when a query references a column that is not contained in any of the selected tables.
TableNullValidationException An exception thrown when a query references a table that is null.
TableQuery Obsolete. Obsolete. Use the SelectQuery class instead.
TablesNotRelatedValidationException An exception thrown when a query references multiple tables without specifying their relations.
UnnamedColumnValidationException An exception thrown when a query references a column without specifying its name.
UnnamedTableValidationException An exception thrown when a query references a table without specifying its name.
ValidationException The exception occurring after a query validation has failed.

Interfaces

Name Description
IDBSchemaProvider For internal use. Use the IDBSchemaProviderEx interface instead.
IDBSchemaProviderEx Provides the capability to customize the database schema.
IResultSchemaProvider If implemented, enables you to obtain and customize a data source schema.

Delegates

Name Description
ConfigureDataConnectionEventHandler References a method that will handle the ConfigureDataConnection events.
ConnectionErrorEventHandler References a method that will handle ConnectionError events.
CustomizeFilterExpressionEventHandler References a method that will handle the SqlDataSource.CustomizeFilterExpression event.

Enums

Name Description
AggregationType Lists values that specify aggregation types.
ConditionType Lists the values that specify the relational operator type.
SchemaLoadingMode Lists the values specifying whether the data source schema should include stored procedures, tables (views), or both.
SortingInfo.SortingDirection