SQLProvider

MSSqlServer Module

Functions and values

Function or value Description

connect con f

Full Usage: connect con f

Parameters:
Returns: 'a
con : IDbConnection
f : IDbConnection -> 'a
Returns: 'a

createCommand commandText connection

Full Usage: createCommand commandText connection

Parameters:
Returns: IDbCommand
commandText : string
connection : IDbConnection
Returns: IDbCommand

createCommandParameter param value

Full Usage: createCommandParameter param value

Parameters:
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

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:
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:
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:
Returns: (int * string * IDbDataParameter)[] * (int * string * IDbDataParameter)[]
inputParameters : QueryParameter[]
returnCols : QueryParameter[]
values : obj[]
Returns: (int * string * IDbDataParameter)[] * (int * string * IDbDataParameter)[]

executeSql sql con

Full Usage: executeSql sql con

Parameters:
Returns: SqlDataReader
sql : string
con : IDbConnection
Returns: SqlDataReader

fieldNotationAlias (al, col)

Full Usage: fieldNotationAlias (al, col)

Parameters:
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:
Returns: DataTable
name : string
args : string[]
con : IDbConnection
Returns: DataTable

getSprocName row

Full Usage: getSprocName row

Parameters:
Returns: SprocName
row : DataRow
Returns: SprocName

getSprocParameters con name

Full Usage: getSprocParameters con name

Parameters:
Returns: QueryParameter list
con : IDbConnection
name : SprocName
Returns: QueryParameter list

getSprocReturnCols con sname sparams

Full Usage: getSprocReturnCols con sname sparams

Parameters:
Returns: QueryParameter list
con : IDbConnection
sname : SprocName
sparams : QueryParameter list
Returns: QueryParameter list

getSprocs con

Full Usage: getSprocs con

Parameters:
Returns: Sproc list
con : IDbConnection
Returns: Sproc list

processReturnColumn com reader retCol

Full Usage: processReturnColumn com reader retCol

Parameters:
Returns: ReturnSetType
com : IDbCommand
reader : IDataReader
retCol : QueryParameter
Returns: ReturnSetType

processReturnColumnAsync com reader retCol

Full Usage: processReturnColumnAsync com reader retCol

Parameters:
Returns: Task<ReturnSetType>
com : IDbCommand
reader : DbDataReader
retCol : QueryParameter
Returns: Task<ReturnSetType>

readInOutParameterFromCommand name com

Full Usage: readInOutParameterFromCommand name com

Parameters:
Returns: string * obj
name : string
com : IDbCommand
Returns: string * obj

readParameter parameter

Full Usage: readParameter parameter

Parameters:
Returns: obj
parameter : IDbDataParameter
Returns: obj

typeMappings

Full Usage: typeMappings

Returns: TypeMapping list
Returns: TypeMapping list

Type something to start searching.