Click or drag to resize

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.9.0.0 (5.9.0)
Syntax
public static class ScalarQueryProducers

The ScalarQueryProducers type exposes the following members.

Methods
  NameDescription
Public methodStatic memberAvg(DynamicQuery)
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
Public methodStatic memberAvg(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the Avg() aggregate function.
Public methodStatic memberAvg(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the Avg() aggregate function.
Public methodStatic memberAvgDistinct(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the Avg(Distinct ) aggregate function.
Public methodStatic memberAvgDistinct(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the Avg(Distinct ) aggregate function.
Public methodStatic memberCount(DynamicQuery)
Creates a scalar query over the specified query and aggregates the first field in the projection of the query. Semantically equal to CountRow
Public methodStatic memberCount(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the Count() aggregate function.
Public methodStatic memberCount(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the Count() aggregate function.
Public methodStatic memberCountBig(DynamicQuery)
Creates a scalar query over the specified query and aggregates the first field in the projection of the query. Semantically equal to CountBigRow
Public methodStatic memberCountBig(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the CountBig() aggregate function.
Public methodStatic memberCountBig(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the CountBig() aggregate function.
Public methodStatic memberCountBigDistinct(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the CountBig(Distinct ) aggregate function.
Public methodStatic memberCountBigDistinct(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the CountBig(Distinct ) aggregate function.
Public methodStatic memberCountBigRow
Creates a COUNT_BIG(*) query of the query specified, SQL Server specific
Public methodStatic memberCountDistinct(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the Count(Distinct ) aggregate function.
Public methodStatic memberCountDistinct(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the Count(Distinct ) aggregate function.
Public methodStatic memberCountRow
Creates a COUNT(*) query of the query specified.
Public methodStatic memberMax(DynamicQuery)
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
Public methodStatic memberMax(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the Max() aggregate function.
Public methodStatic memberMax(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the Max() aggregate function.
Public methodStatic memberMin(DynamicQuery)
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
Public methodStatic memberMin(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the Min() aggregate function.
Public methodStatic memberMin(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the Min() aggregate function.
Public methodStatic memberStDev(DynamicQuery)
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
Public methodStatic memberStDev(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the StDev() aggregate function.
Public methodStatic memberStDev(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the StDev() aggregate function.
Public methodStatic memberStDevDistinct(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the StDev(Distinct ) aggregate function.
Public methodStatic memberStDevDistinct(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the StDev(Distinct ) aggregate function.
Public methodStatic memberSum(DynamicQuery)
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
Public methodStatic memberSum(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the Sum() aggregate function.
Public methodStatic memberSum(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the Sum() aggregate function.
Public methodStatic memberSumDistinct(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the Sum(Distinct ) aggregate function.
Public methodStatic memberSumDistinct(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the Sum(Distinct ) aggregate function.
Public methodStatic memberToScalar(QuerySpec)
Converts the specified query to a scalar query, without enforcing a row limit.
Public methodStatic memberToScalar(QuerySpec, Boolean)
Converts the specified query to a scalar query.
Public methodStatic memberVariance(DynamicQuery)
Creates a scalar query over the specified query and aggregates the first field in the projection of the query.
Public methodStatic memberVariance(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the Variance() aggregate function.
Public methodStatic memberVariance(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the Variance() aggregate function.
Public methodStatic memberVarianceDistinct(QuerySpec, IEntityFieldCore)
Creates a scalar query over the specified query and aggregates the field specified with the Variance(Distinct ) aggregate function.
Public methodStatic memberVarianceDistinct(QuerySpec, IExpression)
Creates a scalar query over the specified query and aggregates the expression specified with the Variance(Distinct ) aggregate function.
Top
See Also