Back to Devexpress

SelectQuery Properties

corelibraries-devexpress-dot-dataaccess-dot-sql-dot-selectquery-dot-underscore-properties.md

latest2.7 KB
Original Source

SelectQuery Properties

A set of columns (from a single table or multiple joined tables) that forms a SELECT statement when executing a query.

NameDescription
ColumnsProvides access to all columns included in the query result set.
DistinctSpecifies whether or not a query result set should include duplicate values.
FilterStringSpecifies the criteria used to filter data returned by the current SelectQuery.
GroupFilterStringSpecifies the filter criteria to add to the current SelectQuery containing grouped/aggregated columns.
GroupsProvides access to all groups specified for the current query.
IsolationLevelSpecifies the isolation level for SqlQuery. Inherited from SqlQuery.
NameSpecifies the query name. Inherited from SqlQuery.
ParametersProvides access to the collection of parameters defined for the SqlQuery. Inherited from SqlQuery.
RelationsProvides access to all data relations specified for the current query.
SkipSpecifies the number of rows to skip in a returned query result set.
SortingProvides access to all sorting criteria specified for the current query.
TablesProvides access to all tables selected by the current query.
TopSpecifies the number of rows returned in the query result set.

See Also

SelectQuery Class

SelectQuery Members

DevExpress.DataAccess.Sql Namespace