ScalarQueryProducers Class

Class with extension methods to produce scalar queries from normal queryspec queries.

Inheritance Hierarchy

SystemObject
SD.LLBLGen.Pro.QuerySpecScalarQueryProducers

Namespace: SD.LLBLGen.Pro.QuerySpec
Assembly: SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.5.0.0 (5.5.18.1019)

Syntax

Copy

public static class ScalarQueryProducers

<ExtensionAttribute>
Public NotInheritable Class ScalarQueryProducers

The ScalarQueryProducers type exposes the following members.

Methods

	Name	Description
	Avg(DynamicQuery)	Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
	Avg(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the Avg() aggregate function.
	Avg(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the Avg() aggregate function.
	AvgDistinct(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the Avg(Distinct ) aggregate function.
	AvgDistinct(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the Avg(Distinct ) aggregate function.
	Count(DynamicQuery)	Creates a scalar query over the specified query and aggregates the first field in the projection of the query. Semantically equal to CountRow
	Count(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the Count() aggregate function.
	Count(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the Count() aggregate function.
	CountBig(DynamicQuery)	Creates a scalar query over the specified query and aggregates the first field in the projection of the query. Semantically equal to CountBigRow
	CountBig(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the CountBig() aggregate function.
	CountBig(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the CountBig() aggregate function.
	CountBigDistinct(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the CountBig(Distinct ) aggregate function.
	CountBigDistinct(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the CountBig(Distinct ) aggregate function.
	CountBigRow	Creates a COUNT_BIG(*) query of the query specified, SQL Server specific
	CountDistinct(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the Count(Distinct ) aggregate function.
	CountDistinct(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the Count(Distinct ) aggregate function.
	CountRow	Creates a COUNT(*) query of the query specified.
	Max(DynamicQuery)	Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
	Max(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the Max() aggregate function.
	Max(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the Max() aggregate function.
	Min(DynamicQuery)	Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
	Min(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the Min() aggregate function.
	Min(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the Min() aggregate function.
	StDev(DynamicQuery)	Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
	StDev(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the StDev() aggregate function.
	StDev(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the StDev() aggregate function.
	StDevDistinct(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the StDev(Distinct ) aggregate function.
	StDevDistinct(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the StDev(Distinct ) aggregate function.
	Sum(DynamicQuery)	Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
	Sum(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the Sum() aggregate function.
	Sum(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the Sum() aggregate function.
	SumDistinct(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the Sum(Distinct ) aggregate function.
	SumDistinct(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the Sum(Distinct ) aggregate function.
	ToScalar(QuerySpec)	Converts the specified query to a scalar query, without enforcing a row limit.
	ToScalar(QuerySpec, Boolean)	Converts the specified query to a scalar query.
	Variance(DynamicQuery)	Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
	Variance(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the Variance() aggregate function.
	Variance(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the Variance() aggregate function.
	VarianceDistinct(QuerySpec, IEntityFieldCore)	Creates a scalar query over the specified query and aggregates the field specified with the Variance(Distinct ) aggregate function.
	VarianceDistinct(QuerySpec, IExpression)	Creates a scalar query over the specified query and aggregates the expression specified with the Variance(Distinct ) aggregate function.

Top

Reference

SD.LLBLGen.Pro.QuerySpec Namespace