SelectQuery Methods

A set of columns (from a single table or multiple joined tables) that forms a SELECT statement when executing a query.
Name Description
AddRelation(Table, Table, RelationColumnInfo[]) Creates a relation between two data tables using an inner join operation.
AddRelation(Table, Table, JoinType, RelationColumnInfo[]) Creates a relation between two data tables using a specified join operation.
AddRelation(Table, Table, JoinType, String) Creates a relation between two data tables using a specified join operation.
AddRelation(Table, Table, JoinType, String, String) Creates a relation between two data tables using a specified join operation.
AddRelation(Table, Table, JoinType, String, String, ConditionType) Creates a relation between two data tables using a specified join operation and logical condition.
AddRelation(Table, Table, String) Creates a relation between two data tables using an inner join operation.
AddRelation(Table, Table, String, String) Creates a relation between two data tables using an inner join operation.
AddRelation(Table, Table, String, String, ConditionType) Creates a relation between two data tables using an inner join operation and logical condition.
AddTable(String) Selects a data table with the specified name.
AddTable(String, String) Selects a data table with the specified name and alias.
Equals(Object) Determines whether the specified object is equal to the current object.
(Inherited from Object)
Equals(Object, Object) static Determines whether the specified object instances are considered equal.
(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) Selects a specified column from a required 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.
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) Sorts a data table by a specified column.
SortBy(Table, String, AggregationType) Sorts a data table by a specified column by applying an aggregate function.
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, ListSortDirection) Sorts a data table by a specified column in a required direction.
SortByExpression(String) Sorts a data table by a specified expression.
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.
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