DynamicQueryT Class |
Namespace: SD.LLBLGen.Pro.QuerySpec
The DynamicQueryT type exposes the following members.
Name | Description | |
---|---|---|
Alias |
Gets or sets the alias.
(Inherited from QuerySpec.) | |
CustomFunctionMappingStore |
Gets or sets the optional custom function mapping store. A custom function mapping store takes precedence over the function mapping store
obtained from the Dynamic Query Engine (DQE) used for producing the SQL for the query. If a custom function mapping store is needed for a query,
set this property only on the query object passed to the execution method. No need to set it on inner query objects.
(Inherited from QuerySpec.) | |
IsPrepared |
Gets a value indicating whether this instance is prepared.
(Inherited from QuerySpec.) | |
NestedQueries |
Gets the nested queries.
(Inherited from DynamicQuery.) | |
OnPrepareForExecutionCallBack |
Gets or sets the call back lambda which is called after this query has been prepared for execution. Use this method to tap into the
execution chain to do last-minute query object manipulation / inspection prior to the actual fetch action.
(Inherited from QuerySpec.) | |
RawFromClause |
Gets the last clause on the from clause set list or null if nothing is there. Used with unwrapping tvf calls.
(Inherited from QuerySpec.) | |
ResultsetElementType |
Gets the type of the resultset element.
(Overrides QuerySpecResultsetElementType.) | |
TargetAlias |
Gets the target alias.
(Inherited from QuerySpec.) | |
UseAliasForOuterAliasOnly |
Gets or sets a value indicating whether the 'Alias' value should be used only for the query's alias (true) or for target aliasing as well if
there's no target alias set (false, default). Set to true when the query is converted to a derived table.
(Inherited from QuerySpec.) |
Name | Description | |
---|---|---|
AddAsRelation |
Prepares the implementor by converting it to a relation object and adds it to the passed in relationcollection.
(Inherited from QuerySpec.) | |
AddFieldToProjectionIfNotPresent |
Adds the field to projection if not present already. Uses field alias checks. If this query is an entity query, it won't add any fields, only
verify whether the field is present.
(Inherited from DynamicQuery.) | |
AppendToPreparedWhereClauseWithAnd |
Appends the predicate with And to the prepared where clause. Only used for appending additional filters to specified filters.
(Inherited from QuerySpec.) | |
AssureAlias |
Assures that the query has a proper alias. This is necessary for derived table generation, as derived tables need an alias.
(Inherited from QuerySpec.) | |
CoerceToScalarQuery |
Coerces this query to a scalar query expression
(Inherited from QuerySpec.) | |
ConvertToDynamicRelationOperand |
Converts this instance to a dynamic relation operand.
(Inherited from DynamicQuery.) | |
DetermineIfDerivedTableIsTargetInFieldCompareSetPredicate |
Determines if the derived table variant of this query is the target when this query is used as the target of a field compare set predicate.
Only true if query is an entity query and entity is an inheritance entity of TargetPerEntity.
(Inherited from QuerySpec.) | |
DetermineIfWrappingAsDerivedTableIsRequiredForScalarQuery |
Determines if wrapping as derived table is required for scalar query. This overload looks at the prepared elements, and if a wrapping is required
it will return true, otherwise false.
(Inherited from DynamicQuery.) | |
DetermineIfWrappingAsDerivedTableIsRequiredForScalarQuery(AggregateFunction) |
Determines if wrapping as derived table is required for scalar query.
(Inherited from QuerySpec.) | |
DetermineRealTargetAliasToUse |
Determines the real target alias to use.
(Inherited from QuerySpec.) | |
DetermineResultsetType |
Determines the type of the resultset. This type is used to build resultset instances for hierarchy fetches.
(Overrides DynamicQueryDetermineResultsetType.) | |
Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) | |
Field |
Creates a field which targets the projection of this query. Use this to easily create a derived table targeting field which targets this query.
(Inherited from QuerySpec.) | |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) | |
GetAdditionalInfoAsString |
Gets the additional info as string. For ToString().
(Inherited from QuerySpec.) | |
GetAllFieldsFromProjection |
Gets all fields from projection.
(Inherited from DynamicQuery.) | |
GetFromAsString |
Gets from as string.
(Inherited from QuerySpec.) | |
GetGroupByAsString |
Gets the group by as string.
(Inherited from QuerySpec.) | |
GetHashCode | Serves as the default hash function. (Inherited from Object.) | |
GetHavingAsString |
Gets the having as string.
(Inherited from QuerySpec.) | |
GetOrderByAsString |
Gets the order by as string.
(Inherited from QuerySpec.) | |
GetPrefetchPathAsString |
Gets the prefetch path as string.
(Inherited from QuerySpec.) | |
GetProjectionAsEntityFields |
Gets the projection as EntityFields object
(Inherited from DynamicQuery.) | |
GetProjectionAsEntityFields2 |
Gets the projection as EntityFields2 object
(Inherited from DynamicQuery.) | |
GetProjectionAsString |
Gets the projection as string.
(Inherited from DynamicQuery.) | |
GetProjectorFunc |
Gets the projector func to use for projections, so instantes of real types can be created
(Overrides DynamicQueryGetProjectorFunc.) | |
GetQueryParameters |
Gets the query parameters, built from the elements for the query inside this expression
(Inherited from QuerySpec.) | |
GetReplacementForQueryTarget |
Gets the replacement for query target. By default this is the result of GetThisAsEmptyClone(). It will thrown an exception if
the class isn't an entityquery, unless this method is overriden in a subtype.
(Inherited from DynamicQuery.) | |
GetThisAsEmptyClone |
Gets the this as empty clone.
(Inherited from DynamicQuery.) | |
GetType | Gets the Type of the current instance. (Inherited from Object.) | |
GetWhereAsString |
Gets the where as string.
(Inherited from QuerySpec.) | |
HandleUnwrapTvfCall |
Handles the unwrap TVF call action.
(Inherited from QuerySpec.) | |
IsEmpty |
Determines whether this instance is empty.
(Inherited from DynamicQuery.) | |
MarkAsNotPrepared |
Makes this query as being not prepared so it will be re-prepared the next time Prepare() is called.
(Inherited from DynamicQuery.) | |
MarkAsPrepared |
Marks as prepared.
(Inherited from QuerySpec.) | |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
OnPreparedForExecution |
Called when PrepareForExecution has been completed successfully. Calls the lambda set in OnPrepareForExecutionCallBack, if set.
(Inherited from QuerySpec.) | |
Prepare |
Prepares the contents of this query to be executed.
(Inherited from DynamicQuery.) | |
PrepareForExecution |
Prepares this query for execution.
(Inherited from DynamicQuery.) | |
RaiseQueryTargetUsageExceptionIfApplicable |
Raises an exception if a QueryTarget was used in a query type which wasn't suitable for that. By default it does this
(Inherited from QuerySpec.) | |
ReplacePlaceHolders |
Replaces the EntityQueryPlaceHolder objects with this instance
(Inherited from QuerySpec.) | |
SetCorrelationPredicate |
Sets the correlation predicate.
(Inherited from QuerySpec.) | |
SetTargetAlias |
Sets the target alias.
(Inherited from QuerySpec.) | |
TargetAs |
Sets the target alias to the alias specified. By default this alias is the empty string. This alias is a different alias than the alias
set with .As(string), as this alias is the alias on the target table(s), while .As(string) is the alias for the whole query.
(Inherited from DynamicQuery.) | |
ToDerivedTable |
Converts this instance to a derived table definition.
(Inherited from DynamicQuery.) | |
ToString |
Returns a String that represents this instance.
(Inherited from QuerySpec.) | |
ToString(Int32) |
Returns a String that represents this instance.
(Inherited from QuerySpec.) | |
WithProjectorT |
Specifies the projector delegate/func which will be used to produce typed instances for each row returned by the query.
(Inherited from DynamicQuery.) |
Name | Description | |
---|---|---|
All |
Creates a predicate which has to be true for all elements in query, which is equal to NOT EXISTS(QUERY.Where(NOT predicate))
(Defined by AllAnyPredicateProducers.) | |
Any | Overloaded.
Creates a predicate which has to be true it there's at least one element in query, which is equal to EXISTS(QUERY)
(Defined by AllAnyPredicateProducers.) | |
Any(IPredicate) | Overloaded.
Creates a predicate which has to be true for at least one element in query, which is equal to EXISTS(QUERY.Where(predicate))
(Defined by AllAnyPredicateProducers.) | |
As(String) | Overloaded.
Specifies the alias of the query
(Defined by QuerySpecExtensionMethods.) | |
AsT(String) | Overloaded.
Specifies the alias of the query
(Defined by QuerySpecExtensionMethods.) | |
Avg | Overloaded.
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
(Defined by ScalarQueryProducers.) | |
Avg(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the Avg() aggregate function.
(Defined by ScalarQueryProducers.) | |
Avg(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the Avg() aggregate function.
(Defined by ScalarQueryProducers.) | |
AvgDistinct(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the Avg(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) | |
AvgDistinct(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the Avg(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) | |
Contains(Object) | Overloaded.
Creates a predicate which has to be true if the query contains the value specified.
(Defined by ContainsPredicateProducers.) | |
Contains(DynamicQuery) | Overloaded.
Creates a predicate which has to be true if a value in the set produced by query valueSupplierQuery is in the set produced by query.
(Defined by ContainsPredicateProducers.) | |
Contains(IEntityCore) | Overloaded.
Creates a predicate which has to be true if the query contains an entity which has the same PK values as the entityInstance specified
(Defined by ContainsPredicateProducers.) | |
Count | Overloaded.
Creates a scalar query over the specified query and aggregates the first field in the projection of the query. Semantically equal to CountRow
(Defined by ScalarQueryProducers.) | |
Count(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the Count() aggregate function.
(Defined by ScalarQueryProducers.) | |
Count(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the Count() aggregate function.
(Defined by ScalarQueryProducers.) | |
CountBig | Overloaded.
Creates a scalar query over the specified query and aggregates the first field in the projection of the query. Semantically equal to CountBigRow
(Defined by ScalarQueryProducers.) | |
CountBig(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the CountBig() aggregate function.
(Defined by ScalarQueryProducers.) | |
CountBig(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the CountBig() aggregate function.
(Defined by ScalarQueryProducers.) | |
CountBigDistinct(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the CountBig(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) | |
CountBigDistinct(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the CountBig(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) | |
CountBigRow |
Creates a COUNT_BIG(*) query of the query specified, SQL Server specific
(Defined by ScalarQueryProducers.) | |
CountDistinct(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the Count(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) | |
CountDistinct(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the Count(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) | |
CountRow |
Creates a COUNT(*) query of the query specified.
(Defined by ScalarQueryProducers.) | |
Distinct | Overloaded.
Sets the AllowDuplicates flag to false, so the query won't return duplicate rows.
(Defined by QuerySpecExtensionMethods.) | |
DistinctT | Overloaded.
Sets the AllowDuplicates flag to false, so the query won't return duplicate rows.
(Defined by QuerySpecExtensionMethods.) | |
Except(DynamicQuery) | Overloaded.
Specifies the where clause of the query by appending a predicate which is true for each element in query which is also in toExclude.
(Defined by QuerySpecExtensionMethods.) | |
ExceptT(DynamicQuery) | Overloaded.
Specifies the where clause of the query by appending a predicate which is true for each element in query which is also in toExclude.
(Defined by QuerySpecExtensionMethods.) | |
Intersect(DynamicQuery) | Overloaded.
Specifies the where clause of the query by appending a predicate which is true for each element in query which is also in toInclude.
(Defined by QuerySpecExtensionMethods.) | |
IntersectT(DynamicQuery) | Overloaded.
Specifies the where clause of the query by appending a predicate which is true for each element in query which is also in toInclude.
(Defined by QuerySpecExtensionMethods.) | |
Max | Overloaded.
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
(Defined by ScalarQueryProducers.) | |
Max(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the Max() aggregate function.
(Defined by ScalarQueryProducers.) | |
Max(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the Max() aggregate function.
(Defined by ScalarQueryProducers.) | |
Min | Overloaded.
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
(Defined by ScalarQueryProducers.) | |
Min(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the Min() aggregate function.
(Defined by ScalarQueryProducers.) | |
Min(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the Min() aggregate function.
(Defined by ScalarQueryProducers.) | |
Select(Object) | Overloaded.
Specifies the projection of the query. It clears any existing projection and sets the projection to the one specified.
(Defined by QuerySpecExtensionMethods.) | |
SelectT(Object) | Overloaded.
Specifies the projection of the query. It clears any existing projection and sets the projection to the one specified.
(Defined by QuerySpecExtensionMethods.) | |
SelectT(ExpressionFuncT) | Overloaded.
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.
(Defined by QuerySpecExtensionMethods.) | |
SelectT, U | Overloaded.
Specifies the projection of the query specified, making it a typed dynamic query. It creates the projection from the two type arguments given.
(Defined by QuerySpecExtensionMethods.) | |
SelectFrom(DynamicQuery) | Overloaded.
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.
(Defined by QuerySpecExtensionMethods.) | |
SelectFromT(DynamicQueryT) | Overloaded.
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.
(Defined by QuerySpecExtensionMethods.) | |
StDev | Overloaded.
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
(Defined by ScalarQueryProducers.) | |
StDev(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the StDev() aggregate function.
(Defined by ScalarQueryProducers.) | |
StDev(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the StDev() aggregate function.
(Defined by ScalarQueryProducers.) | |
StDevDistinct(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the StDev(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) | |
StDevDistinct(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the StDev(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) | |
Sum | Overloaded.
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
(Defined by ScalarQueryProducers.) | |
Sum(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the Sum() aggregate function.
(Defined by ScalarQueryProducers.) | |
Sum(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the Sum() aggregate function.
(Defined by ScalarQueryProducers.) | |
SumDistinct(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the Sum(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) | |
SumDistinct(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the Sum(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) | |
ToResultsetT |
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.
(Defined by QuerySpecExtensionMethods.) | |
ToScalar | Overloaded.
Converts the specified query to a scalar query, without enforcing a row limit.
(Defined by ScalarQueryProducers.) | |
ToScalar(Boolean) | Overloaded.
Converts the specified query to a scalar query.
(Defined by ScalarQueryProducers.) | |
ToSingleResultT |
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.
(Defined by QuerySpecExtensionMethods.) | |
Variance | Overloaded.
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
(Defined by ScalarQueryProducers.) | |
Variance(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the Variance() aggregate function.
(Defined by ScalarQueryProducers.) | |
Variance(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the Variance() aggregate function.
(Defined by ScalarQueryProducers.) | |
VarianceDistinct(IEntityFieldCore) | Overloaded.
Creates a scalar query over the specified query and aggregates the field specified with the Variance(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) | |
VarianceDistinct(IExpression) | Overloaded.
Creates a scalar query over the specified query and aggregates the expression specified with the Variance(Distinct ) aggregate function.
(Defined by ScalarQueryProducers.) |
Name | Description | |
---|---|---|
IDynamicQueryProjection |
Gets the prepared projection.
(Inherited from DynamicQuery.) | |
IJoinOperandConvertToDynamicRelationOperand |
Converts this instance to a dynamic relation operand.
(Inherited from QuerySpec.) | |
IJoinOperandPrepare |
Prepares the implementor by converting it to a relation object and adds it to the passed in relationcollection.
(Inherited from QuerySpec.) | |
IJoinOperandUnwrapTvfCall |
If this element is a tvf call container, and it's empty except for the tvf call, it will return the tvfcall it wraps,
otherwise it will return itself.
(Inherited from QuerySpec.) | |
IQuerySpecAlias |
Gets or sets the alias.
(Inherited from QuerySpec.) | |
IQuerySpecAllowDuplicates |
Gets AllowDuplicates (default is true, if Distinct() is specified, this value is false).
(Inherited from QuerySpec.) | |
IQuerySpecCustomFunctionMappingStore |
Gets the optional custom function mapping store. A custom function mapping store takes precedence over the function mapping store
obtained from the Dynamic Query Engine (DQE) used for producing the SQL for the query. If a custom function mapping store is needed for a query,
(Inherited from QuerySpec.) | |
IQuerySpecFromClause |
Gets the from clause, which is the prepared from clause, created from the raw clause.
(Inherited from QuerySpec.) | |
IQuerySpecGroupByClause |
Gets the prepared group by clause.
(Inherited from QuerySpec.) | |
IQuerySpecLimit |
Gets the limit value specified
(Inherited from QuerySpec.) | |
IQuerySpecNestedQueries |
Gets the nested queries defined for this query. By default this is an empty list, and only filled with nested queries if this query is a dynamic query
and it contains one or more nested queries
(Inherited from QuerySpec.) | |
IQuerySpecOffset |
Gets the offset value specified
(Inherited from QuerySpec.) | |
IQuerySpecOrderByClause |
Gets the prepared order by clause.
(Inherited from QuerySpec.) | |
IQuerySpecResultsetElementType |
Gets the type of the resultset element.
(Inherited from QuerySpec.) | |
IQuerySpecResultsetType |
Gets the type of the resultset. For DynamicQuery instances this is List<object>, for DynamicQuery<T> this is List<T>, and for
EntityQuery<T>, this is either an IEntityCollection or IEntityCollection2 created for the type T.
(Inherited from QuerySpec.) | |
IQuerySpecTargetAlias |
Gets the target alias.
(Inherited from QuerySpec.) | |
IQuerySpecWhereClause |
Gets the prepared where clause.
(Inherited from QuerySpec.) |