CanonicalOp (SQLProvider)

CanonicalOp Type

Namespace: FSharp.Data.Sql
Assembly: FSharp.Data.SqlProvider.Common.dll
Parent Module: ColumnSchema
Base Type: obj
All Interfaces: IEquatable<CanonicalOp> , IStructuralEquatable

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: Item : `SqlItemOrColumn`	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: Item : `SqlItemOrColumn`	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: Item : `SqlItemOrColumn`	Adds the specified number of years to a datetime value Item : `SqlItemOrColumn`
`BasicMath(operation, constant)` Full Usage: `BasicMath(operation, constant)` Parameters: operation : `string` constant : `obj`	Basic mathematical operation with a constant value operation : `string` constant : `obj`
`BasicMathLeft(operation, constant)` Full Usage: `BasicMathLeft(operation, constant)` Parameters: operation : `string` constant : `obj`	Left-side basic mathematical operation with a constant value operation : `string` constant : `obj`
`BasicMathOfColumns(operation, alias, column)` Full Usage: `BasicMathOfColumns(operation, alias, column)` Parameters: operation : `string` alias : `string` column : `SqlColumnType`	Basic mathematical operation between columns operation : `string` alias : `string` column : `SqlColumnType`
`CaseNotSql(Condition, SqlItemOrColumn)` Full Usage: `CaseNotSql(Condition, SqlItemOrColumn)` Parameters: Item1 : `Condition` Item2 : `SqlItemOrColumn`	SQL CASE expression with negated condition and true value Item1 : `Condition` Item2 : `SqlItemOrColumn`
`CaseSql(Condition, SqlItemOrColumn)` Full Usage: `CaseSql(Condition, SqlItemOrColumn)` Parameters: Item1 : `Condition` Item2 : `SqlItemOrColumn`	SQL CASE expression with condition and false value Item1 : `Condition` Item2 : `SqlItemOrColumn`
`CaseSqlPlain(Condition, obj, obj)` Full Usage: `CaseSqlPlain(Condition, obj, obj)` Parameters: Item1 : `Condition` Item2 : `obj` Item3 : `obj`	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: Item : `SqlItemOrColumn`	Calculates the difference in days between two datetime values Item : `SqlItemOrColumn`
`DateDiffSecs SqlItemOrColumn` Full Usage: `DateDiffSecs SqlItemOrColumn` Parameters: Item : `SqlItemOrColumn`	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: Item : `SqlItemOrColumn`	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: Item : `SqlItemOrColumn`	Returns the index of the first occurrence of a substring Item : `SqlItemOrColumn`
`IndexOfStart(SqlItemOrColumn, SqlItemOrColumn)` Full Usage: `IndexOfStart(SqlItemOrColumn, SqlItemOrColumn)` Parameters: Item1 : `SqlItemOrColumn` Item2 : `SqlItemOrColumn`	Returns the index of a substring starting from a specified position Item1 : `SqlItemOrColumn` Item2 : `SqlItemOrColumn`
`Least SqlItemOrColumn` Full Usage: `Least SqlItemOrColumn` Parameters: Item : `SqlItemOrColumn`	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: Item : `SqlItemOrColumn`	Raises a number to the power of another number Item : `SqlItemOrColumn`
`PowConst SqlItemOrColumn` Full Usage: `PowConst SqlItemOrColumn` Parameters: Item : `SqlItemOrColumn`	Raises a number to a constant power Item : `SqlItemOrColumn`
`Replace(SqlItemOrColumn, SqlItemOrColumn)` Full Usage: `Replace(SqlItemOrColumn, SqlItemOrColumn)` Parameters: Item1 : `SqlItemOrColumn` Item2 : `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: Item : `SqlItemOrColumn`	Extracts a substring from the specified position to the end Item : `SqlItemOrColumn`
`SubstringWithLength(SqlItemOrColumn, SqlItemOrColumn)` Full Usage: `SubstringWithLength(SqlItemOrColumn, SqlItemOrColumn)` Parameters: Item1 : `SqlItemOrColumn` Item2 : `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`