SQLProvider

Operators Module

Namespace: FSharp.Data.Sql
Assembly: FSharp.Data.SqlProvider.Common.dll

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: a : `IQueryable<'a>` Returns: `IQueryable<'a>` Type parameters: '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` Type parameters: 'a	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` Type parameters: 'a	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` Type parameters: 'a	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` Type parameters: 'a	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` Type parameters: 'a	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` Type parameters: 'a	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`