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.

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.
IsolationLevel	Specifies the isolation level for SqlQuery. Inherited from SqlQuery.
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.

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.

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

SelectQuery Members

Constructors

Properties

Methods