SQLProvider


Sql

Namespace: FSharp.Data.Sql.Common

Functions and values

Function or valueDescription
connect con f
Signature: con:IDbConnection -> f:(IDbConnection -> 'a) -> 'a
Type parameters: 'a
connectAsync con f
Signature: con:DbConnection -> f:(DbConnection -> unit) -> Async<unit>
dataReaderToArray(reader)
Signature: reader:IDataReader -> (string * obj) [] []
dataReaderToArrayAsync(reader)
Signature: reader:DbDataReader -> Async<(string * obj) [] []>
dbUnbox(v)
Signature: v:obj -> 'a
Type parameters: 'a
dbUnboxWithDefault def v
Signature: def:'a -> v:obj -> 'a
Type parameters: 'a
ensureOpen(con)
Signature: con:IDbConnection -> unit
evaluateOneByOne asyncFunc entityList
Signature: asyncFunc:('a -> Async<'b>) -> entityList:'a list -> Async<'b list>
Type parameters: 'a, 'b

Helper function to run async computation non-parallel style for list of objects. This is needed if async database opreation is executed for a list of entities.

executeSql createCommand sql con
Signature: createCommand:('a -> IDbConnection -> IDbCommand) -> sql:'a -> con:IDbConnection -> IDataReader
Type parameters: 'a
executeSqlAsDataTable(...)
Signature: createCommand:('a -> IDbConnection -> IDbCommand) -> sql:'a -> con:IDbConnection -> DataTable
Type parameters: 'a
executeSqlAsDataTableAsync(...)
Signature: createCommand:('?9539 -> IDbConnection -> DbCommand) -> sql:'?9539 -> con:IDbConnection -> Async<DataTable>
Type parameters: '?9539
executeSqlAsync createCommand sql con
Signature: createCommand:('?9535 -> IDbConnection -> DbCommand) -> sql:'?9535 -> con:IDbConnection -> Async<DbDataReader>
Type parameters: '?9535
Fork me on GitHub