OrmComparisonOperator

Description

The OrmComparisonOperator enumeration contains types of comparison operator.

It is used by the following properties:

Value	Brief description
0	None. None.
1	Equal. Equal.
2	NotEqual. Not equal.
3	NotLike. Not equal (comparison by mask).
4	Like. Equal (comparison by mask).
5	Greater. Greater.
6	GreaterOrEqual. Greater or equal.
7	Less. Less.
8	LessOrEqual. Less or equal.
9	In_. Indicates whether attribute value is in the specified array of values. Comparison is executed if attribute contains a single value.
10	NotIn. Indicates whether attribute value is not in the specified array of values. Comparison is executed if attribute contains a single value.
11	Exists. Exists.
12	NotExists. Does not exist.
13	InSelect. Selected.
14	NotInSelect. Not selected.
15	Conditions. Conditions. If this type of operator is used, use IOrmCondition.Nested to create nested conditions.
16	NotConditions. No condition. If this type of operator is used, use IOrmCondition.Nested to create nested conditions.
17	IsNull. Null.
18	IsNotNull. Not null.
20	InQuery. Subquery. It enables the user to create a custom subquery as an SQL string that will be added to the main query condition.
256	Join. Join.
257	JoinEqual. Equal join.
261	JoinGreater. Greater join.
512	FreeText. Free text search. If the FreeText operator is set in the ORM condition, the attribute value is checked with the IComparerClass.FreeTextComparer.Compare (IComparerClass.FreeTextComparer).
1024	MatchCase. Match case.
2048	WholeWord. Match whole word.