ConstantValue Class

A constant value operand in criteria expressions.

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v18.1.dll

Declaration

C#

public class ConstantValue :
    OperandValue

VB.NET

Public Class ConstantValue
    Inherits OperandValue

Related API Members

The following members accept/return ConstantValue objects:

• ConstantValue.Clone()

Remarks

Normally, criteria value operands (OperandValue objects) are automatically passed as standard parameters to the resulting SQL queries, generated based on criteria expressions. The ConstantValue allows you to embed in-line parameters into the resulting SQL queries. With in-line parameters, you can improve performance when executing a number of SQL queries with matching constants passed as parameters. To accomplish this, replace OperandValue with ConstantValue in your criteria expression as shown below.

Examples

C#

CriteriaOperator filter = new BinaryOperator(new OperandProperty("LastName"), 
    new ConstantValue("Smith"), BinaryOperatorType.Equal);

VB.NET

Dim filter As CriteriaOperator = New BinaryOperator(New OperandProperty("LastName"), _
New ConstantValue("Smith"), BinaryOperatorType.Equal)

The CriteriaOperator.Parse method automatically translates constant operand values to ConstantValue counterparts. So, the following line produces the same criteria.

C#

CriteriaOperator filter = CriteriaOperator.Parse("LastName = 'Smith'");

VB.NET

Dim filter As CriteriaOperator = CriteriaOperator.Parse("LastName = 'Smith'")

If you pass constant operand values using positional parameters (see the corresponding section in Criteria Language Syntax), they are translated, as usual, to OperandValue objects, not ConstantValue objects. The following code will produce criteria with normal query parameters, rather than in-line.

C#

CriteriaOperator filter = CriteriaOperator.Parse("LastName = ?, "Smith");

VB.NET

Dim filter As CriteriaOperator = CriteriaOperator.Parse("LastName = ?, "Smith")

 

Note

In-line parameters are supported for Int32, Boolean, String, and Enum operand values.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ConstantValue class.

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#

how-to-apply-filtering-to-a-dashboard-items-data-in-olap-mode-e5148/CS/Dashboard_OlapFiltering/Form1.cs#L34

new NotOperator(new InOperator(new OperandProperty(fieldYearName),
                               new ConstantValue[] { new ConstantValue(year2001),
                                                     new ConstantValue(year2002)

aspxdashboard-how-to-apply-filtering-to-a-dashboard-items-data-in-olap-mode-t481105/CS/ASPxDashboard_OlapFiltering/WebForm1.aspx.cs#L36

new NotOperator(new InOperator(new OperandProperty(fieldYearName),
                               new ConstantValue[] { new ConstantValue(year2001),
                                                     new ConstantValue(year2002)

web-dashboard-apply-item-filtering-olap-mode/CS/ASPxDashboard_OlapFiltering/WebForm1.aspx.cs#L36

new NotOperator(new InOperator(new OperandProperty(fieldYearName),
                               new ConstantValue[] { new ConstantValue(year2001),
                                                     new ConstantValue(year2002)

how-to-make-the-auto-filter-rows-filter-accent-insensitive-e5021/CS/DxSample/Filtering/GridFilterSubstitutor.cs#L7

    return new FunctionOperator(FunctionOperatorType.Custom,
        new ConstantValue("RemoveDiacritics"), (CriteriaOperator)param);
}

VB.NET

how-to-apply-filtering-to-a-dashboard-items-data-in-olap-mode-e5148/VB/Dashboard_OlapFiltering/Form1.vb#L37

New NotOperator(New InOperator(New OperandProperty(fieldYearName), _
                               New ConstantValue() {New ConstantValue(year2001), _
                                                    New ConstantValue(year2002)})))

aspxdashboard-how-to-apply-filtering-to-a-dashboard-items-data-in-olap-mode-t481105/VB/ASPxDashboard_OlapFiltering/WebForm1.aspx.vb#L37

New NotOperator(New InOperator(New OperandProperty(fieldYearName),
                               New ConstantValue() {New ConstantValue(year2001),
                                                    New ConstantValue(year2002)})))

web-dashboard-apply-item-filtering-olap-mode/VB/ASPxDashboard_OlapFiltering/WebForm1.aspx.vb#L37

New NotOperator(New InOperator(New OperandProperty(fieldYearName),
                               New ConstantValue() {New ConstantValue(year2001),
                                                    New ConstantValue(year2002)})))

how-to-make-the-auto-filter-rows-filter-accent-insensitive-e5021/VB/DxSample/Filtering/GridFilterSubstitutor.vb#L8

Private Shared Function WrapIntoCustomFunction(ByVal param As CriteriaOperator) As CriteriaOperator
    Return New FunctionOperator(FunctionOperatorType.Custom, New ConstantValue("RemoveDiacritics"), CType(param, CriteriaOperator))
End Function

Inheritance

Object

CriteriaOperator

OperandValue

ConstantValue