Performs a database calculation such as COUNT, SUM or AVG.

Namespace:  Mindscape.LightSpeed
Assembly:  Mindscape.LightSpeed (in Mindscape.LightSpeed.dll)
Version: 4.0.0.0 (4.0.0.0)

Syntax

C#
Object Calculate<TEntity>(
	string calculation,
	string attribute,
	Query query
) where TEntity : Entity
Visual Basic (Declaration)
Function Calculate(Of TEntity As Entity) ( _
	calculation As String, _
	attribute As String, _
	query As Query _
) As Object

Parameters

calculation
Type: System..::.String
A SQL fragment representing the target calculation function. E.g. "SUM".
attribute
Type: System..::.String
The target attribute.
query
Type: Mindscape.LightSpeed.Querying..::.Query
A Query.

Type Parameters

TEntity
The entity type.

Return Value

The result of the calculation.

Examples

CopyC#
Query query = new Query(Entity.Attribute("OrderId") == 101);
int sumOfPricesInOrder101 = (int)(unitOfWork.Calculate<Product>("SUM", "Price", query));

See Also