| QuerySpec Methods |
The QuerySpec type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | AddAsRelation |
Prepares the implementor by converting it to a relation object and adds it to the passed in relationcollection.
|
| 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.
|
| AddFromClauseDirective |
Adds from clause directive.
|
| AddFromClauseDirectives |
Adds from clause directives.
|
| AppendToPreparedWhereClauseWithAnd |
Appends the predicate with And to the prepared where clause. Only used for appending additional filters to specified filters.
|
| AssureAlias |
Assures that the query has a proper alias. This is necessary for derived table generation, as derived tables need an alias.
|
| CoerceToScalarQuery |
Coerces this query to a scalar query expression
|
| ConvertToDynamicRelationOperand |
Converts this instance to a dynamic relation operand.
|
| 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.
|
| 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.
|
| DetermineIfWrappingAsDerivedTableIsRequiredForScalarQuery(AggregateFunction) |
Determines if wrapping as derived table is required for scalar query.
|
| DetermineRealTargetAliasToUse |
Determines the real target alias to use.
|
| DetermineResultsetType |
Determines the type of the resultset. This type is used to build resultset instances for hierarchy fetches.
|
 | 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.
|
| 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().
|
| GetAllFieldsFromProjection |
Gets all fields from projection.
|
| GetFromAsString |
Gets from as string.
|
| GetFromClauseDirectiveClones |
Gets from clause directives as clones.
|
| GetGroupByAsString |
Gets the group by as string.
|
| GetHashCode | Serves as the default hash function. (Inherited from Object.) |
| GetHavingAsString |
Gets the having as string.
|
| GetOrderByAsString |
Gets the order by as string.
|
| GetPrefetchPathAsString |
Gets the prefetch path as string.
|
| GetProjectionAsEntityFields |
Gets the projection as EntityFields object
|
| GetProjectionAsEntityFields2 |
Gets the projection as EntityFields2 object
|
| GetProjectionAsString |
Gets the projection as string.
|
| GetQueryParameters |
Gets the query parameters, built from the elements for the query inside this expression
|
| 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.
|
| GetThisAsEmptyClone |
Gets the this as empty clone.
|
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| GetWhereAsString |
Gets the where as string.
|
| HandleUnwrapTvfCall |
Handles the unwrap TVF call action.
|
| IsEmpty |
Determines whether this instance is empty.
|
| MarkAsNotPrepared |
Makes this query as being not prepared so it will be re-prepared the next time Prepare() is called.
|
| MarkAsPrepared |
Marks as prepared.
|
| 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.
|
| Prepare |
Prepares the contents of this query to be executed.
|
| PrepareForExecution |
Prepares this query for execution.
|
| RaiseQueryTargetUsageExceptionIfApplicable |
Raises an exception if a QueryTarget was used in a query type which wasn't suitable for that. By default it does this
|
| ReplacePlaceHolders |
Replaces the EntityQueryPlaceHolder objects with this instance
|
| SetCorrelationPredicate |
Sets the correlation predicate.
|
| SetTargetAlias |
Sets the target alias.
|
| ToDerivedTable |
Converts this instance to a derived table definition.
|
| ToString |
Returns a String that represents this instance.
(Overrides ObjectToString.) |
| ToString(Int32) |
Returns a String that represents this instance.
|
Extension Methods| 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.) |
| 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 |
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(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(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.) |
| CrossJoin(IEntityRelation) | Overloaded.
Creates a new join of type CROSS JOIN between the left operand the method is called on and the right operand of the specified relationship,
over the relationship specified
(Defined by JoinOperandExtensionMethods.) |
| CrossJoin(IJoinOperand) | Overloaded.
Creates a new join of type CROSS JOIN between the left operand the method is called on and the specified right operand.
(Defined by JoinOperandExtensionMethods.) |
| CrossJoin(IEntityRelation, String, String) | Overloaded.
Creates a new join of type CROSS JOIN between the left operand the method is called on and the right operand of the specified relationship,
over the relationship specified
(Defined by JoinOperandExtensionMethods.) |
| FullJoin(IEntityRelation) | Overloaded.
Creates a new join of type FULL JOIN between the left operand the method is called on and the right operand of the specified relationship,
over the relationship specified
(Defined by JoinOperandExtensionMethods.) |
| FullJoin(IJoinOperand) | Overloaded.
Creates a new join of type FULL JOIN between the left operand the method is called on and the specified right operand.
(Defined by JoinOperandExtensionMethods.) |
| FullJoin(IEntityRelation, String, String) | Overloaded.
Creates a new join of type FULL JOIN between the left operand the method is called on and the right operand of the specified relationship,
over the relationship specified
(Defined by JoinOperandExtensionMethods.) |
| InnerJoin(IEntityRelation) | Overloaded.
Creates a new join of type INNER JOIN between the left operand the method is called on and the right operand of the specified relationship,
over the relationship specified
(Defined by JoinOperandExtensionMethods.) |
| InnerJoin(IJoinOperand) | Overloaded.
Creates a new join of type INNER JOIN between the left operand the method is called on and the specified right operand.
(Defined by JoinOperandExtensionMethods.) |
| InnerJoin(IEntityRelation, String, String) | Overloaded.
Creates a new join of type INNER JOIN between the left operand the method is called on and the right operand of the specified relationship,
over the relationship specified
(Defined by JoinOperandExtensionMethods.) |
| LeftJoin(IEntityRelation) | Overloaded.
Creates a new join of type LEFT JOIN between the left operand the method is called on and the right operand of the specified relationship,
over the relationship specified
(Defined by JoinOperandExtensionMethods.) |
| LeftJoin(IJoinOperand) | Overloaded.
Creates a new join of type LEFT JOIN between the left operand the method is called on and the specified right operand.
(Defined by JoinOperandExtensionMethods.) |
| LeftJoin(IEntityRelation, String, String) | Overloaded.
Creates a new join of type LEFT JOIN between the left operand the method is called on and the right operand of the specified relationship,
over the relationship specified
(Defined by JoinOperandExtensionMethods.) |
| 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(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.) |
| RightJoin(IEntityRelation) | Overloaded.
Creates a new join of type RIGHT JOIN between the left operand the method is called on and the right operand of the specified relationship,
over the relationship specified
(Defined by JoinOperandExtensionMethods.) |
| RightJoin(IJoinOperand) | Overloaded.
Creates a new join of type RIGHT JOIN between the left operand the method is called on and the specified right operand.
(Defined by JoinOperandExtensionMethods.) |
| RightJoin(IEntityRelation, String, String) | Overloaded.
Creates a new join of type RIGHT JOIN between the left operand the method is called on and the right operand of the specified relationship,
over the relationship specified
(Defined by JoinOperandExtensionMethods.) |
| 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(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.) |
| 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.) |
| 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.) |
Explicit Interface Implementations| Name | Description | |
|---|---|---|
  | IJoinOperandConvertToDynamicRelationOperand |
Converts this instance to a dynamic relation operand.
|
| IJoinOperandPrepare |
Prepares the implementor by converting it to a relation object and adds it to the passed in relationcollection.
|
| 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.
|
See Also