SQLProvider

CanonicalOp Type

Represents SQL functions and operations that can be applied to columns. These operations are translated to database-specific SQL functions.

Union cases

Union case Description

ACos

Full Usage: ACos

Returns the arccosine of a number

ASin

Full Usage: ASin

Returns the arcsine of a number

ATan

Full Usage: ATan

Returns the arctangent of a number

Abs

Full Usage: Abs

Returns the absolute value of a number

AddDays SqlItemOrColumn

Full Usage: AddDays SqlItemOrColumn

Parameters:

Adds the specified number of days to a datetime value

Item : SqlItemOrColumn

AddHours float

Full Usage: AddHours float

Parameters:
    Item : float

Adds the specified number of hours to a datetime value

Item : float

AddMinutes SqlItemOrColumn

Full Usage: AddMinutes SqlItemOrColumn

Parameters:

Adds the specified number of minutes to a datetime value

Item : SqlItemOrColumn

AddMonths int

Full Usage: AddMonths int

Parameters:
    Item : int

Adds the specified number of months to a datetime value

Item : int

AddSeconds float

Full Usage: AddSeconds float

Parameters:
    Item : float

Adds the specified number of seconds to a datetime value

Item : float

AddYears SqlItemOrColumn

Full Usage: AddYears SqlItemOrColumn

Parameters:

Adds the specified number of years to a datetime value

Item : SqlItemOrColumn

BasicMath(string, obj)

Full Usage: BasicMath(string, obj)

Parameters:
    Item1 : string
    Item2 : obj

Basic mathematical operation with a constant value

Item1 : string
Item2 : obj

BasicMathLeft(string, obj)

Full Usage: BasicMathLeft(string, obj)

Parameters:
    Item1 : string
    Item2 : obj

Left-side basic mathematical operation with a constant value

Item1 : string
Item2 : obj

BasicMathOfColumns(string, string, SqlColumnType)

Full Usage: BasicMathOfColumns(string, string, SqlColumnType)

Parameters:

Basic mathematical operation between columns

Item1 : string
Item2 : string
Item3 : SqlColumnType

CaseNotSql(Condition, SqlItemOrColumn)

Full Usage: CaseNotSql(Condition, SqlItemOrColumn)

Parameters:

SQL CASE expression with negated condition and true value

Item1 : Condition
Item2 : SqlItemOrColumn

CaseSql(Condition, SqlItemOrColumn)

Full Usage: CaseSql(Condition, SqlItemOrColumn)

Parameters:

SQL CASE expression with condition and false value

Item1 : Condition
Item2 : SqlItemOrColumn

CaseSqlPlain(Condition, obj, obj)

Full Usage: CaseSqlPlain(Condition, obj, obj)

Parameters:

SQL CASE expression with condition and two constant values

Item1 : Condition
Item2 : obj
Item3 : obj

CastInt

Full Usage: CastInt

Casts a value to INTEGER type

CastVarchar

Full Usage: CastVarchar

Casts a value to VARCHAR type

Ceil

Full Usage: Ceil

Returns the smallest integer greater than or equal to a number (ceiling)

Cos

Full Usage: Cos

Returns the cosine of an angle (in radians)

Date

Full Usage: Date

Extracts the date part from a datetime value

DateDiffDays SqlItemOrColumn

Full Usage: DateDiffDays SqlItemOrColumn

Parameters:

Calculates the difference in days between two datetime values

Item : SqlItemOrColumn

DateDiffSecs SqlItemOrColumn

Full Usage: DateDiffSecs SqlItemOrColumn

Parameters:

Calculates the difference in seconds between two datetime values

Item : SqlItemOrColumn

Day

Full Usage: Day

Extracts the day from a datetime value

Floor

Full Usage: Floor

Returns the largest integer less than or equal to a number (floor)

Greatest SqlItemOrColumn

Full Usage: Greatest SqlItemOrColumn

Parameters:

Returns the greatest value among the provided arguments

Item : SqlItemOrColumn

Hour

Full Usage: Hour

Extracts the hour from a datetime value

IndexOf SqlItemOrColumn

Full Usage: IndexOf SqlItemOrColumn

Parameters:

Returns the index of the first occurrence of a substring

Item : SqlItemOrColumn

Returns the index of a substring starting from a specified position

Item1 : SqlItemOrColumn
Item2 : SqlItemOrColumn

Least SqlItemOrColumn

Full Usage: Least SqlItemOrColumn

Parameters:

Returns the smallest value among the provided arguments

Item : SqlItemOrColumn

Length

Full Usage: Length

Returns the length of a string

Minute

Full Usage: Minute

Extracts the minute from a datetime value

Month

Full Usage: Month

Extracts the month from a datetime value

Pow SqlItemOrColumn

Full Usage: Pow SqlItemOrColumn

Parameters:

Raises a number to the power of another number

Item : SqlItemOrColumn

PowConst SqlItemOrColumn

Full Usage: PowConst SqlItemOrColumn

Parameters:

Raises a number to a constant power

Item : SqlItemOrColumn

Replaces occurrences of a substring with another substring

Item1 : SqlItemOrColumn
Item2 : SqlItemOrColumn

Round

Full Usage: Round

Rounds a number to the nearest integer

RoundDecimals int

Full Usage: RoundDecimals int

Parameters:
    Item : int

Rounds a number to the specified number of decimal places

Item : int

Second

Full Usage: Second

Extracts the second from a datetime value

Sin

Full Usage: Sin

Returns the sine of an angle (in radians)

Sqrt

Full Usage: Sqrt

Returns the square root of a number

Substring SqlItemOrColumn

Full Usage: Substring SqlItemOrColumn

Parameters:

Extracts a substring from the specified position to the end

Item : SqlItemOrColumn

Extracts a substring with specified start position and length

Item1 : SqlItemOrColumn
Item2 : SqlItemOrColumn

Tan

Full Usage: Tan

Returns the tangent of an angle (in radians)

ToLower

Full Usage: ToLower

Converts string to lowercase

ToUpper

Full Usage: ToUpper

Converts string to uppercase

Trim

Full Usage: Trim

Removes leading and trailing whitespace

Truncate

Full Usage: Truncate

Truncates a number to its integer part

Year

Full Usage: Year

Extracts the year from a datetime value

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.