AggregateFunction Enumeration

LLBLGen Pro v5.3 Runtime Framework Reference Manual

LLBLGen Pro v5.3 Runtime Framework Reference Manual

SD.LLBLGen.Pro.ORMSupportClasses Namespaces

SD.LLBLGen.Pro.ORMSupportClasses

ActionQuery Class

ActionQueueElement(TEntity) Class

AggregateFunction Enumeration

AggregateSetFunction Enumeration

AggregateSetPredicate Class

AggregateSetPredicateCallback Delegate

AliasScope Class

ArgumentVerifier Class

AuditorBase Class

AuthorizerBase Class

BatchActionQuery Class

BooleanCharYNConverter Class

BooleanNumericConverter Class

BuildInValidationBypass Enumeration

ByteDecimalConverter Class

CacheableChecker Class

CacheController Class

CachedResultset Class

CachedResultsetDataReader Class

CacheItem(T) Class

CancelableCollectionChangedEventArgs Class

CancelableDataSourceActionEventArgs Class

CascadeActionType Enumeration

CatalogNameOverwriteHashtable Class

CatalogNameUsage Enumeration

CharStringConverter Class

CollectionChangedEventArgs Class

CollectionCore(T) Class

ComparisonOperator Enumeration

ComPlusAdapterContextBase Class

ConcurrencyPredicateType Enumeration

ConfigFileHelper Class

CorrelationPredicateExpression Class

CustomXmlSerializationAttribute Class

DataAccessAdapterBase Class

DataAccessAdapterCore Class

DataProjectorToCustomClass(T) Class

DataProjectorToDataTable Class

DataProjectorToEntityCollectionBase Class

DataProjectorToIEntityCollection Class

DataProjectorToIEntityCollection2 Class

DataProjectorToObjectRowList Class

DataProjectorToValueList(T) Class

DataReaderProjectionRow Class

DataScope Class

DataScopeRefetchStrategyType Enumeration

DataSourceActionEventArgs Class

DataSourceCacheLocation Enumeration

DataSourceDataContainerType Enumeration

DataSourceDesigner2ConfigurationForm Class

DataSourceDesignerConfigurationForm Class

DataSourceSortingMode Enumeration

DataTableFiller Class

DataValueProjector Class

DateTimeDateTimeUTCConverter Class

DbFunctionCall Class

DbProviderFactoryInfo Class

DbSpecificCreatorBase Class

DelegatePredicate Class

DelegatePredicate(TEntity) Class

DelegatePredicateCallback Delegate

DependencyInjectionConfigInformation Class

DependencyInjectionContextType Enumeration

DependencyInjectionDiscoveryInformation Class

DependencyInjectionInfoAttribute Class

DependencyInjectionInfoProviderSingleton Class

DependencyInjectionScope Class

DependencyInjectionSectionHandler Class

DependencyInjectionTargetKind Enumeration

DerivedTableDefinition Class

DerivedTableFieldPresence Enumeration

DerivedTableFinder Class

DerivedTableTargetingFieldFinder Class

DesignTimeTracker Class

DistinctFilteringPreferenceType Enumeration

DoubleDecimalConverter Class

DQEConfigurationBase Class

DynamicQueryEngineBase Class

DynamicRelationBase Class

ElementCreatorBase Class

EntityBase Class

EntityBase2 Class

EntityCollectionBase(TEntity) Class

EntityCollectionBase2(TEntity) Class

EntityCollectionNonGeneric Class

EntityCore(TFields) Class

EntityFactoryCache2 Class

EntityFactoryCore Class

EntityFactoryCore2 Class

EntityField Class

EntityField2 Class

EntityFieldCore Class

EntityFieldPersistenceInfoList Class

EntityFields Class

EntityFields2 Class

EntityFieldsCore(TField) Class

EntityProperty Class

EntityPropertyDescriptor Class

EntityPropertyProjector Class

EntityRelation Class

EntityState Enumeration

EntitySyncInfo(TEntity) Class

EntityView(TEntity) Class

EntityView2(TEntity) Class

EntityViewBase(TEntity) Class

ExceptionInfoElement Enumeration

ExceptionInfoRetriever Class

ExcludeFieldsList Class

ExcludeIncludeFieldsList Class

ExOp Enumeration

Expression Class

ExpressionElement(T) Class

ExpressionElementType Enumeration

ExpressionFieldElement Class

ExtensionMethods Class

FastDeserializer Class

FastDictionary(TKey, TValue) Class

FastSerializer Class

FastSerializerSurrogate Class

FastSerializerSurrogateSelector Class

FetchNewAuthorizationFailureResultHint Enumeration

FieldBetweenPredicate Class

FieldCompareExpressionPredicate Class

FieldCompareNullPredicate Class

FieldCompareRangePredicate Class

FieldCompareSetPredicate Class

FieldCompareValuePredicate Class

FieldFullTextSearchPredicate Class

FieldInfo Class

FieldInfoProviderBase Class

FieldLikePredicate Class

FieldPersistenceInfo Class

FieldStateBucket Structure

FieldUtilities Class

FirebirdCompatibilityLevel Enumeration

FromClauseElementDirective Class

FromClauseElementDirectiveType Enumeration

FullTextSearchOperator Enumeration

FunctionMapping Class

FunctionMappingStore Class

GeneralUtils Class

GenericExpressionVisitor Class

GroupByCollection Class

GuidByteArrayConverter Class

GuidStringConverter Class

IActionQuery Interface

IActiveContextParticipant Interface

IAuditor Interface

IAuthorizer Interface

IByteCompressor Interface

IConcurrencyPredicateFactory Interface

IContextAwareElement Interface

IDataAccessAdapter Interface

IDataAccessCore Interface

IDataValueProjector Interface

IDbFunctionCall Interface

IDbSpecificCreator Interface

IDbSpecificHintCreator Interface

IDerivedTableDefinition Interface

IDynamicRelation Interface

IElementCreator Interface

IElementCreator2 Interface

IElementCreatorCore Interface

IEntity Interface

IEntity2 Interface

IEntityCollection Interface

IEntityCollection2 Interface

IEntityCollectionCore Interface

IEntityCore Interface

IEntityDataProjector Interface

IEntityFactory Interface

IEntityFactory2 Interface

IEntityFactoryCore Interface

IEntityField Interface

IEntityField2 Interface

IEntityFieldCore Interface

IEntityFieldCoreInterpret Interface

IEntityFields Interface

IEntityFields2 Interface

IEntityFieldsCore Interface

IEntityPropertyProjector Interface

IEntityRelation Interface

IEntityView Interface

IEntityView2 Interface

IEntityViewCore Interface

IExpression Interface

IExpressionElement Interface

IExpressionFieldElement Interface

IExpressionInterpret Interface

IFastSerializationTypeSurrogate Interface

IFieldInfo Interface

IFieldInfoProvider Interface

IFieldPersistenceInfo Interface

IGeneralDataProjector Interface

IGroupByCollection Interface

IInheritanceInfo Interface

IInheritanceInfoProvider Interface

IMemoryStreamByteCompressor Interface

IncludeFieldsList Class

IncludeInCompactXmlAttribute Class

InheritanceHierarchyType Enumeration

InheritanceInfo Class

InheritanceInfoProviderBase Class

Int16DecimalConverter Class

Int32DecimalConverter Class

Int64DecimalConverter Class

InterpretSetValueCallback Delegate

IOwnedDataSerializable Interface

IOwnedDataSerializableAndRecreatable Interface

IParameterFieldRelation Interface

IPersistenceInfoProvider Interface

IPredicate Interface

IPredicateExpression Interface

IPredicateExpressionElement Interface

IPredicateInterpret Interface

IPrefetchPath Interface

IPrefetchPath2 Interface

IPrefetchPathCore Interface

IPrefetchPathElement Interface

IPrefetchPathElement2 Interface

IPrefetchPathElementCore Interface

IProjector Interface

IPropertyDescriptorFactory Interface

IQuery Interface

IRelation Interface

IRelationCollection Interface

IRelationFactory Interface

IRelationPredicateBucket Interface

IResultsetCache Interface

IRetrievalQuery Interface

IScalarQueryExpression Interface

ISequenceRetrievalQuery Interface

ISortClause Interface

ISortExpression Interface

ITransaction Interface

ITransactionalElement Interface

ITransactionController Interface

ITypeDefaultValue Interface

ITypedListCore Interface

ITypedListLgp Interface

ITypedListLgp2 Interface

ITypedView Interface

ITypedView2 Interface

IUnitOfWorkCore Interface

IValidator Interface

IViewProjectionData Interface

JoinHint Enumeration

LLBLGenProDataSource Class

LLBLGenProDataSource2 Class

LLBLGenProDataSourceBase Class

LLBLGenProDataSourceDesigner Class

LLBLGenProDataSourceDesigner2 Class

LLBLGenProDataSourceView Class

LLBLGenProDataSourceView2 Class

LLBLGenProDataSourceViewBase Class

LLBLGenProDesignerDataSourceView Class

LLBLGenProDesignerDataSourceView2 Class

MemberOperator Enumeration

MemberPredicate Class

MergeableDictionary(TKey, TValue) Class

MultiValueDictionary(TKey, TValue) Class

MultiValueHashtable(TKey, TValue) Class

NavigatorAspectType Enumeration

NodeEntityReference Class

NumericValueOperatorExecutor Class

ObjectGraphUtils Class

OracleCompatibilityLevel Enumeration

ORMBadSequenceException Class

ORMConcurrencyException Class

ORMConfigurationException Class

ORMEntityIsDeletedException Class

ORMEntityOutOfSyncException Class

ORMEntityValidationException Class

ORMException Class

ORMFieldIsNullException Class

ORMFieldIsReadonlyException Class

ORMGeneralOperationException Class

ORMInheritanceInfoException Class

ORMInterpretationException Class

ORMInvalidFieldReadException Class

ORMLockTimeoutException Class

ORMQueryConstructionException Class

ORMQueryExecutionException Class

ORMRelationException Class

ORMSecurityException Class

ORMSerializationOptimizationException Class

ORMTransientRecoveryFailedException Class

ORMValueTypeMismatchException Class

ParameterFieldRelation Class

ParameterParameterRelation Class

ParameterValue Class

PerformGetDbCountEventArgs Class

PerformGetDbCountEventArgs2 Class

PerformSelectEventArgs Class

PerformSelectEventArgs2 Class

PerformWorkEventArgs Class

PerformWorkEventArgs2 Class

PersistenceCore Class

PersistenceInfoProviderBase Class

PlainSQLFetchAspects Class

PostCollectionChangeAction Enumeration

Predicate Class

PredicateExpression Class

PredicateExpressionElement Class

PredicateExpressionElementType Enumeration

PredicateExpressionOperator Enumeration

PredicateType Enumeration

PredicateWrapper Class

PrefetchPath Class

PrefetchPath2 Class

PrefetchPathElement Class

PrefetchPathElement2 Class

ProjectionLiteral Class

ProjectionRow Class

ProjectionRowProjectorFunc Delegate

ProjectionValueProducerFunc Delegate

QueryApiObjectTraverser Class

QueryFragments Class

QueryParameters Class

RdbmsHint Enumeration

RecoveryDelay Class

RecoveryStrategyBase Class

RecoveryStrategyDelayType Enumeration

ReferencedEntityMap Class

RelationCollection Class

RelationPredicateBucket Class

RelationType Enumeration

ResultsetCache Class

RetrievalQuery Class

RuntimeConfiguration Class

RuntimeConfiguration.EntityConfigMethods Class

RuntimeConfiguration.PrefetchPathConfigMethods Class

RuntimeConfiguration.TracingConfigMethods Class

RuntimeConfiguration.XmlConfigMethods Class

RuntimeLibraryVersion Structure

ScalarQueryExpression Class

ScaleOverflowCorrectionAction Enumeration

SchemaNameOverwriteHashtable Class

SchemaNameUsage Enumeration

SequenceRetrievalQuery Class

SerializationHelper Class

SerializationOptimization Enumeration

SerializationReader Class

SerializationUtils Class

SerializationWriter Class

SetOperator Enumeration

Setter Delegate

SimpleRetryRecoveryStrategy Class

SingleDecimalConverter Class

SingleStatementQueryAction Enumeration

SortClause Class

SortExpression Class

SortOperator Enumeration

SourceFieldFinder Class

SqlAzureRecoveryStrategy Class

SqlServerCompatibilityLevel Enumeration

StaticEntityFieldsDataContainer Class

StoredProcedureCall Class

StringBuilderCache Class

StringPlaceHolder Class

SystemTypeConverterBase(T) Class

TableValuedFunctionCall Class

TableValuedFunctionPersistenceInfo Class

TargetEntityFieldPersistenceInfoBucket Class

TemporalTablePredicateType Enumeration

TimedLock Structure

TraceHelper Class

TransactionBase Class

TransactionComPlusBase Class

TypeContainedAttribute Class

TypeConverterDataValueProjector Class

TypedListBase(T) Class

TypedListBase2(T) Class

TypedListCore Class

TypedViewBase(T) Class

UniqueList(T) Class

UniqueValueList(T) Class

UnitOfWork Class

UnitOfWork2 Class

UnitOfWorkBlockType Enumeration

UnitOfWorkCallBackElement Class

UnitOfWorkCallBackElement2 Class

UnitOfWorkCallBackScheduleSlot Enumeration

UnitOfWorkCollectionElement Class

UnitOfWorkCollectionElement2 Class

UnitOfWorkDeleteEntitiesDirectlyElement Class

UnitOfWorkElement Class

UnitOfWorkElement2 Class

UnitOfWorkUpdateEntitiesDirectlyElement Class

UnitOfWorkUpdateMultiElement Class

ValidatorBase Class

ValuePair(TValue1, TValue2) Class

ViewProjectionData(TEntity) Class

VolatileEntityFieldsDataContainer Class

WorkDataCollector Class

XmlExtensionMethods Class

XmlFormatAspect Enumeration

XmlHelper Class

Click or drag to resize

AggregateFunction Enumeration

Enum definition for the various aggregate functions which can be applied to fields in a retrieval query. Useful in typed lists. Use these in combination with a groupbycollection. Not all functions are legal on all fields. Some functions will produce errors when used with fields of a given type, like a Sum function with a character field. This is the responsibility of the developer. Aggregate functions are never applied to *lob fields.

Namespace: SD.LLBLGen.Pro.ORMSupportClasses
Assembly: SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.3.0.0 (5.3.0)

Syntax

public enum AggregateFunction

Public Enumeration AggregateFunction

Members

	Member name	Value	Description
	None	0	Default, do not apply an aggregate function to the field.
	Count	1	Calculates the amount of rows for the field. Results in COUNT(field)
	CountDistinct	2	Calculates the amount of rows with distinct values for field. Results in COUNT(DISTINCT field). Access, MySql: not supported
	CountRow	3	Calculates the amount of rows. Results in a COUNT(*)
	CountBig	4	Calculates the amount of rows for the field. Results in COUNT(field) and returns an Int64. SQL Server 2005+
	CountBigDistinct	5	Calculates the amount of rows with distinct values for field. Results in COUNT(DISTINCT field) and returns an Int64. SQL Server 2005+ Access, MySql: not supported
	CountBigRow	6	Calculates the amount of rows. Results in a COUNT(*) and returns an Int64. SQL Server 2005+
	Avg	7	Calculates the average value for the field. Results in an AVG(field)
	AvgDistinct	8	Calculates the average value for the distinct values for field. Results in an AVG(DISTINCT field). Access, MySql: not supported
	Max	9	Calculates the max value for field. Results in a MAX(field).
	Min	10	Calculates the min value for field. Results in a MIN(field)
	Sum	11	Calculates the sum of all values of field. Results in a SUM(field)
	SumDistinct	12	Calculates the sum of all distinct values of field. Results in a SUM(DISTINCT field). Access, MySql: not supported
	StDev	13	Calculates statistical standard deviation. Results in: SqlServer: STDEV(field) Oracle, MySql: STDDEV(field) Access: STDEV(field) Firebird: not supported
	StDevDistinct	14	Calculates statistical standard deviation over distinct values. Results in: SqlServer: not supported Oracle: STDDEV(DISTINCT field) Access, Firebird, MySql: not supported
	Variance	15	Calculates statistical variance. Results in: SqlServer: VAR(field) Oracle, MySql: VARIANCE(field) Access: VAR(field) Firebird: not supported.
	VarianceDistinct	16	Calculates statistical variance over distinct values. Results in: SqlServer: not supported Oracle: VARIANCE(DISTINCT field) Access, Firebird, MySql: not supported

See Also

Reference

SD.LLBLGen.Pro.ORMSupportClasses Namespace

(c)2002-2017 Solutions Design bv

Send comments on this topic to LLBLGen Pro v5.3 Runtime Framework Reference Documentation feedback