Skip to main content

SelectQuery Members

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

Constructors

Name Description
SelectQuery() Initializes a new instance of the SelectQuery class with the default settings.
SelectQuery(String) Initializes a new instance of the SelectQuery class with the specified name.

Properties

Name Description
Columns Provides access to all columns included in the query result set.
Distinct Specifies whether or not a query result set should include duplicate values.
FilterString Specifies the criteria used to filter data returned by the current SelectQuery.
GroupFilterString Specifies the filter criteria to add to the current SelectQuery containing grouped/aggregated columns.
Groups Provides access to all groups specified for the current query.
Name Specifies the query name. Inherited from SqlQuery.
Parameters Provides access to the collection of parameters defined for the SqlQuery. Inherited from SqlQuery.
Relations Provides access to all data relations specified for the current query.
Skip Specifies the number of rows to skip in a returned query result set.
Sorting Provides access to all sorting criteria specified for the current query.
Tables Provides access to all tables selected by the current query.
Top Specifies the number of rows returned in the query result set.

Methods

Name Description
AddRelation(Table, Table, RelationColumnInfo[]) Creates a relation between two data tables using an inner join operation.
AddRelation(Table, Table, SqlJoinType, RelationColumnInfo[]) Creates a relation between two data tables. Allows you to specify the join operation type and columns relations that should be used to join the tables.
AddRelation(Table, Table, SqlJoinType, String, String, ConditionType) Creates a relation between two data tables. Allows you to specify the join operation type, table column names that should be used in the join operation, and the relational operator type that should be used to compare column values.
AddRelation(Table, Table, SqlJoinType, String, String)
AddRelation(Table, Table, SqlJoinType, String)
AddRelation(Table, Table, JoinType, RelationColumnInfo[]) Obsolete. Creates a relation between two data tables using a specified join operation.
AddRelation(Table, Table, JoinType, String, String, ConditionType) Obsolete. Creates a relation between two data tables using a specified join operation and logical condition.
AddRelation(Table, Table, JoinType, String, String) Obsolete. Creates a relation between two data tables using a specified join operation.
AddRelation(Table, Table, JoinType, String) Obsolete. Creates a relation between two data tables using a specified join operation.
AddRelation(Table, Table, String, String, ConditionType) Creates a relation between two data tables using an inner join operation and logical condition.
AddRelation(Table, Table, String, String) Creates a relation between two data tables using an inner join operation.
AddRelation(Table, Table, String) Creates a relation between two data tables using an inner join operation.
AddTable(String, String) Selects a data table with the specified name and alias.
AddTable(String) Selects a data table with the specified name.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetSql(DBSchema) Returns the SQL string corresponding to the current SelectQuery.
GetType() Gets the Type of the current instance. Inherited from Object.
GroupBy(Table, String) Groups a data table by the specified column.
GroupBy(Table, String[]) Groups a data table by the specified columns.
GroupByExpression(String) Groups a data table by the specified expression.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
SelectAll() Selects all columns in all data tables within the query.
SelectAll(Table) Selects all columns in a specified data table.
SelectColumn(Table, String, AggregationType, String) Selects a specified column from a required data table by specifying an aggregate function and column alias.
SelectColumn(Table, String, String) Obtains a specified column from a data table.
SelectColumn(Table, String) Selects a specified column from a required data table.
SelectColumns(Table, String[]) Selects specified columns from the required data table.
SelectExpression(String, AggregationType, String) Returns a column with a specified alias that includes rows selected based on a required expression and aggregate function.
SelectExpression(String, String) Returns a column with a specified alias that includes rows selected based on the required expression.
SelectRecordsCount(String) Extends a query’s result set with a column that specifies the row count in the requested table or, if there are groups in the table, - the rows count in each group.
SortBy(Table, String, AggregationType, ListSortDirection) Sorts a data table by a specified column in a required direction by applying an aggregate function.
SortBy(Table, String, AggregationType) Sorts a data table by a specified column by applying an aggregate function.
SortBy(Table, String, ListSortDirection) Sorts a data table by a specified column in a required direction.
SortBy(Table, String) Sorts a data table by a specified column.
SortByExpression(String, AggregationType, ListSortDirection) Sorts a data table by a specified expression and aggregate function in a required direction.
SortByExpression(String, ListSortDirection) Sorts a data table by a specified expression in a required direction.
SortByExpression(String) Sorts a data table by a specified expression.
ToString() Returns the textual representation of SqlQuery. Inherited from SqlQuery.
Validate() Checks the validity of the SelectQuery.
Validate(DBSchema) Checks the validity of the SelectQuery against a specified schema.
See Also