EntityQueryTEntity Class

Initializes a new instance of the EntityQueryTEntity class.

Initializes a new instance of the EntityQueryTEntity class.

Gets or sets the alias.

Gets or sets the context to use for the query. The context value set is used during entity fetches when no entity collection is passed to the fetch method.

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.

Gets a value indicating whether this instance is prepared.

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

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.

Gets the last clause on the from clause set list or null if nothing is there. Used with unwrapping tvf calls.

Gets the type of the resultset element.

Gets the target alias.

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.

Prepares the implementor by converting it to a relation object and adds it to the passed in relationcollection.

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.

Adds from clause directive.

Adds from clause directives.

Appends the predicate with And to the prepared where clause. Only used for appending additional filters to specified filters.

Assures that the query has a proper alias. This is necessary for derived table generation, as derived tables need an alias.

Converts this instance into an EntityQuery<TTargetType>.

Coerces this query to a scalar query expression

Converts this instance to a dynamic relation operand.

Uses the specified relationship to construct a correlation predicate between this query (where TEntity should be the start entity of the relation specified) and a parent entity query. This method helps constructing correlation predicates without knowing the FK - PK relationships.

Uses the specified relationship to construct a correlation predicate between this query (where TEntity should be the start entity of the relation specified) and a parent entity query. This method helps constructing correlation predicates without knowing the FK - PK relationships.

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.

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.

Determines if wrapping as derived table is required for scalar query.

Determines the real target alias to use.

Determines the type of the resultset. This type is used to build resultset instances for hierarchy fetches.

Determines whether the specified object is equal to the current object.

Creates a field which targets the projection of this query. Use this to easily create a derived table targeting field which targets this query.

Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.

Specifies a temporal table predicate on source for the Business Time.

Specifies a temporal table predicate on source for the System Time.

Gets the additional info as string. For ToString().

Gets all fields from projection.

Gets from as string.

Gets from clause directives as clones.

Gets the group by as string.

Serves as the default hash function.

Gets the having as string.

Gets the order by as string.

Gets the prefetch path as string.

Gets the projection as EntityFields object

Gets the projection as EntityFields2 object

Gets the projection as string.

Gets the query parameters, built from the elements for the query inside this expression

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.

Gets the this as empty clone.

Gets the Type of the current instance.

Gets the where as string.

Handles the unwrap TVF call action.

Determines whether this instance is empty.

Makes this query as being not prepared so it will be re-prepared the next time Prepare() is called.

Marks as prepared.

Creates a shallow copy of the current Object.

Sets the type filter of the query to a negated typefilter of the entity type specified as TEntityFilter. This means that all entities matching this query of type TEntityFilter or the (indirect) subtypes of TEntityFilter won't be fetched.

Sets the type filter of the query to the typefilter of the entity type specified as TEntityFilter. This means that all entities matching this query will be of type TEntityFilter or any of its (indirect) subtypes.

Called when PrepareForExecution has been completed successfully. Calls the lambda set in OnPrepareForExecutionCallBack, if set.

Prepares the contents of this query to be executed.

Prepares this query for execution.

Raises an exception if a QueryTarget was used in a query type which wasn't suitable for that. By default it does this

Replaces the EntityQueryPlaceHolder objects with this instance

Specifies the projection of the query. It clears any existing projection and sets the projection to the one specified.

Specifies the projection of the query. 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.

Sets the correlation predicate.

Sets the target alias.

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.

Converts this instance to a derived table definition.

Returns a String that represents this instance.

Returns a String that represents this instance.

Specifies a table/view hint for the target TEntity is mapped on.

Specifies the prefetch path to use for this query. Prefetch paths are only used when this query is the outer query which is executed.

Creates a predicate which has to be true for all elements in query, which is equal to NOT EXISTS(QUERY.Where(NOT predicate))

Creates a predicate which has to be true it there's at least one element in query, which is equal to EXISTS(QUERY)

Creates a predicate which has to be true for at least one element in query, which is equal to EXISTS(QUERY.Where(predicate))

Specifies the alias of the query as a whole. To set the alias of the target of the query, use TargetAs(alias).

Creates a scalar query over the specified query and aggregates the field specified with the Avg() aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the Avg() aggregate function.

Creates a scalar query over the specified query and aggregates the field specified with the Avg(Distinct ) aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the Avg(Distinct ) aggregate function.

Creates a predicate which has to be true if the query contains an entity which has the same PK values as the entityInstance specified

Creates a predicate which has to be true if the query contains the entities in valueSupplierQuery

Creates a scalar query over the specified query and aggregates the field specified with the Count() aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the Count() aggregate function.

Creates a scalar query over the specified query and aggregates the field specified with the CountBig() aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the CountBig() aggregate function.

Creates a scalar query over the specified query and aggregates the field specified with the CountBig(Distinct ) aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the CountBig(Distinct ) aggregate function.

Creates a COUNT_BIG(*) query of the query specified, SQL Server specific

Creates a scalar query over the specified query and aggregates the field specified with the Count(Distinct ) aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the Count(Distinct ) aggregate function.

Creates a COUNT(*) query of the query specified.

Sets the AllowDuplicates flag to false, so the query won't return duplicate rows.

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'

Specifies the where clause of the query by appending a predicate which is true for each entity in query which isn't in toExclude.

Specifies the fields to exclude from the query, fetching all other fields not mentioned in the list of fields to exclude.

Fetches the first entity of the set returned by the query and returns that entity, if any, otherwise null.

Fetches the first entity of the set returned by the query and returns that entity, if any, otherwise null.

Async variant of GetFirstTEntity(EntityQueryTEntity). Fetches the first entity of the set returned by the query and returns that entity, if any, otherwise null.

Async variant of GetFirstTEntity(EntityQueryTEntity). Fetches the first entity of the set returned by the query and returns that entity, if any, otherwise null.

Async variant of GetFirstTEntity(EntityQueryTEntity, ITransaction). Fetches the first entity of the set returned by the query and returns that entity, if any, otherwise null.

Async variant of GetFirstTEntity(EntityQueryTEntity, ITransaction). Fetches the first entity of the set returned by the query and returns that entity, if any, otherwise null.

Fetches the single entity of the set returned by the query and returns that entity. If there are no elements or more than 1 element, a NotSupportedException will be thrown.

Fetches the single entity of the set returned by the query and returns that entity. If there are no elements or more than 1 element, a NotSupportedException will be thrown.

Async variant of GetSingleTEntity(EntityQueryTEntity). Fetches the single entity of the set returned by the query and returns that entity. If there are no elements or more than 1 element, a NotSupportedException will be thrown.

Async variant of GetSingleTEntity(EntityQueryTEntity). Fetches the single entity of the set returned by the query and returns that entity. If there are no elements or more than 1 element, a NotSupportedException will be thrown.

Async variant of GetSingleTEntity(EntityQueryTEntity, ITransaction). Fetches the single entity of the set returned by the query and returns that entity. If there are no elements or more than 1 element, a NotSupportedException will be thrown.

Async variant of GetSingleTEntity(EntityQueryTEntity, ITransaction). Fetches the single entity of the set returned by the query and returns that entity. If there are no elements or more than 1 element, a NotSupportedException will be thrown.

Specifies tht fields to include in the query, excluding all other fields not necessary for the fetch.

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'

Specifies the where clause of the query by appending a predicate which is true for each entity in query which is also in toInclude.

Creates a scalar query over the specified query and aggregates the field specified with the Max() aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the Max() aggregate function.

Creates a scalar query over the specified query and aggregates the field specified with the Min() aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the Min() aggregate function.

Creates a scalar query over the specified query and aggregates the field specified with the StDev() aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the StDev() aggregate function.

Creates a scalar query over the specified query and aggregates the field specified with the StDev(Distinct ) aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the StDev(Distinct ) aggregate function.

Creates a scalar query over the specified query and aggregates the field specified with the Sum() aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the Sum() aggregate function.

Creates a scalar query over the specified query and aggregates the field specified with the Sum(Distinct ) aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the Sum(Distinct ) aggregate function.

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.

Converts the specified query to a scalar query, without enforcing a row limit.

Converts the specified query to a scalar query.

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.

Creates a scalar query over the specified query and aggregates the field specified with the Variance() aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the Variance() aggregate function.

Creates a scalar query over the specified query and aggregates the field specified with the Variance(Distinct ) aggregate function.

Creates a scalar query over the specified query and aggregates the expression specified with the Variance(Distinct ) aggregate function.

Gets or sets the context to use for the query. The context value set is used during entity fetches when no entity collection is passed to the fetch method.

Gets the fields to include exclude.

Gets the prefetch path.

Converts this instance to a dynamic relation operand.

Prepares the implementor by converting it to a relation object and adds it to the passed in relationcollection.

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.

Gets or sets the alias.

Gets AllowDuplicates (default is true, if Distinct() is specified, this value is false).

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,

Gets the from clause, which is the prepared from clause, created from the plain clause.

Gets the prepared group by clause.

Gets the limit value specified

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

Gets the offset value specified

Gets the prepared order by clause.

Gets the type of the resultset element.

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.

Gets the target alias.

Gets the prepared where clause.