Link Search Menu Expand Document

Operation


This enum is used to set the value of the Operation property of QueryField object.

Enum Values

  • Equal (Default) = an equal operation.
  • NotEqual - a not-equal operation.
  • LessThan - a less-than operation.
  • GreaterThan - a greater-than operation.
  • LessThanOrEqual - a less-than-or-equal operation.
  • GreaterThanOrEqual - a greater-than-or-equal operation.
  • Like - a like operation. Defines the LIKE keyword in SQL statement.
  • NotLike - a not-like operation. Defines the NOT LIKE keyword in SQL statement.
  • Between - a between operation. Defines the BETWEEN keyword in SQL statement.
  • NotBetween - a not-between operation. Defines the NOT BETWEEN keyword in SQL statement.
  • In - an in operation. Defines the IN keyword in SQL statement.
  • NotIn - a not-in operation. Defines the NOT IN keyword in SQL statement.

Usability

Simply pass the value of when instantiating the QueryField object.

var field = new QueryField("Id", Operation.Equal, 10045);

Type of Operation

Equal

Part of the expression tree used to determine the equality of the field and data.

var result = connection.Query<Customer>(new QueryField("Id", Operation.Equal, 10045));

NotEqual

Part of the expression tree used to determine the inequality of the field and data.

var result = connection.Query<Customer>(new QueryField("Name", Operation.NotEqual, "Anna Fullerton" });

LessThan

Part of the expression tree used to determine whether the field value is less-than of the defined value.

var result = connection.Query<Customer>(new QueryField("Id", Operation.LessThan, 100 });

GreaterThan

Part of the expression tree used to determine whether the field value is greater-than of the defined value.

var result = connection.Query<Customer>(new QueryField("Id", Operation.GreaterThan, 0 });

LessThanOrEqual

Part of the expression tree used to determine whether the field value is less-than-or-equal of the defined value.

var result = connection.Query<Customer>.Query(new QueryField("Id", Operation.LessThanOrEqual, 100 });

GreaterThanOrEqual

Part of the expression tree used to determine whether the field value is greater-than-or-equal of the defined value.

var result = connection.Query<Customer>(new QueryField("Id", Operation.GreaterThanOrEqual, 0 });

Like

Part of the expression tree used to determine whether the field is identitical to a given value.

var result = connection.Query<Customer>(new QueryField("Name", Operation.Like, "Anna%" });

NotLike

Part of the expression tree used to determine whether the field is not-identitical to a given value.

var result = connection.Query<Customer>(new QueryField("Name", Operation.NotLike, "Anna%" });

Between

Part of the expression tree used to determine whether the field value is in-between the given 2 values.

var result = connection.Query<Customer>(new QueryField("Id", Operation.Between, new [] { 10045, 10075 } });

NotBetween

Part of the expression tree used to determine whether the field value is not-in-between of the given 2 values.

var result = connection.Query<Customer>(new QueryField("Id", Operation.NotBetween, new [] { 10045, 10075 } });

In

Part of the expression tree used to determine whether the field value is in the given values.

var result = connection.Query<Customer>(new QueryField("Id", Operation.In, new [] { 10045, 10046, 10047, 10048 } });

NotIn

Part of the expression tree used to determine whether the field value is not-in given values.

var result = connection.Query<Customer>(new QueryField("Id", Operation.NotIn, new [] { 10045, 10046, 10047, 10048 } });