SQLProvider

SqlExp Type

Namespace: FSharp.Data.Sql.Common
Assembly: FSharp.Data.SqlProvider.Common.dll
Base Type: obj

Union cases

Union case	Description
`AggregateOp(alias, SqlColumnType, SqlExp)` Full Usage: `AggregateOp(alias, SqlColumnType, SqlExp)` Parameters: Item1 : `alias` Item2 : `SqlColumnType` Item3 : `SqlExp`	Item1 : `alias` Item2 : `SqlColumnType` Item3 : `SqlExp`
`BaseTable alias * Table` Full Usage: `BaseTable alias * Table` Parameters: Item : `alias * Table`	name of the initiating IQueryable table - this isn't always the ultimate table that is selected Item : `alias * Table`
`Count SqlExp` Full Usage: `Count SqlExp` Parameters: Item : `SqlExp`	Item : `SqlExp`
`Distinct SqlExp` Full Usage: `Distinct SqlExp` Parameters: Item : `SqlExp`	distinct indicator Item : `SqlExp`
`FilterClause(Condition, SqlExp)` Full Usage: `FilterClause(Condition, SqlExp)` Parameters: Item1 : `Condition` Item2 : `SqlExp`	filters from the where clause(es) Item1 : `Condition` Item2 : `SqlExp`
`HavingClause(Condition, SqlExp)` Full Usage: `HavingClause(Condition, SqlExp)` Parameters: Item1 : `Condition` Item2 : `SqlExp`	filters from the where clause(es) Item1 : `Condition` Item2 : `SqlExp`
`OrderBy(alias, SqlColumnType, bool, SqlExp)` Full Usage: `OrderBy(alias, SqlColumnType, bool, SqlExp)` Parameters: Item1 : `alias` Item2 : `SqlColumnType` Item3 : `bool` Item4 : `SqlExp`	alias and column name, bool indicates ascending sort Item1 : `alias` Item2 : `SqlColumnType` Item3 : `bool` Item4 : `SqlExp`
`Projection(Expression, SqlExp)` Full Usage: `Projection(Expression, SqlExp)` Parameters: Item1 : `Expression` Item2 : `SqlExp`	entire LINQ projection expression tree Item1 : `Expression` Item2 : `SqlExp`
`SelectMany(alias, alias, SelectData, SqlExp)` Full Usage: `SelectMany(alias, alias, SelectData, SqlExp)` Parameters: Item1 : `alias` Item2 : `alias` Item3 : `SelectData` Item4 : `SqlExp`	from alias, to alias and join data including to and from table names. Note both the select many and join syntax end up here Item1 : `alias` Item2 : `alias` Item3 : `SelectData` Item4 : `SqlExp`
`Skip(int, SqlExp)` Full Usage: `Skip(int, SqlExp)` Parameters: Item1 : `int` Item2 : `SqlExp`	Item1 : `int` Item2 : `SqlExp`
`Take(int, SqlExp)` Full Usage: `Take(int, SqlExp)` Parameters: Item1 : `int` Item2 : `SqlExp`	Item1 : `int` Item2 : `SqlExp`
`Union(UnionType, bool -> string * IDbDataParameter seq, SqlExp)` Full Usage: `Union(UnionType, bool -> string * IDbDataParameter seq, SqlExp)` Parameters: Item1 : `UnionType` Item2 : `bool -> string * IDbDataParameter seq` Item3 : `SqlExp`	union type and the subquery as SQL text with its parameters, rendered as the outer query is (true for a sub-query of IN / NOT IN), so that both sides select the same columns Item1 : `UnionType` Item2 : `bool -> string * IDbDataParameter seq` Item3 : `SqlExp`

Instance members

Instance member	Description
`this.HasAutoTupled` Full Usage: `this.HasAutoTupled` Returns: `bool`	Returns: `bool`
`this.IsAggregateOp` Full Usage: `this.IsAggregateOp` Returns: `bool`	Returns: `bool`
`this.IsBaseTable` Full Usage: `this.IsBaseTable` Returns: `bool`	Returns: `bool`
`this.IsCount` Full Usage: `this.IsCount` Returns: `bool`	Returns: `bool`
`this.IsDistinct` Full Usage: `this.IsDistinct` Returns: `bool`	Returns: `bool`
`this.IsFilterClause` Full Usage: `this.IsFilterClause` Returns: `bool`	Returns: `bool`
`this.IsHavingClause` Full Usage: `this.IsHavingClause` Returns: `bool`	Returns: `bool`
`this.IsOrderBy` Full Usage: `this.IsOrderBy` Returns: `bool`	Returns: `bool`
`this.IsProjection` Full Usage: `this.IsProjection` Returns: `bool`	Returns: `bool`
`this.IsSelectMany` Full Usage: `this.IsSelectMany` Returns: `bool`	Returns: `bool`
`this.IsSkip` Full Usage: `this.IsSkip` Returns: `bool`	Returns: `bool`
`this.IsTake` Full Usage: `this.IsTake` Returns: `bool`	Returns: `bool`
`this.IsUnion` Full Usage: `this.IsUnion` Returns: `bool`	Returns: `bool`
`this.hasGroupBy ()` Full Usage: `this.hasGroupBy ()` Returns: `(Table * (alias * SqlColumnType) list) option`	Returns: `(Table * (alias * SqlColumnType) list) option`
`this.hasSortBy ()` Full Usage: `this.hasSortBy ()` Returns: `bool`	Returns: `bool`