SelectQueryFluentBuilder Members
Provides methods that can be chained within a single statement specifying a SelectQuery.
#Methods
Name | Description |
---|---|
Add |
Selects a data table with the specified name and alias. |
Add |
Selects a data table with the specified name. |
Build |
Ends the chain of methods specified for a Select |
Distinct() | Indicates that a query result set should include only distinct (different) values. |
Equals |
Determines whether the specified object instances are considered equal. Inherited from Object. |
Equals |
Determines whether the specified object is equal to the current object. Inherited from Object. |
Filter |
Specifies the criteria used to filter data returned by the current query. |
Get |
Serves as the default hash function. Inherited from Object. |
Get |
Gets the Type of the current instance. Inherited from Object. |
Group |
Groups the data table by a specified column. These columns are obtained from the last table added by the Select |
Group |
Groups the data table by the specified columns. These columns are obtained from the last table added by the Select |
Group |
Specifies the filter criteria to add to the current query containing grouped/aggregated columns. |
Join |
Performs an inner join operation with the specified options. |
Join |
Joins two tables. Allows you to specify the join operation type and columns relations by which the tables should be joined. |
Join |
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 |
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 |
Joins two tables. Allows you to specify the join operation type and column names by which the tables should be joined. |
Join |
Joins two tables. Allows you to specify the join operation type and a column name by which the tables should be joined. |
Join |
Obsolete. Performs a specified join operation. |
Join |
Obsolete. Performs a specified join operation. |
Join |
Obsolete. Performs a specified join operation. |
Join |
Obsolete. Performs a specified join operation. |
Join |
Obsolete. Performs a specified join operation. |
Join |
Performs an inner join operation with the specified options. |
Join |
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 |
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 |
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 |
Obsolete. Performs a specified join operation. |
Join |
Obsolete. Performs a specified join operation. |
Join |
Obsolete. Performs a specified join operation. |
Join |
Performs an inner join operation with the specified options. |
Join |
Performs an inner join operation with the specified options. |
Join |
Performs an inner join operation with the specified options. |
Memberwise |
Creates a shallow copy of the current Object. Inherited from Object. |
Reference |
Determines whether the specified Object instances are the same instance. Inherited from Object. |
Select |
Selects all columns in all data tables within the query. |
Select |
Selects all columns from the associated table. These columns are obtained from the last table added by the Select |
Select |
Selects a specified column from the last table added by the Select |
Select |
Selects a specified column from the last table added by the Select |
Select |
Selects a specified column from the last table added by the Select |
Select |
Selects the specified columns from the last table added by the Select |
Select |
Returns a column with a specified alias that includes rows selected based on a required expression. |
Select |
Returns a column with a specified alias that includes rows selected based on a required expression. |
Select |
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 |
Specifies the number of rows to skip in a returned query result set. |
Sort |
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 Select |
Sort |
Sorts the result set by a specified column by applying an aggregate function. This column is obtained from the last table added by the Select |
Sort |
Sorts the result set by a specified column in a required direction. This column is obtained from the last table added by the Select |
Sort |
Sorts the result set by a specified column. This column is obtained from the last table added by the Select |
Sort |
Sorts the result set by specified columns. These columns are obtained from the last table added by the Select |
Sort |
Sorts the result set by a specified expression and aggregate function in a required direction. |
Sort |
Sorts the result set by a specified expression in a required direction. |
Sort |
Sorts the result set by a specified expression. |
Top |
Specifies the number of rows returned in the query result set. |
To |
Returns a string that represents the current object. Inherited from Object. |
See Also