Operation

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

Below is the list of enum values.

Name	Description
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.

Simply pass the value of when instantiating the QueryField object.

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

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));

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" });

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 });

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 });

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 });

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 });

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%" });

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%" });

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 } });

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 } });

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 } });

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 } });