Click or drag to resize

QuerySpecExtensionMethods Class

Extension ethods defined on QuerySpec and derived classes.
Inheritance Hierarchy
SystemObject
  SD.LLBLGen.Pro.QuerySpecQuerySpecExtensionMethods

Namespace:  SD.LLBLGen.Pro.QuerySpec
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.8.0.0 (5.8.21.0111)
Syntax
public static class QuerySpecExtensionMethods

The QuerySpecExtensionMethods type exposes the following members.

Methods
  NameDescription
Public methodStatic memberAndWhereTQuery
Specifies the where clause of the query by appending it with And to the existing (if any) predicates
Public methodStatic memberAs(DynamicQuery, String)
Specifies the alias of the query
Public methodStatic memberAsT(DynamicQueryT, String)
Specifies the alias of the query
Public methodStatic memberAsTEntity(EntityQueryTEntity, String)
Specifies the alias of the query as a whole. To set the alias of the target of the query, use TargetAs(alias).
Public methodStatic memberCacheResultsetTQuery(TQuery, Int32)
Specifies that the query's resultset should be cached for the duration specified.
Public methodStatic memberCacheResultsetTQuery(TQuery, TimeSpan)
Specifies that the query's resultset should be cached for the duration specified.
Public methodStatic memberCacheResultsetTQuery(TQuery, Int32, Boolean)
Specifies that the query's resultset should be cached for the duration specified.
Public methodStatic memberCacheResultsetTQuery(TQuery, Int32, String)
Specifies that the query's resultset should be cached for the duration specified.
Public methodStatic memberCacheResultsetTQuery(TQuery, TimeSpan, Boolean)
Specifies that the query's resultset should be cached for the duration specified.
Public methodStatic memberCacheResultsetTQuery(TQuery, TimeSpan, String)
Specifies that the query's resultset should be cached for the duration specified.
Public methodStatic memberCacheResultsetTQuery(TQuery, Int32, Boolean, String)
Specifies that the query's resultset should be cached for the duration specified.
Public methodStatic memberCacheResultsetTQuery(TQuery, TimeSpan, Boolean, String)
Specifies that the query's resultset should be cached for the duration specified.
Public methodStatic memberCorrelatedOverTQuery
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.
Public methodStatic memberDistinct(DynamicQuery)
Sets the AllowDuplicates flag to false, so the query won't return duplicate rows.
Public methodStatic memberDistinctT(DynamicQueryT)
Sets the AllowDuplicates flag to false, so the query won't return duplicate rows.
Public methodStatic memberDistinctT(EntityQueryT)
Sets the AllowDuplicates flag to false, so the query won't return duplicate rows.
Public methodStatic memberExcept(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.
Public methodStatic memberExceptT(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.
Public methodStatic memberExceptTEntity(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.
Public methodStatic memberExceptTEntity(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'
Public methodStatic memberExcludeTEntity
Specifies the fields to exclude from the query, fetching all other fields not mentioned in the list of fields to exclude.
Public methodStatic memberFromTQuery(TQuery, IRelationCollection)
Specifies the From clause of the query
Public methodStatic memberFromTQuery(TQuery, IJoinOperand)
Specifies the From clause of the query
Public methodStatic memberGroupByTDynamicQuery
Specifies the group by clause. All fields specified are the ones to group on.
Public methodStatic memberHavingTDynamicQuery
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
Public methodStatic memberIncludeTEntity
Specifies tht fields to include in the query, excluding all other fields not necessary for the fetch.
Public methodStatic memberIntersect(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.
Public methodStatic memberIntersectT(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.
Public methodStatic memberIntersectTEntity(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.
Public methodStatic memberIntersectTEntity(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'
Public methodStatic memberLimitTQuery
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.
Public methodStatic memberMarkWithTagTQuery
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.
Public methodStatic memberOffsetTQuery
Sets the offset of the query, the number of elements to skip before read will start. 0 means no offset.
Public methodStatic memberOrderByTQuery(TQuery, ISortClause)
Specifies the orderby of the query. All sort clauses are appended to the sort expression already present.
Public methodStatic memberOrderByTQuery(TQuery, ISortExpression)
Specifies the orderby of the query. All sort clauses are appended to the sort expression already present.
Public methodStatic memberOrWhereTQuery
Specifies the where clause of the query by appending it with Or to the existing (if any) predicates
Public methodStatic memberPageTQuery
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.
Public methodStatic memberSelect(DynamicQuery, Object)
Specifies the projection of the query. It clears any existing projection and sets the projection to the one specified.
Public methodStatic memberSelectT(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.
Public methodStatic memberSelectT(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.
Public methodStatic memberSelectT(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.
Public methodStatic memberSelectT, 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.
Public methodStatic memberSelectFrom(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.
Public methodStatic memberSelectFromT(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.
Public methodStatic memberToResultsetT(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.
Public methodStatic memberToResultsetT(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.
Public methodStatic memberToSingleResultT(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.
Public methodStatic memberToSingleResultT(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.
Public methodStatic memberUnion(DynamicQuery, DynamicQuery)
Specifies the query toUnion which should be union-ed with query using the UNION operator
Public methodStatic memberUnionT(DynamicQueryT, DynamicQuery)
Specifies the query toUnion which should be union-ed with query using the UNION operator
Public methodStatic memberUnionTEntity(EntityQueryTEntity, EntityQueryTEntity)
Specifies the query toUnion which should be union-ed with query using the UNION operator
Public methodStatic memberUnionAll(DynamicQuery, DynamicQuery)
Specifies the query toUnion which should be union-ed with query using the UNION ALL operator
Public methodStatic memberUnionAllT(DynamicQueryT, DynamicQuery)
Specifies the query toUnion which should be union-ed with query using the UNION ALL operator
Public methodStatic memberUnionAllTEntity(EntityQueryTEntity, EntityQueryTEntity)
Specifies the query toUnion which should be union-ed with query using the UNION ALL operator
Public methodStatic memberWhereTQuery
Specifies the where clause of the query by appending it with And to the existing (if any) predicates
Public methodStatic memberWhereExistsTQuery
Specifies the where clause of the query by appending an EXISTS predicate based on the existsQuery predicate specified.
Public methodStatic memberWhereNotExistsTQuery
Specifies the where clause of the query by appending a NOT EXISTS predicate based on the existsQuery predicate specified.
Top
See Also