Sql (SQLProvider)

Sql Module

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

Functions and values

Function or value	Description
`connect con f` Full Usage: `connect con f` Parameters: con : `IDbConnection` f : `IDbConnection -> 'a` Returns: `'a`	Note: SQLProvider reuses the connection through multiple instances, so you can't dispose it here. Instead it's created with ISQLProvider's CreateConnection method, and that is having always "use" to ensure it is disposed properly on "finally". con : `IDbConnection` f : `IDbConnection -> 'a` Returns: `'a`
`connectAndClose con f` Full Usage: `connectAndClose con f` Parameters: con : `IDbConnection` f : `IDbConnection -> 'a` Returns: `'a`	con : `IDbConnection` f : `IDbConnection -> 'a` Returns: `'a`
`connectAndCloseAsync con f` Full Usage: `connectAndCloseAsync con f` Parameters: con : `DbConnection` f : `DbConnection -> Task<'a>` Returns: `Task<'a>`	con : `DbConnection` f : `DbConnection -> Task<'a>` Returns: `Task<'a>`
`connectAsync con f` Full Usage: `connectAsync con f` Parameters: con : `DbConnection` f : `DbConnection -> Task<'a>` Returns: `Task<Task<'a>>`	Note: SQLProvider reuses the connection through multiple instances, so you can't dispose it here. Instead it's created with ISQLProvider's CreateConnection method, and that is having always "use" to ensure it is disposed properly on "finally". con : `DbConnection` f : `DbConnection -> Task<'a>` Returns: `Task<Task<'a>>`
`dataReaderToArray reader` Full Usage: `dataReaderToArray reader` Parameters: reader : `IDataReader` Returns: `(string * obj)[][]`	reader : `IDataReader` Returns: `(string * obj)[][]`
`dataReaderToArrayAsync reader` Full Usage: `dataReaderToArrayAsync reader` Parameters: reader : `DbDataReader` Returns: `Task<(string * obj)[] array>`	reader : `DbDataReader` Returns: `Task<(string * obj)[] array>`
`dbUnbox v` Full Usage: `dbUnbox v` Parameters: v : `obj` Returns: `'a`	v : `obj` Returns: `'a`
`dbUnboxWithDefault def v` Full Usage: `dbUnboxWithDefault def v` Parameters: def : `'a` v : `obj` Returns: `'a`	def : `'a` v : `obj` Returns: `'a`
`ensureOpen con` Full Usage: `ensureOpen con` Parameters: con : `IDbConnection`	con : `IDbConnection`
`evaluateOneByOne asyncFunc entityList` Full Usage: `evaluateOneByOne asyncFunc entityList` Parameters: asyncFunc : `'a -> 'b` entityList : `'a seq` Returns: `Task<'c list>`	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. DB-connections are not usually supporting parallel SQL-query execution, so even when async thread is available, it can't be used to execute another SQL at the same time. asyncFunc : `'a -> 'b` entityList : `'a seq` Returns: `Task<'c list>`
`executeSql createCommand sql con` Full Usage: `executeSql createCommand sql con` Parameters: createCommand : `'a -> IDbConnection -> IDbCommand` sql : `'a` con : `IDbConnection` Returns: `IDataReader`	createCommand : `'a -> IDbConnection -> IDbCommand` sql : `'a` con : `IDbConnection` Returns: `IDataReader`
`executeSqlAsDataTable createCommand sql con` Full Usage: `executeSqlAsDataTable createCommand sql con` Parameters: createCommand : `'a -> IDbConnection -> IDbCommand` sql : `'a` con : `IDbConnection` Returns: `DataTable`	createCommand : `'a -> IDbConnection -> IDbCommand` sql : `'a` con : `IDbConnection` Returns: `DataTable`
`executeSqlAsDataTableAsync createCommand sql con` Full Usage: `executeSqlAsDataTableAsync createCommand sql con` Parameters: createCommand : `'a -> IDbConnection -> DbCommand` sql : `'a` con : `IDbConnection` Returns: `Task<DataTable>`	createCommand : `'a -> IDbConnection -> DbCommand` sql : `'a` con : `IDbConnection` Returns: `Task<DataTable>`
`executeSqlAsync createCommand sql con` Full Usage: `executeSqlAsync createCommand sql con` Parameters: createCommand : `'a -> IDbConnection -> DbCommand` sql : `'a` con : `IDbConnection` Returns: `Task<DbDataReader>`	createCommand : `'a -> IDbConnection -> DbCommand` sql : `'a` con : `IDbConnection` Returns: `Task<DbDataReader>`