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.
|
Equals(Object)
|
Determines whether the specified object is equal to the current object.
|
GetHashCode()
|
Serves as the default hash function.
|
GetSql(DBSchema)
|
Returns the SQL string corresponding to the current SelectQuery.
|
GetType()
|
Gets the Type of the current instance.
|
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.
|
ReferenceEquals(Object, Object)
static
|
Determines whether the specified Object instances are the same instance.
|
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.
|
Validate()
|
Checks the validity of the SelectQuery.
|
Validate(DBSchema)
|
Checks the validity of the SelectQuery against a specified schema.
|