CommonTasks (SQLProvider)

CommonTasks Module

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

Functions and values

Function or value	Description
``ensurecolumnshavebeenloaded`` provider con entities Full Usage: ``ensurecolumnshavebeenloaded`` provider con entities Parameters: provider : `ISqlProvider` con : `IDbConnection` entities : `ConcurrentDictionary<SqlEntity, DateTime>`	provider : `ISqlProvider` con : `IDbConnection` entities : `ConcurrentDictionary<SqlEntity, DateTime>`
`checkKey pkLookup id e` Full Usage: `checkKey pkLookup id e` Parameters: pkLookup : `ConcurrentDictionary<string, string list>` id : `'a` e : `SqlEntity`	pkLookup : `ConcurrentDictionary<string, string list>` id : `'a` e : `SqlEntity`
`initCallSproc dc def values con com hasStoredProcedures` Full Usage: `initCallSproc dc def values con com hasStoredProcedures` Parameters: dc : `ISqlDataContext` def : `RunTimeSprocDefinition` values : `obj array` con : `IDbConnection` com : `IDbCommand` hasStoredProcedures : `bool` Returns: `QueryParameter array * SqlEntity * ('a -> SqlEntity[])`	dc : `ISqlDataContext` def : `RunTimeSprocDefinition` values : `obj array` con : `IDbConnection` com : `IDbCommand` hasStoredProcedures : `bool` Returns: `QueryParameter array * SqlEntity * ('a -> SqlEntity[])`
`parseHaving fieldNotation keys conditionList` Full Usage: `parseHaving fieldNotation keys conditionList` Parameters: fieldNotation : `'a` keys : `(alias * SqlColumnType) list` conditionList : `Condition list` Returns: `Condition list`	fieldNotation : `'a` keys : `(alias * SqlColumnType) list` conditionList : `Condition list` Returns: `Condition list`
`searchDataTypeFromCache provider con sqlQuery baseAlias baseTable alias col` Full Usage: `searchDataTypeFromCache provider con sqlQuery baseAlias baseTable alias col` Parameters: provider : `ISqlProvider` con : `IDbConnection` sqlQuery : `SqlQuery` baseAlias : `string` baseTable : `Table` alias : `string` col : `SqlColumnType` Returns: `DbType voption`	Check if we know primary column data type from cache. This helps matching parameter types if there are many different DBTypes mapped to same .NET type, like nvarchar and varchar to string. provider : `ISqlProvider` con : `IDbConnection` sqlQuery : `SqlQuery` baseAlias : `string` baseTable : `Table` alias : `string` col : `SqlColumnType` Returns: `DbType voption`
`sortEntities entities` Full Usage: `sortEntities entities` Parameters: entities : `ConcurrentDictionary<SqlEntity, DateTime>` Returns: `SqlEntity seq` Modifiers: inline	deterministically sort entities before processing in a creation order, so that user can reliably save entities with foreign key relations entities : `ConcurrentDictionary<SqlEntity, DateTime>` Returns: `SqlEntity seq`