SQLProvider

ConditionOperator Type

Namespace: FSharp.Data.Sql
Assembly: FSharp.Data.SqlProvider.Common.dll
Base Type: ValueType
All Interfaces: IEquatable<ConditionOperator> , IStructuralEquatable , IComparable<ConditionOperator> , IComparable , IStructuralComparable
Kind: Struct

Represents SQL conditional operators used in WHERE clauses and query expressions. These operators are translated to their SQL equivalents when building database queries.

Union cases

Union case	Description
`Equal` Full Usage: `Equal`	SQL equality operator (=)
`GreaterEqual` Full Usage: `GreaterEqual`	SQL greater than or equal operator (>=)
`GreaterThan` Full Usage: `GreaterThan`	SQL greater than operator (>)
`In` Full Usage: `In`	SQL IN operator for membership testing
`IsNull` Full Usage: `IsNull`	SQL IS NULL operator for checking null values
`LessEqual` Full Usage: `LessEqual`	SQL less than or equal operator (<=)
`LessThan` Full Usage: `LessThan`	SQL less than operator (<)
`Like` Full Usage: `Like`	SQL LIKE operator for pattern matching with wildcards
`NestedExists` Full Usage: `NestedExists`	SQL EXISTS operator for subquery existence testing
`NestedIn` Full Usage: `NestedIn`	SQL IN operator for nested subqueries
`NestedNotExists` Full Usage: `NestedNotExists`	SQL NOT EXISTS operator for negated subquery existence testing
`NestedNotIn` Full Usage: `NestedNotIn`	SQL NOT IN operator for negated nested subqueries
`NotEqual` Full Usage: `NotEqual`	SQL inequality operator (<>)
`NotIn` Full Usage: `NotIn`	SQL NOT IN operator for negated membership testing
`NotLike` Full Usage: `NotLike`	SQL NOT LIKE operator for negated pattern matching
`NotNull` Full Usage: `NotNull`	SQL IS NOT NULL operator for checking non-null values

Instance members

Instance member	Description
`this.IsEqual` Full Usage: `this.IsEqual` Returns: `bool`	Returns: `bool`
`this.IsGreaterEqual` Full Usage: `this.IsGreaterEqual` Returns: `bool`	Returns: `bool`
`this.IsGreaterThan` Full Usage: `this.IsGreaterThan` Returns: `bool`	Returns: `bool`
`this.IsIn` Full Usage: `this.IsIn` Returns: `bool`	Returns: `bool`
`this.IsIsNull` Full Usage: `this.IsIsNull` Returns: `bool`	Returns: `bool`
`this.IsLessEqual` Full Usage: `this.IsLessEqual` Returns: `bool`	Returns: `bool`
`this.IsLessThan` Full Usage: `this.IsLessThan` Returns: `bool`	Returns: `bool`
`this.IsLike` Full Usage: `this.IsLike` Returns: `bool`	Returns: `bool`
`this.IsNestedExists` Full Usage: `this.IsNestedExists` Returns: `bool`	Returns: `bool`
`this.IsNestedIn` Full Usage: `this.IsNestedIn` Returns: `bool`	Returns: `bool`
`this.IsNestedNotExists` Full Usage: `this.IsNestedNotExists` Returns: `bool`	Returns: `bool`
`this.IsNestedNotIn` Full Usage: `this.IsNestedNotIn` Returns: `bool`	Returns: `bool`
`this.IsNotEqual` Full Usage: `this.IsNotEqual` Returns: `bool`	Returns: `bool`
`this.IsNotIn` Full Usage: `this.IsNotIn` Returns: `bool`	Returns: `bool`
`this.IsNotLike` Full Usage: `this.IsNotLike` Returns: `bool`	Returns: `bool`
`this.IsNotNull` Full Usage: `this.IsNotNull` Returns: `bool`	Returns: `bool`