LocalDb
Namespace: FSharp.ORM
Operations on the local Database.
Functions and values
| Function or value | Description |
call(config connection procedure)
Signature: config:IDbConfig -> connection:DbConnection -> procedure:'T -> 'T
Type parameters: 'T |
Calls the stored procedure. |
createConnection(config)
Signature: config:IDbConfig -> DbConnection
|
Creates the connection. |
delete(config connection arg3)
Signature: config:IDbConfig -> connection:DbConnection -> 'T -> unit
Type parameters: 'T |
Deletes the entity. |
deleteWithOpt(...)
Signature: config:IDbConfig -> connection:DbConnection -> entity:'T -> opt:DeleteOpt -> unit
Type parameters: 'T |
Deletes the entity without the version. |
execute(config connection sql condition)
Signature: config:IDbConfig -> connection:DbConnection -> sql:string -> condition:(string * obj * Type) list -> int
|
Executes the arbitrary SQL. |
executeReader(...)
Signature: config:IDbConfig -> connection:DbConnection -> handler:(DbDataReader -> 'T) -> sql:string -> condition:(string * obj * Type) list -> 'T
Type parameters: 'T |
Executes the SQL and handles the reader. |
find(config connection id)
Signature: config:IDbConfig -> connection:DbConnection -> id:obj list -> 'T
Type parameters: 'T |
Finds the entity. |
findWithVersion(...)
Signature: config:IDbConfig -> connection:DbConnection -> id:obj list -> version:obj -> 'T
Type parameters: 'T |
Finds the entity with the version. |
insert(config connection entity)
Signature: config:IDbConfig -> connection:DbConnection -> entity:'T -> 'T
Type parameters: 'T |
Inserts the entity. |
insertOrUpdate(config connection entity)
Signature: config:IDbConfig -> connection:DbConnection -> entity:'T -> 'T
Type parameters: 'T |
Inserts the entity, or updates if it already exists. |
insertWithOpt(...)
Signature: config:IDbConfig -> connection:DbConnection -> entity:'T -> opt:InsertOpt -> 'T
Type parameters: 'T |
Inserts the entity. |
paginate(...)
Signature: config:IDbConfig -> connection:DbConnection -> sql:string -> condition:(string * obj * Type) list -> (offset:int64 * limit:int64) -> 'T list
Type parameters: 'T |
Paginates the rows. |
paginateAndCount(...)
Signature: config:IDbConfig -> connection:DbConnection -> sql:string -> condition:(string * obj * Type) list -> (offset:int64 * limit:int64) -> 'T list * int64
Type parameters: 'T |
Paginates the rows, and counts rows without the offset and the limit. |
paginateOnDemand(...)
Signature: config:IDbConfig -> connection:DbConnection -> sql:string -> condition:(string * obj * Type) list -> (offset:int64 * limit:int64) -> seq<'T>
Type parameters: 'T |
Paginates the rows on demand. |
query(config connection sql condition)
Signature: config:IDbConfig -> connection:DbConnection -> sql:string -> condition:(string * obj * Type) list -> 'T list
Type parameters: 'T |
Queries the rows. |
queryable(config connection)
Signature: config:IDbConfig -> connection:DbConnection -> IQueryable<'T>
Type parameters: 'T |
Creates an IQueryable on 'T |
queryableDelete(config connection query)
Signature: config:IDbConfig -> connection:DbConnection -> query:IQueryable<'T> -> unit
Type parameters: 'T |
Deletes all values returned by query. |
queryableDirectSql(...)
Signature: config:IDbConfig -> connection:DbConnection -> query:seq<Sql> -> parametters:seq<Parameter> -> IQueryable<'T>
Type parameters: 'T |
Creates an IQueryable on 'T that executes specified query when enumerated. |
queryOnDemand(...)
Signature: config:IDbConfig -> connection:DbConnection -> sql:string -> condition:(string * obj * Type) list -> seq<'T>
Type parameters: 'T |
Queries the rows on demand. |
tryFind(config connection id)
Signature: config:IDbConfig -> connection:DbConnection -> id:obj list -> 'T option
Type parameters: 'T |
Try to find the entity. |
tryFindWithVersion(...)
Signature: config:IDbConfig -> connection:DbConnection -> id:obj list -> version:obj -> 'T option
Type parameters: 'T |
Try to find the entity with the version. |
update(config connection entity)
Signature: config:IDbConfig -> connection:DbConnection -> entity:'T -> 'T
Type parameters: 'T |
Updates the entity. |
updateWithOpt(...)
Signature: config:IDbConfig -> connection:DbConnection -> entity:'T -> opt:UpdateOpt -> 'T
Type parameters: 'T |
Updates the entity without the version. |
