QuerySpecExtensionMethods Class |
Extension ethods defined on QuerySpec and derived classes.
Inheritance HierarchyNamespace: SD.LLBLGen.Pro.QuerySpec
Assembly: SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.8.0.0 (5.8.21.0111)
SyntaxThe QuerySpecExtensionMethods type exposes the following members.
Methods| Name | Description | |
|---|---|---|
  | AndWhereTQuery |
Specifies the where clause of the query by appending it with And to the existing (if any) predicates
|
| As(DynamicQuery, String) |
Specifies the alias of the query
|
| AsT(DynamicQueryT, String) |
Specifies the alias of the query
|
| AsTEntity(EntityQueryTEntity, String) |
Specifies the alias of the query as a whole. To set the alias of the target of the query, use TargetAs(alias).
|
| CacheResultsetTQuery(TQuery, Int32) |
Specifies that the query's resultset should be cached for the duration specified.
|
| CacheResultsetTQuery(TQuery, TimeSpan) |
Specifies that the query's resultset should be cached for the duration specified.
|
| CacheResultsetTQuery(TQuery, Int32, Boolean) |
Specifies that the query's resultset should be cached for the duration specified.
|
| CacheResultsetTQuery(TQuery, Int32, String) |
Specifies that the query's resultset should be cached for the duration specified.
|
| CacheResultsetTQuery(TQuery, TimeSpan, Boolean) |
Specifies that the query's resultset should be cached for the duration specified.
|
| CacheResultsetTQuery(TQuery, TimeSpan, String) |
Specifies that the query's resultset should be cached for the duration specified.
|
| CacheResultsetTQuery(TQuery, Int32, Boolean, String) |
Specifies that the query's resultset should be cached for the duration specified.
|
| CacheResultsetTQuery(TQuery, TimeSpan, Boolean, String) |
Specifies that the query's resultset should be cached for the duration specified.
|
| CorrelatedOverTQuery |
Specifies the correlation filter between this query and a parent query. Use this method to bind two queries together in a correlated fashion, e.g.
in nested queries or in correlated subqueries.
|
| Distinct(DynamicQuery) |
Sets the AllowDuplicates flag to false, so the query won't return duplicate rows.
|
| DistinctT(DynamicQueryT) |
Sets the AllowDuplicates flag to false, so the query won't return duplicate rows.
|
| DistinctT(EntityQueryT) |
Sets the AllowDuplicates flag to false, so the query won't return duplicate rows.
|
| Except(DynamicQuery, DynamicQuery) |
Specifies the where clause of the query by appending a predicate which is true for each element in query which is also in toExclude.
|
| ExceptT(DynamicQueryT, DynamicQuery) |
Specifies the where clause of the query by appending a predicate which is true for each element in query which is also in toExclude.
|
| ExceptTEntity(EntityQueryTEntity, EntityQueryTEntity) |
Specifies the where clause of the query by appending a predicate which is true for each entity in query which isn't in toExclude.
|
| ExceptTEntity(EntityQueryTEntity, IEnumerableTEntity) |
Specifies the where clause of the query by appending a predicate which is true for each entity in query which isn't in the list 'entities'
|
| ExcludeTEntity |
Specifies the fields to exclude from the query, fetching all other fields not mentioned in the list of fields to exclude.
|
| FromTQuery(TQuery, IRelationCollection) |
Specifies the From clause of the query
|
| FromTQuery(TQuery, IJoinOperand) |
Specifies the From clause of the query
|
| GroupByTDynamicQuery |
Specifies the group by clause. All fields specified are the ones to group on.
|
| HavingTDynamicQuery |
Specifies the having clause for the group by clause of this query. Ignored if the query has no group by specified at time of execution
|
| IncludeTEntity |
Specifies tht fields to include in the query, excluding all other fields not necessary for the fetch.
|
| Intersect(DynamicQuery, DynamicQuery) |
Specifies the where clause of the query by appending a predicate which is true for each element in query which is also in toInclude.
|
| IntersectT(DynamicQueryT, DynamicQuery) |
Specifies the where clause of the query by appending a predicate which is true for each element in query which is also in toInclude.
|
| IntersectTEntity(EntityQueryTEntity, EntityQueryTEntity) |
Specifies the where clause of the query by appending a predicate which is true for each entity in query which is also in toInclude.
|
| IntersectTEntity(EntityQueryTEntity, IEnumerableTEntity) |
Specifies the where clause of the query by appending a predicate which is true for each entity in query which is also in the list 'entities'
|
| LimitTQuery |
Sets the limit of the query, the number of elements to retrieve. 0 means all elements (no limit). A number greater than 0 means
the limit specifies the number of elements to retrieve.
|
| MarkWithTagTQuery |
Specifies the tag to append as comment into the SQL query / queries generated from the query specified. Use the tag to
trace back the origin of a SQL query in the RDBMS.
|
| OffsetTQuery |
Sets the offset of the query, the number of elements to skip before read will start. 0 means no offset.
|
| OrderByTQuery(TQuery, ISortClause) |
Specifies the orderby of the query. All sort clauses are appended to the sort expression already present.
|
| OrderByTQuery(TQuery, ISortExpression) |
Specifies the orderby of the query. All sort clauses are appended to the sort expression already present.
|
| OrWhereTQuery |
Specifies the where clause of the query by appending it with Or to the existing (if any) predicates
|
| PageTQuery |
Sets the paging data: the page size and the page number to retrieve, where 0 for one of them means no paging. Valid page sizes and page numbers
are 1 or greater.
|
| Select(DynamicQuery, Object) |
Specifies the projection of the query. It clears any existing projection and sets the projection to the one specified.
|
| SelectT(DynamicQuery, ExpressionFuncT) |
Specifies the projection of the query specified. It clears any existing projection and sets the projection to the one specified. This variant converts the
specified projectionFunc into the projector lambda to pass to WithProjector and extracts the elements to place in the SQL query's projection from
the projectionFunc. Use this overload to specify a typed resultset.
|
| SelectT(DynamicQuery, Object) |
Specifies the projection of the query and the result type. It clears any existing projection and sets the projection to the one specified. It will also
mark the query to autogenerate a projector lambda to project the specified projection elements to an instance of T for each row.
|
| SelectT(DynamicQueryT, Object) | Obsolete.
Obsolete, don't use.
Specifies the projection of the query. It clears any existing projection and sets the projection to the one specified.
|
| SelectT, U(DynamicQuery) |
Specifies the projection of the query specified, making it a typed dynamic query. It creates the projection from the two type arguments given.
|
| SelectFrom(DynamicQuery, DynamicQuery) |
Specifies a projection on 'query' which is mimics the projection of the query 'toWrap': it contains fields which target each field in 'toWrap's projection.
It wraps 'toWrap' as the From clause for 'query', overwriting query's From clause, if set.
|
| SelectFromT(DynamicQuery, DynamicQueryT) |
Specifies a projection on 'query' which is mimics the projection of the query 'toWrap': it contains fields which target each field in 'toWrap's projection.
It wraps 'toWrap' as the From clause for 'query', overwriting query's From clause, if set.
|
| ToResultsetT(DynamicQueryT) |
Placeholder method which is used in a Select(lambda func) projection inside the lambda to specify the type of the resultset of the passed in query.
|
| ToResultsetT(EntityQueryT) |
Placeholder method which is used in a Select(lambda func) projection inside the lambda to specify the type of the resultset of the passed in query.
|
| ToSingleResultT(DynamicQueryT) |
Placeholder method which is used in a Select(lambda func) projection inside the lambda to specify the type of the single result of the passed in query.
|
| ToSingleResultT(EntityQueryT) |
Placeholder method which is used in a Select(lambda func) projection inside the lambda to specify the type of the single result of the passed in query.
|
| Union(DynamicQuery, DynamicQuery) |
Specifies the query toUnion which should be union-ed with query using the UNION operator
|
| UnionT(DynamicQueryT, DynamicQuery) |
Specifies the query toUnion which should be union-ed with query using the UNION operator
|
| UnionTEntity(EntityQueryTEntity, EntityQueryTEntity) |
Specifies the query toUnion which should be union-ed with query using the UNION operator
|
| UnionAll(DynamicQuery, DynamicQuery) |
Specifies the query toUnion which should be union-ed with query using the UNION ALL operator
|
| UnionAllT(DynamicQueryT, DynamicQuery) |
Specifies the query toUnion which should be union-ed with query using the UNION ALL operator
|
| UnionAllTEntity(EntityQueryTEntity, EntityQueryTEntity) |
Specifies the query toUnion which should be union-ed with query using the UNION ALL operator
|
| WhereTQuery |
Specifies the where clause of the query by appending it with And to the existing (if any) predicates
|
| WhereExistsTQuery |
Specifies the where clause of the query by appending an EXISTS predicate based on the existsQuery predicate specified.
|
| WhereNotExistsTQuery |
Specifies the where clause of the query by appending a NOT EXISTS predicate based on the existsQuery predicate specified.
|
See Also