Enum FilterOperators

Specifies the available filter operators for use in SQL WHERE clauses.

public enum FilterOperators

Extension Methods: EnumExtensions.IsAnyFlagOn<T>(Enum, T)

EnumExtensions.IsFlagOn<T>(Enum, T)

EnumExtensions.SetFlagOff<T>(Enum, T)

EnumExtensions.SetFlagOn<T>(Enum, T)

EnumExtensions.ToggleFlag<T>(Enum, T)

Fields

Contains = 2: Checks if the column value contains the specified value. Corresponds to the SQL LIKE '%value%' pattern.
EndsWith = 1: Checks if the column value ends with the specified value. Corresponds to the SQL LIKE '%value' pattern.
Equal = 3: Checks if the column value is equal to the specified value. Corresponds to the SQL = operator.
GreaterThan = 7: Checks if the column value is greater than the specified value. Corresponds to the SQL > operator.
GreaterThanOrEqual = 8: Checks if the column value is greater than or equal to the specified value. Corresponds to the SQL >= operator.
In = 11: Checks if the column value is in the specified set of values. Corresponds to the SQL IN operator.
IsNotNull = 10: Checks if the column value is not null. Corresponds to the SQL IS NOT NULL operator.
IsNull = 9: Checks if the column value is null. Corresponds to the SQL IS NULL operator.
LessThan = 5: Checks if the column value is less than the specified value. Corresponds to the SQL < operator.
LessThanOrEqual = 6: Checks if the column value is less than or equal to the specified value. Corresponds to the SQL <= operator.
NotEqual = 4: Checks if the column value is not equal to the specified value. Corresponds to the SQL <> or != operator.
StartsWith = 0: Checks if the column value starts with the specified value. Corresponds to the SQL LIKE 'value%' pattern.