Search Results for

    Show / Hide Table of Contents

    Enum SQLOperator

    Defines the list of possible SQL operators.

    Namespace: LemonEdge.Utils.Database
    Assembly: LemonEdge.Utils.dll
    Syntax
    public enum SQLOperator : short
    Remarks

    Maps directly to telerik filter operators

    Fields

    Name Description
    Contains

    xxx Like '%yyy%'

    DoesNotContain

    not(xxx Like '%yyy%')

    EndsWith

    xxx Like '%yyy'

    Equals

    ==

    GreaterThan
    GreaterThanOrEqualTo

    =

    IsContainedIn

    is in ([])

    IsEmpty

    == null

    IsNotContainedIn

    is not in ([])

    IsNotEmpty

    != null

    IsNotNull

    != null

    IsNull

    == null

    LessThan

    $lt;

    LessThanOrEqualsTo

    <=

    NotEquals

    !=

    StartsWith

    xxx Like 'yyy%'

    Extension Methods

    SQLExtensions.ToSQLStatement(SQLOperator, string, string)
    EnumHelper.GetShortFlaggedValues<SQLOperator>(SQLOperator)
    EnumHelper.ToShortGuid<SQLOperator>(SQLOperator)
    LinqExtensions.AsArray<SQLOperator>(SQLOperator)
    LinqExtensions.ToArrayOfOne<SQLOperator>(SQLOperator)
    LinqExtensions.ToListOfOne<SQLOperator>(SQLOperator)
    MiscExtensions.SetIfNotEqual<SQLOperator, TP>(SQLOperator, Expression<Func<SQLOperator, TP>>, TP)
    ReflectionExtensions.GetEnumValueCustomAttributes<AttrType, SQLOperator>(SQLOperator)
    SQLExtensions.ToSQLValue(object, bool)
    ReflectionExtensions.ClearEventInvocations(object, string)
    StringExtensions.ToCSVFormatString(object, Type)
    In this article
    Back to top © LemonEdge Technologies. All rights reserved.