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, 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.