SQLProvider

CanonicalOp Type

Union cases

Union case Description

ACos

Full Usage: ACos

ASin

Full Usage: ASin

ATan

Full Usage: ATan

Abs

Full Usage: Abs

AddDays SqlItemOrColumn

Full Usage: AddDays SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

AddHours float

Full Usage: AddHours float

Parameters:
    Item : float

Item : float

AddMinutes SqlItemOrColumn

Full Usage: AddMinutes SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

AddMonths int

Full Usage: AddMonths int

Parameters:
    Item : int

Item : int

AddSeconds float

Full Usage: AddSeconds float

Parameters:
    Item : float

Item : float

AddYears SqlItemOrColumn

Full Usage: AddYears SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

BasicMath(string, obj)

Full Usage: BasicMath(string, obj)

Parameters:
    Item1 : string
    Item2 : obj

Item1 : string
Item2 : obj

BasicMathLeft(string, obj)

Full Usage: BasicMathLeft(string, obj)

Parameters:
    Item1 : string
    Item2 : obj

Item1 : string
Item2 : obj

BasicMathOfColumns(string, string, SqlColumnType)

Full Usage: BasicMathOfColumns(string, string, SqlColumnType)

Parameters:
Item1 : string
Item2 : string
Item3 : SqlColumnType

CaseNotSql(Condition, SqlItemOrColumn)

Full Usage: CaseNotSql(Condition, SqlItemOrColumn)

Parameters:
Item1 : Condition
Item2 : SqlItemOrColumn

CaseSql(Condition, SqlItemOrColumn)

Full Usage: CaseSql(Condition, SqlItemOrColumn)

Parameters:
Item1 : Condition
Item2 : SqlItemOrColumn

CaseSqlPlain(Condition, obj, obj)

Full Usage: CaseSqlPlain(Condition, obj, obj)

Parameters:
Item1 : Condition
Item2 : obj
Item3 : obj

CastInt

Full Usage: CastInt

CastVarchar

Full Usage: CastVarchar

Ceil

Full Usage: Ceil

Cos

Full Usage: Cos

Date

Full Usage: Date

DateDiffDays SqlItemOrColumn

Full Usage: DateDiffDays SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

DateDiffSecs SqlItemOrColumn

Full Usage: DateDiffSecs SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

Day

Full Usage: Day

Floor

Full Usage: Floor

Greatest SqlItemOrColumn

Full Usage: Greatest SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

Hour

Full Usage: Hour

IndexOf SqlItemOrColumn

Full Usage: IndexOf SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn
Item1 : SqlItemOrColumn
Item2 : SqlItemOrColumn

Least SqlItemOrColumn

Full Usage: Least SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

Length

Full Usage: Length

Minute

Full Usage: Minute

Month

Full Usage: Month

Pow SqlItemOrColumn

Full Usage: Pow SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn

PowConst SqlItemOrColumn

Full Usage: PowConst SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn
Item1 : SqlItemOrColumn
Item2 : SqlItemOrColumn

Round

Full Usage: Round

RoundDecimals int

Full Usage: RoundDecimals int

Parameters:
    Item : int

Item : int

Second

Full Usage: Second

Sin

Full Usage: Sin

Sqrt

Full Usage: Sqrt

Substring SqlItemOrColumn

Full Usage: Substring SqlItemOrColumn

Parameters:
Item : SqlItemOrColumn
Item1 : SqlItemOrColumn
Item2 : SqlItemOrColumn

Tan

Full Usage: Tan

ToLower

Full Usage: ToLower

ToUpper

Full Usage: ToUpper

Trim

Full Usage: Trim

Truncate

Full Usage: Truncate

Year

Full Usage: Year

Instance members

Instance member Description

this.IsACos

Full Usage: this.IsACos

Returns: bool
Returns: bool

this.IsASin

Full Usage: this.IsASin

Returns: bool
Returns: bool

this.IsATan

Full Usage: this.IsATan

Returns: bool
Returns: bool

this.IsAbs

Full Usage: this.IsAbs

Returns: bool
Returns: bool

this.IsAddDays

Full Usage: this.IsAddDays

Returns: bool
Returns: bool

this.IsAddHours

Full Usage: this.IsAddHours

Returns: bool
Returns: bool

this.IsAddMinutes

Full Usage: this.IsAddMinutes

Returns: bool
Returns: bool

this.IsAddMonths

Full Usage: this.IsAddMonths

Returns: bool
Returns: bool

this.IsAddSeconds

Full Usage: this.IsAddSeconds

Returns: bool
Returns: bool

this.IsAddYears

Full Usage: this.IsAddYears

Returns: bool
Returns: bool

this.IsBasicMath

Full Usage: this.IsBasicMath

Returns: bool
Returns: bool

this.IsBasicMathLeft

Full Usage: this.IsBasicMathLeft

Returns: bool
Returns: bool

this.IsBasicMathOfColumns

Full Usage: this.IsBasicMathOfColumns

Returns: bool
Returns: bool

this.IsCaseNotSql

Full Usage: this.IsCaseNotSql

Returns: bool
Returns: bool

this.IsCaseSql

Full Usage: this.IsCaseSql

Returns: bool
Returns: bool

this.IsCaseSqlPlain

Full Usage: this.IsCaseSqlPlain

Returns: bool
Returns: bool

this.IsCastInt

Full Usage: this.IsCastInt

Returns: bool
Returns: bool

this.IsCastVarchar

Full Usage: this.IsCastVarchar

Returns: bool
Returns: bool

this.IsCeil

Full Usage: this.IsCeil

Returns: bool
Returns: bool

this.IsCos

Full Usage: this.IsCos

Returns: bool
Returns: bool

this.IsDate

Full Usage: this.IsDate

Returns: bool
Returns: bool

this.IsDateDiffDays

Full Usage: this.IsDateDiffDays

Returns: bool
Returns: bool

this.IsDateDiffSecs

Full Usage: this.IsDateDiffSecs

Returns: bool
Returns: bool

this.IsDay

Full Usage: this.IsDay

Returns: bool
Returns: bool

this.IsFloor

Full Usage: this.IsFloor

Returns: bool
Returns: bool

this.IsGreatest

Full Usage: this.IsGreatest

Returns: bool
Returns: bool

this.IsHour

Full Usage: this.IsHour

Returns: bool
Returns: bool

this.IsIndexOf

Full Usage: this.IsIndexOf

Returns: bool
Returns: bool

this.IsIndexOfStart

Full Usage: this.IsIndexOfStart

Returns: bool
Returns: bool

this.IsLeast

Full Usage: this.IsLeast

Returns: bool
Returns: bool

this.IsLength

Full Usage: this.IsLength

Returns: bool
Returns: bool

this.IsMinute

Full Usage: this.IsMinute

Returns: bool
Returns: bool

this.IsMonth

Full Usage: this.IsMonth

Returns: bool
Returns: bool

this.IsPow

Full Usage: this.IsPow

Returns: bool
Returns: bool

this.IsPowConst

Full Usage: this.IsPowConst

Returns: bool
Returns: bool

this.IsReplace

Full Usage: this.IsReplace

Returns: bool
Returns: bool

this.IsRound

Full Usage: this.IsRound

Returns: bool
Returns: bool

this.IsRoundDecimals

Full Usage: this.IsRoundDecimals

Returns: bool
Returns: bool

this.IsSecond

Full Usage: this.IsSecond

Returns: bool
Returns: bool

this.IsSin

Full Usage: this.IsSin

Returns: bool
Returns: bool

this.IsSqrt

Full Usage: this.IsSqrt

Returns: bool
Returns: bool

this.IsSubstring

Full Usage: this.IsSubstring

Returns: bool
Returns: bool

this.IsSubstringWithLength

Full Usage: this.IsSubstringWithLength

Returns: bool
Returns: bool

this.IsTan

Full Usage: this.IsTan

Returns: bool
Returns: bool

this.IsToLower

Full Usage: this.IsToLower

Returns: bool
Returns: bool

this.IsToUpper

Full Usage: this.IsToUpper

Returns: bool
Returns: bool

this.IsTrim

Full Usage: this.IsTrim

Returns: bool
Returns: bool

this.IsTruncate

Full Usage: this.IsTruncate

Returns: bool
Returns: bool

this.IsYear

Full Usage: this.IsYear

Returns: bool
Returns: bool

Type something to start searching.