MSSqlServer (SQLProvider)

MSSqlServer Module

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

Functions and values

Function or value	Description
`checkIfMsSqlAssemblyIsDesingOnly assembly` Full Usage: `checkIfMsSqlAssemblyIsDesingOnly assembly` Parameters: assembly : `Assembly` Returns: `bool`	assembly : `Assembly` Returns: `bool`
`connect con f` Full Usage: `connect con f` Parameters: con : `IDbConnection` f : `IDbConnection -> 'a` Returns: `'a`	con : `IDbConnection` f : `IDbConnection -> 'a` Returns: `'a`
`createCommand commandText connection` Full Usage: `createCommand commandText connection` Parameters: commandText : `string` connection : `IDbConnection` Returns: `IDbCommand`	commandText : `string` connection : `IDbConnection` Returns: `IDbCommand`
`createCommandParameter param value` Full Usage: `createCommandParameter param value` Parameters: param : `QueryParameter` value : `obj` Returns: `IDbDataParameter`	param : `QueryParameter` value : `obj` Returns: `IDbDataParameter`
`createConnection connectionString` Full Usage: `createConnection connectionString` Parameters: connectionString : `string` Returns: `IDbConnection`	connectionString : `string` Returns: `IDbConnection`
`createOpenParameter (name, v)` Full Usage: `createOpenParameter (name, v)` Parameters: name : `string` v : `obj` Returns: `SqlParameter`	name : `string` v : `obj` Returns: `SqlParameter`
`createTypeMappings con` Full Usage: `createTypeMappings con` Parameters: con : `IDbConnection`	con : `IDbConnection`
`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`
`executeSprocCommand com inputParameters returnCols values` Full Usage: `executeSprocCommand com inputParameters returnCols values` Parameters: com : `IDbCommand` inputParameters : `QueryParameter[]` returnCols : `QueryParameter[]` values : `obj[]` Returns: `ReturnValueType`	com : `IDbCommand` inputParameters : `QueryParameter[]` returnCols : `QueryParameter[]` values : `obj[]` Returns: `ReturnValueType`
`executeSprocCommandAsync com inputParameters returnCols values` Full Usage: `executeSprocCommandAsync com inputParameters returnCols values` Parameters: com : `DbCommand` inputParameters : `QueryParameter[]` returnCols : `QueryParameter[]` values : `obj[]` Returns: `Task<ReturnValueType>`	com : `DbCommand` inputParameters : `QueryParameter[]` returnCols : `QueryParameter[]` values : `obj[]` Returns: `Task<ReturnValueType>`
`executeSprocCommandCommon inputParameters returnCols values` Full Usage: `executeSprocCommandCommon inputParameters returnCols values` Parameters: inputParameters : `QueryParameter[]` returnCols : `QueryParameter[]` values : `obj[]` Returns: `(int * string * IDbDataParameter) array * (int * string * IDbDataParameter) array`	inputParameters : `QueryParameter[]` returnCols : `QueryParameter[]` values : `obj[]` Returns: `(int * string * IDbDataParameter) array * (int * string * IDbDataParameter) array`
`executeSql sql con` Full Usage: `executeSql sql con` Parameters: sql : `string` con : `IDbConnection` Returns: `SqlDataReader`	sql : `string` con : `IDbConnection` Returns: `SqlDataReader`
`fieldNotationAlias (al, col)` Full Usage: `fieldNotationAlias (al, col)` Parameters: al : `alias` col : `SqlColumnType` Returns: `string`	al : `alias` col : `SqlColumnType` Returns: `string`
`findClrType` Full Usage: `findClrType` Returns: `string -> TypeMapping option`	Returns: `string -> TypeMapping option`
`findDbType` Full Usage: `findDbType` Returns: `string -> TypeMapping option`	Returns: `string -> TypeMapping option`
`getSchema name args con` Full Usage: `getSchema name args con` Parameters: name : `string` args : `string[]` con : `IDbConnection` Returns: `DataTable`	name : `string` args : `string[]` con : `IDbConnection` Returns: `DataTable`
`getSprocName row` Full Usage: `getSprocName row` Parameters: row : `DataRow` Returns: `SprocName`	row : `DataRow` Returns: `SprocName`
`getSprocParameters con name` Full Usage: `getSprocParameters con name` Parameters: con : `IDbConnection` name : `SprocName` Returns: `QueryParameter list`	con : `IDbConnection` name : `SprocName` Returns: `QueryParameter list`
`getSprocReturnCols con sname sparams` Full Usage: `getSprocReturnCols con sname sparams` Parameters: con : `IDbConnection` sname : `SprocName` sparams : `QueryParameter list` Returns: `QueryParameter list`	con : `IDbConnection` sname : `SprocName` sparams : `QueryParameter list` Returns: `QueryParameter list`
`getSprocs con` Full Usage: `getSprocs con` Parameters: con : `IDbConnection` Returns: `Sproc list`	con : `IDbConnection` Returns: `Sproc list`
`processReturnColumn com reader retCol` Full Usage: `processReturnColumn com reader retCol` Parameters: com : `IDbCommand` reader : `IDataReader` retCol : `QueryParameter` Returns: `ReturnSetType`	com : `IDbCommand` reader : `IDataReader` retCol : `QueryParameter` Returns: `ReturnSetType`
`processReturnColumnAsync com reader retCol` Full Usage: `processReturnColumnAsync com reader retCol` Parameters: com : `IDbCommand` reader : `DbDataReader` retCol : `QueryParameter` Returns: `Task<ReturnSetType>`	com : `IDbCommand` reader : `DbDataReader` retCol : `QueryParameter` Returns: `Task<ReturnSetType>`
`readInOutParameterFromCommand name com` Full Usage: `readInOutParameterFromCommand name com` Parameters: name : `string` com : `IDbCommand` Returns: `string * obj`	name : `string` com : `IDbCommand` Returns: `string * obj`
`readParameter parameter` Full Usage: `readParameter parameter` Parameters: parameter : `IDbDataParameter` Returns: `obj`	parameter : `IDbDataParameter` Returns: `obj`
`typeMappings` Full Usage: `typeMappings` Returns: `TypeMapping list`	Returns: `TypeMapping list`