SQLProvider

SqlQuery Type

Record fields

Record Field Description

AggregateOp

Full Usage: AggregateOp

Field type: (alias * SqlColumnType) list
Field type: (alias * SqlColumnType) list

Aliases

Full Usage: Aliases

Field type: Map<string, Table>
Field type: Map<string, Table>

Count

Full Usage: Count

Field type: bool
Field type: bool

CrossJoins

Full Usage: CrossJoins

Field type: (alias * Table) list
Field type: (alias * Table) list

Distinct

Full Usage: Distinct

Field type: bool
Field type: bool

Filters

Full Usage: Filters

Field type: Condition list
Field type: Condition list

Grouping

Full Usage: Grouping

Field type: ((alias * SqlColumnType) list * (alias * SqlColumnType) list) list
Field type: ((alias * SqlColumnType) list * (alias * SqlColumnType) list) list

HavingFilters

Full Usage: HavingFilters

Field type: Condition list
Field type: Condition list

Links

Full Usage: Links

Field type: (alias * LinkData * alias) list
Field type: (alias * LinkData * alias) list

Ordering

Full Usage: Ordering

Field type: (alias * SqlColumnType * bool) list
Field type: (alias * SqlColumnType * bool) list

Projection

Full Usage: Projection

Field type: Expression list
Field type: Expression list

Skip

Full Usage: Skip

Field type: int voption
Field type: int voption

Take

Full Usage: Take

Field type: int voption
Field type: int voption

UltimateChild

Full Usage: UltimateChild

Field type: (string * Table) option
Field type: (string * Table) option

Union

Full Usage: Union

Field type: (UnionType * string * IDbDataParameter seq) option
Field type: (UnionType * string * IDbDataParameter seq) option

Static members

Static member Description

SqlQuery.Empty

Full Usage: SqlQuery.Empty

Returns: SqlQuery
Returns: SqlQuery

SqlQuery.ofSqlExp (exp, entityIndex)

Full Usage: SqlQuery.ofSqlExp (exp, entityIndex)

Parameters:
    exp : SqlExp
    entityIndex : ResizeArray<string>

Returns: SqlQuery
exp : SqlExp
entityIndex : ResizeArray<string>
Returns: SqlQuery

Type something to start searching.