Skip to main content

SelectQueryFluentBuilder Members

Provides methods that can be chained within a single statement specifying a SelectQuery.

Methods

Name Description
AddTable(String, String) static Selects a data table with the specified name and alias.
AddTable(String) static Selects a data table with the specified name.
Build(String) Ends the chain of methods specified for a SelectQueryFluentBuilder.
Distinct() Indicates that a query result set should include only distinct (different) values.
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.
Filter(String) Specifies the criteria used to filter data returned by the current query.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
GroupBy(String) Groups the data table by a specified column. These columns are obtained from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
GroupBy(String[]) Groups the data table by the specified columns. These columns are obtained from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
GroupFilter(String) Specifies the filter criteria to add to the current query containing grouped/aggregated columns.
Join(String, RelationColumnInfo[]) Performs an inner join operation with the specified options.
Join(String, SqlJoinType, RelationColumnInfo[]) Joins two tables. Allows you to specify the join operation type and columns relations by which the tables should be joined.
Join(String, SqlJoinType, String, String, ConditionType) Joins two tables. Allows you to specify the join operation type, column names by which the tables should be joined, and a relational operation that should be used to compare column values.
Join(String, SqlJoinType, String, String, String, ConditionType) Joins two tables. Allows you to specify a table alias, the join operation type, column names by which the tables should be joined, and a relational operation that should be used to compare column values.
Join(String, SqlJoinType, String, String) Joins two tables. Allows you to specify the join operation type and column names by which the tables should be joined.
Join(String, SqlJoinType, String) Joins two tables. Allows you to specify the join operation type and a column name by which the tables should be joined.
Join(String, JoinType, RelationColumnInfo[]) Obsolete. Performs a specified join operation.
Join(String, JoinType, String, String, ConditionType) Obsolete. Performs a specified join operation.
Join(String, JoinType, String, String, String, ConditionType) Obsolete. Performs a specified join operation.
Join(String, JoinType, String, String) Obsolete. Performs a specified join operation.
Join(String, JoinType, String) Obsolete. Performs a specified join operation.
Join(String, String, RelationColumnInfo[]) Performs an inner join operation with the specified options.
Join(String, String, SqlJoinType, RelationColumnInfo[]) Joins two tables. Allows you to specify a table alias, the join operation type, and columns relations by which the tables should be joined.
Join(String, String, SqlJoinType, String, String) Joins two tables. Allows you to specify a table alias, the join operation type, and column names by which the tables should be joined.
Join(String, String, SqlJoinType, String) Joins two tables. Allows you to specify a table alias, the join operation type, and a column name by which the tables should be joined.
Join(String, String, JoinType, RelationColumnInfo[]) Obsolete. Performs a specified join operation.
Join(String, String, JoinType, String, String) Obsolete. Performs a specified join operation.
Join(String, String, JoinType, String) Obsolete. Performs a specified join operation.
Join(String, String, String, String) Performs an inner join operation with the specified options.
Join(String, String, String) Performs an inner join operation with the specified options.
Join(String, String) Performs an inner join operation with the specified options.
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.
SelectAllColumns() Selects all columns in all data tables within the query.
SelectAllColumnsFromTable() Selects all columns from the associated table. These columns are obtained from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
SelectColumn(String, AggregationType, String) Selects a specified column from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
SelectColumn(String, String) Selects a specified column from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
SelectColumn(String) Selects a specified column from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
SelectColumns(String[]) Selects the specified columns from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
SelectExpression(String, AggregationType, String) Returns a column with a specified alias that includes rows selected based on a required expression.
SelectExpression(String, String) Returns a column with a specified alias that includes rows selected based on a 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.
Skip(Int32) Specifies the number of rows to skip in a returned query result set.
SortBy(String, AggregationType, ListSortDirection) Sorts the result set by a specified column in a required direction by applying an aggregate function. This column is obtained from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
SortBy(String, AggregationType) Sorts the result set by a specified column by applying an aggregate function. This column is obtained from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
SortBy(String, ListSortDirection) Sorts the result set by a specified column in a required direction. This column is obtained from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
SortBy(String) Sorts the result set by a specified column. This column is obtained from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
SortBy(String[]) Sorts the result set by specified columns. These columns are obtained from the last table added by the SelectQueryFluentBuilder.AddTable or SelectQueryFluentBuilder.Join method.
SortByExpression(String, AggregationType, ListSortDirection) Sorts the result set by a specified expression and aggregate function in a required direction.
SortByExpression(String, ListSortDirection) Sorts the result set by a specified expression in a required direction.
SortByExpression(String) Sorts the result set by a specified expression.
Top(Int32) Specifies the number of rows returned in the query result set.
ToString() Returns a string that represents the current object. Inherited from Object.
See Also