SQLProvider

Operators Module

Contains custom SQL operators for use in query expressions. These operators are translated to their SQL equivalents during query compilation.

Functions and values

Function or value Description

!!a

Full Usage: !!a

Parameters:
Returns: IQueryable<'a>

Left outer join operator. Performs a left join on a related table. Used after "in" and before the context.tablename param a: The related table queryable A queryable that performs a left outer join

a : IQueryable<'a>
Returns: IQueryable<'a>

a <>% b

Full Usage: a <>% b

Parameters:
    a : 'a
    b : string

Returns: bool

SQL NOT LIKE operator for negated pattern matching. param a: The value to test param b: The pattern to reject returns>Always false at compile time - replaced with SQL NOT LIKE during query execution

a : 'a
b : string
Returns: bool

a =% b

Full Usage: a =% b

Parameters:
    a : 'a
    b : string

Returns: bool

SQL LIKE operator for pattern matching with wildcards. param a: The value to test param b: The pattern to match returns: Always false at compile time - replaced with SQL LIKE during query execution

a : 'a
b : string
Returns: bool

a |<>| b

Full Usage: a |<>| b

Parameters:
    a : 'a
    b : 'a seq

Returns: bool

SQL NOT IN operator. Tests if a value does not exist in a sequence. param a: The value to test param b: The sequence to search in returns: Always false at compile time - replaced with SQL NOT IN during query execution

a : 'a
b : 'a seq
Returns: bool

a |=| b

Full Usage: a |=| b

Parameters:
    a : 'a
    b : 'a seq

Returns: bool

SQL IN operator. Tests if a value exists in a sequence. param a: The value to test param b: The sequence to search in returns: Always false at compile time - replaced with SQL IN during query execution

a : 'a
b : 'a seq
Returns: bool

StdDev a

Full Usage: StdDev a

Parameters:
    a : 'a

Returns: decimal

Calculates the standard deviation of numeric values in a column. Used in aggregate queries with groupBy. param a: The column value returns: Always 1m at compile time - replaced with SQL STDDEV during query execution

a : 'a
Returns: decimal

Variance a

Full Usage: Variance a

Parameters:
    a : 'a

Returns: decimal

Calculates the variance of numeric values in a column. Used in aggregate queries with groupBy. param a: The column value returns: Always 1m at compile time - replaced with SQL VARIANCE during query execution

a : 'a
Returns: decimal

Type something to start searching.