Seq (SQLProvider)

Seq Module

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

Functions and values

Function or value	Description
``deleteallitemsfromsingletable`` _arg1 Full Usage: ``deleteallitemsfromsingletable`` _arg1 Parameters: _arg1 : `IQueryable<'T>` Returns: `Task<int>` Type parameters: 'T	WARNING! Execute SQLProvider DELETE FROM query to remove elements from the database. _arg1 : `IQueryable<'T>` Returns: `Task<int>`
`averageAsync` Full Usage: `averageAsync` Returns: `IQueryable<'T> -> Task<'T>` Type parameters: 'T (requires comparison)	Execute SQLProvider query to get the avg of elements, and release the OS thread while query is being executed. Returns: `IQueryable<'T> -> Task<'T>`
`exactlyOneAsync` Full Usage: `exactlyOneAsync` Returns: `IQueryable<'T> -> Task<'T>` Type parameters: 'T	Execute SQLProvider query to get the only element of the sequence. Throws `ArgumentNullException` if the seq is empty. Throws `ArgumentException` if the seq contains more than one element. Returns: `IQueryable<'T> -> Task<'T>`
`executeQueryAsync` Full Usage: `executeQueryAsync` Returns: `IQueryable<'a> -> Task<'a seq>` Type parameters: 'a	Execute SQLProvider query and release the OS thread while query is being executed. Returns: `IQueryable<'a> -> Task<'a seq>`
`headAsync` Full Usage: `headAsync` Returns: `IQueryable<'a> -> Task<'a>` Type parameters: 'a	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. Returns: `IQueryable<'a> -> Task<'a>`
`lengthAsync` Full Usage: `lengthAsync` Returns: `IQueryable<'a> -> Task<int>` Type parameters: 'a	Execute SQLProvider query to count the elements, and release the OS thread while query is being executed. Returns: `IQueryable<'a> -> Task<int>`
`maxAsync` Full Usage: `maxAsync` Returns: `IQueryable<'T> -> Task<'T>` Type parameters: 'T (requires comparison)	Execute SQLProvider query to get the max of elements, and release the OS thread while query is being executed. Returns: `IQueryable<'T> -> Task<'T>`
`minAsync` Full Usage: `minAsync` Returns: `IQueryable<'T> -> Task<'T>` Type parameters: 'T (requires comparison)	Execute SQLProvider query to get the min of elements, and release the OS thread while query is being executed. Returns: `IQueryable<'T> -> Task<'T>`
`stdDevAsync` Full Usage: `stdDevAsync` Returns: `IQueryable<'T> -> Task<'T>` Type parameters: 'T (requires comparison)	Execute SQLProvider query to get the standard deviation of elements, and release the OS thread while query is being executed. Returns: `IQueryable<'T> -> Task<'T>`
`sumAsync` Full Usage: `sumAsync` Returns: `IQueryable<'T> -> Task<'T>` Type parameters: 'T (requires comparison)	Execute SQLProvider query to get the sum of elements, and release the OS thread while query is being executed. Returns: `IQueryable<'T> -> Task<'T>`
`tryExactlyOneAsync` Full Usage: `tryExactlyOneAsync` Returns: `IQueryable<'T> -> Task<'T option>` Type parameters: 'T	Execute SQLProvider query to get the only element of the sequence. Returns `None` if there are zero or more than one element in the seq. Returns: `IQueryable<'T> -> Task<'T option>`
`tryHeadAsync` Full Usage: `tryHeadAsync` Returns: `IQueryable<'a> -> Task<'a option>` Type parameters: 'a	Execute SQLProvider query to take one result and release the OS thread while query is being executed. Returns None if no elements exists. Returns: `IQueryable<'a> -> Task<'a option>`
`varianceAsync` Full Usage: `varianceAsync` Returns: `IQueryable<'T> -> Task<'T>` Type parameters: 'T (requires comparison)	Execute SQLProvider query to get the variance of elements, and release the OS thread while query is being executed. Returns: `IQueryable<'T> -> Task<'T>`