Enumerations · 3 min read

Operation

A enumeration that defines the different operations that can be used when composing a query expression.

This enum sets the Operation property of a QueryField object.

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.

Pass the value when instantiating a QueryField object.

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

Determines equality between the field and the specified value.

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

Determines inequality between the field and the specified value.

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

Determines whether the field value is less than the specified value.

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

Determines whether the field value is greater than the specified value.

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

Determines whether the field value is less than or equal to the specified value.

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

Determines whether the field value is greater than or equal to the specified value.

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

Determines whether the field matches a given pattern.

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

Determines whether the field does not match a given pattern.

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

Determines whether the field value falls between two specified values.

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

Determines whether the field value does not fall between two specified values.

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

Determines whether the field value is present in a set of values.

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

Determines whether the field value is absent from a set of values.

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