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