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, String, ConditionType) | Creates a relation between two data tables using a specified join operation and logical condition. |
| AddRelation(Table, Table, JoinType, String, String) | 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, 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