DataViewExpression Class

Specifies a data view column name and expression used to compute the column value.

Namespace: DevExpress.ExpressApp.Utils

Assembly: DevExpress.ExpressApp.v24.1.dll

NuGet Package: DevExpress.ExpressApp

Declaration

C#

public class DataViewExpression

VB.NET

Public Class DataViewExpression

Related API Members

The following members return DataViewExpression objects:

• XafDataView.FindExpression(String)

Remarks

Use this class when it is required to create a list of data records retrieved from a database without loading complete business classes (a data view). Values in each data record can be obtained from specific business class properties directly, or be evaluated by the database server using complex expressions. The IList<DataViewExpression> list can be passed to the IObjectSpace.CreateDataView method, XafDataView constructor or XafDataView.Expressions property.

C#

List<DataViewExpression> dataViewExpressions = new List<DataViewExpression>();
dataViewExpressions.Add(
    new DataViewExpression("ID", new OperandProperty("ID")));
dataViewExpressions.Add(new DataViewExpression(
    "Name.UpperCase", new FunctionOperator(FunctionOperatorType.Upper, new OperandProperty("Name"))));
dataViewExpressions.Add(new DataViewExpression(
    "Count", new AggregateOperand("Sales", Aggregate.Count)));
var dataView = objectSpace.CreateDataView(typeof(Sale), dataViewExpressions, null, null);

VB.NET

Dim dataViewExpressions As New List(Of DataViewExpression)()
dataViewExpressions.Add(New DataViewExpression( _
"ID", New OperandProperty("ID")))
dataViewExpressions.Add(New DataViewExpression( _
"Name.UpperCase", New FunctionOperator(FunctionOperatorType.Upper, New OperandProperty("Name"))))
dataViewExpressions.Add(New DataViewExpression( _
"Count", New AggregateOperand("Sales", Aggregate.Count)))
Dim dataView = objectSpace.CreateDataView(GetType(Sale), dataViewExpressions, Nothing, Nothing)

Inheritance

Object

DataViewExpression