Session.Evaluate<ClassType>(CriteriaOperator, CriteriaOperator) Method

Evaluates the specified expression for objects of the type designated by the specified generic type parameter.

Namespace: DevExpress.Xpo

Assembly: DevExpress.Xpo.v24.1.dll

NuGet Packages: DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap, DevExpress.Xpo

NuGet Package: DevExpress.Xpo

Declaration

C#

public object Evaluate<ClassType>(
    CriteriaOperator expression,
    CriteriaOperator criteria
)

VB.NET

Public Function Evaluate(Of ClassType)(
    expression As CriteriaOperator,
    criteria As CriteriaOperator
) As Object

Parameters

Name	Type	Description
expression	CriteriaOperator	A CriteriaOperator object that specifies the expression to be evaluated.
criteria	CriteriaOperator	A CriteriaOperator object that specifies the filter criteria. The objects that match this criteria are used to evaluate the expression.

Type Parameters

Name	Description
ClassType	The type of objects against which the expression is evaluated.

Returns

Type	Description
Object	The evaluated value.

Remarks

Use this method to evaluate a specific expression against specific objects. In the expression that is specified by the expression parameter you can use the functions specified by the Aggregate enumeration and you can also use a combination of these functions.

For example, you can use the Count() function to calculate the number of objects specified.

The criteria parameter specifies the criteria used for object selection. The expression is evaluated only against the objects that match these criteria. Set the criteria to null (Nothing in VB.NET) to evaluate the expression against all the objects in the data store.

To construct the expression and criteria, use the static CriteriaOperator.Parse method. The method takes a string representation of the required expression and retrieves a CriteriaOperator object that corresponds to this expression.

The following code snippet demonstrates how to calculate the sum of orders paid within the last ten days:

C#

using DevExpress.Data.Filtering;

//...

decimal sumPaid = (decimal)session.Evaluate<Order>(CriteriaOperator.Parse("Sum(OrderTotals)"), 
    new BinaryOperator("OrderDate", DateTime.Today.AddDays(-10), BinaryOperatorType.Greater));

VB.NET

Imports DevExpress.Data.Filtering

'...

Private sumPaid As Decimal = CDec(session.Evaluate(Of Order)(CriteriaOperator.Parse( _
"Sum(OrderTotals)"), _
New BinaryOperator("OrderDate", DateTime.Today.AddDays(-10), BinaryOperatorType.Greater)))

Note that direct type casting may fail, since the Evaluate can return null (Nothing in VB).

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Evaluate<ClassType>(CriteriaOperator, CriteriaOperator) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

CriteriaOperatorsCheatSheet/CS/CriteriaOperatorCheatSheet/Tests/Aggregate_Count.cs#L20

    CriteriaOperator.Parse("Count()");
var result = uow.Evaluate<Order>(criterion, null);
Assert.AreEqual(2, result);

XPO_how-to-use-custom-sql-queries-as-a-data-source-in-xpo-via-common-table-expressions-cte-e3468/CS/S138124/Program.cs#L29

Console.WriteLine("=== Count for sine CTE ===");
Console.WriteLine("Count: {0}", uow.Evaluate<CteStructure_1>(new AggregateOperand(null, null, Aggregate.Count, null), null));
Console.WriteLine("=== Filtered count for sine CTE ===");

XPO_how-to-get-the-maximum-or-minimum-objects-value-from-a-collection-e468/CS/ConsoleApplication1/Program.cs#L22

int maxValue = Convert.ToInt32(
    Session.DefaultSession.Evaluate<QuoteItem>(
        CriteriaOperator.Parse("Max(Sequence)"),