| ScalarQueryProducers Class |
Class with extension methods to produce scalar queries from normal queryspec queries.
Inheritance HierarchyNamespace: SD.LLBLGen.Pro.QuerySpec
Assembly: SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.3.0.0 (5.3.0)
SyntaxThe 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.
|
See Also