SQLProvider


Seq

Namespace: FSharp.Data.Sql

Functions and values

Function or valueDescription
( delete all items from single table )(...)
Signature: _arg1:IQueryable<'T> -> Async<int>
Type parameters: 'T

WARNING! Execute SQLProvider DELETE FROM query to remove elements from the database.

CompiledName: delete all items from single table

averageAsync
Signature: IQueryable<'T> -> Async<'T>
Type parameters: 'T

Execute SQLProvider query to get the avg of elements, and release the OS thread while query is being executed.

executeQueryAsync
Signature: IQueryable<'?8362> -> Async<seq<'?8362>>
Type parameters: '?8362

Execute SQLProvider query and release the OS thread while query is being executed.

headAsync
Signature: IQueryable<'?8366> -> Async<'?8366>
Type parameters: '?8366

Execute SQLProvider query to take one result and release the OS thread while query is being executed. Like normal head: Throws exception if no elements exists. See also tryHeadAsync.

lengthAsync
Signature: IQueryable<'?8364> -> Async<int>
Type parameters: '?8364

Execute SQLProvider query to count the elements, and release the OS thread while query is being executed.

maxAsync
Signature: IQueryable<'T> -> Async<'T>
Type parameters: 'T

Execute SQLProvider query to get the max of elements, and release the OS thread while query is being executed.

minAsync
Signature: IQueryable<'T> -> Async<'T>
Type parameters: 'T

Execute SQLProvider query to get the min of elements, and release the OS thread while query is being executed.

stdDevAsync
Signature: IQueryable<'T> -> Async<'T>
Type parameters: 'T

Execute SQLProvider query to get the standard deviation of elements, and release the OS thread while query is being executed.

sumAsync
Signature: IQueryable<'T> -> Async<'T>
Type parameters: 'T

Execute SQLProvider query to get the sum of elements, and release the OS thread while query is being executed.

tryHeadAsync
Signature: IQueryable<'?8368> -> Async<'?8368 option>
Type parameters: '?8368

Execute SQLProvider query to take one result and release the OS thread while query is being executed. Returns None if no elements exists.

varianceAsync
Signature: IQueryable<'T> -> Async<'T>
Type parameters: 'T

Execute SQLProvider query to get the variance of elements, and release the OS thread while query is being executed.

Fork me on GitHub