FSharp.ORM


LocalDb

Namespace: FSharp.ORM

Implements FSharp.ORM.ILocalDb.

Constructors

ConstructorDescription
new(config)
Signature: config:IDbConfig -> LocalDb

Initializes a Db instance.

Instance members

Instance memberDescription
Call(connection, procedure)
Signature: (connection:DbConnection * procedure:'T) -> unit
Modifiers: abstract
Type parameters: 'T

Calls the stored procedure.

CreateConnection()
Signature: unit -> DbConnection
Modifiers: abstract

Creates the connection.

DbConfig
Signature: IDbConfig
Modifiers: abstract

Gets the databse configuration.

Delete(connection, entity, opt)
Signature: (connection:DbConnection * entity:'T * opt:DeleteOpt) -> unit
Modifiers: abstract
Type parameters: 'T

Deletes the entity.

Delete(connection, entity)
Signature: (connection:DbConnection * entity:'T) -> unit
Modifiers: abstract
Type parameters: 'T

Deletes the entity.

Execute(connection, sql, condition)
Signature: (connection:DbConnection * sql:string * condition:obj) -> int
Modifiers: abstract

Executes the arbitrary SQL.

Execute(connection, sql)
Signature: (connection:DbConnection * sql:string) -> int
Modifiers: abstract

Executes the arbitrary SQL.

ExecuteReader(...)
Signature: (connection:DbConnection * handler:Func<DbDataReader,'T> * sql:string * condition:obj) -> 'T
Modifiers: abstract
Type parameters: 'T

Executes the SQL and handles the reader.

ExecuteReader(connection, handler, sql)
Signature: (connection:DbConnection * handler:Func<DbDataReader,'T> * sql:string) -> 'T
Modifiers: abstract
Type parameters: 'T

Executes the SQL and handles the reader.

Find(connection, id)
Signature: (connection:DbConnection * id:obj) -> 'T
Modifiers: abstract
Type parameters: 'T

Finds the entity.

FindWithVersion(connection, id, version)
Signature: (connection:DbConnection * id:obj * version:obj) -> 'T
Modifiers: abstract
Type parameters: 'T

Finds the entity with the version.

Insert(connection, entity, opt)
Signature: (connection:DbConnection * entity:'T * opt:InsertOpt) -> unit
Modifiers: abstract
Type parameters: 'T

Inserts the entity.

Insert(connection, entity)
Signature: (connection:DbConnection * entity:'T) -> unit
Modifiers: abstract
Type parameters: 'T

Inserts the entity.

InsertOrUpdate(connection, entity)
Signature: (connection:DbConnection * entity:'T) -> unit
Modifiers: abstract
Type parameters: 'T

Inserts the entity, or updates if it already exists.

Paginate(...)
Signature: (connection:DbConnection * sql:string * offset:int64 * limit:int64 * condition:obj) -> IList<'T>
Modifiers: abstract
Type parameters: 'T

Paginates the rows.

Paginate(connection, sql, offset, limit)
Signature: (connection:DbConnection * sql:string * offset:int64 * limit:int64) -> IList<'T>
Modifiers: abstract
Type parameters: 'T

Paginates the rows.

PaginateAndCount(...)
Signature: (connection:DbConnection * sql:string * offset:int64 * limit:int64 * condition:obj) -> IList<'T> * int64
Modifiers: abstract
Type parameters: 'T

Paginates the rows, and counts rows without the offset and the limit.

PaginateAndCount(...)
Signature: (connection:DbConnection * sql:string * offset:int64 * limit:int64) -> IList<'T> * int64
Modifiers: abstract
Type parameters: 'T

Paginates the rows, and counts rows without the offset and the limit.

PaginateOnDemand(...)
Signature: (connection:DbConnection * sql:string * offset:int64 * limit:int64 * condition:obj) -> seq<'T>
Modifiers: abstract
Type parameters: 'T

Paginates the rows on demand.

PaginateOnDemand(...)
Signature: (connection:DbConnection * sql:string * offset:int64 * limit:int64) -> seq<'T>
Modifiers: abstract
Type parameters: 'T

Paginates the rows on demand.

Query(connection, sql, condition)
Signature: (connection:DbConnection * sql:string * condition:obj) -> IList<'T>
Modifiers: abstract
Type parameters: 'T

Queries the rows.

Query(connection, sql)
Signature: (connection:DbConnection * sql:string) -> IList<'T>
Modifiers: abstract
Type parameters: 'T

Queries the rows.

Queryable(connection)
Signature: connection:DbConnection -> IQueryable<'T>
Modifiers: abstract
Type parameters: 'T

Creates an IQueryable on 'T

QueryableDelete(connection, query)
Signature: (connection:DbConnection * query:IQueryable<'T>) -> unit
Modifiers: abstract
Type parameters: 'T

Deletes all values returned by query.

QueryableDirectSql(...)
Signature: connection:DbConnection -> query:seq<Sql> -> parametters:seq<Parameter> -> IQueryable<'T>
Modifiers: abstract
Type parameters: 'T

Creates an IQueryable on 'T that executes specified query when enumerated.

QueryOnDemand(...)
Signature: (connection:DbConnection * sql:string * condition:obj) -> seq<'T>
Modifiers: abstract
Type parameters: 'T

Queries the rows on demand.

QueryOnDemand(connection, sql)
Signature: (connection:DbConnection * sql:string) -> seq<'T>
Modifiers: abstract
Type parameters: 'T

Queries the rows on demand.

TryFind(connection, id)
Signature: (connection:DbConnection * id:obj) -> 'T
Modifiers: abstract
Type parameters: 'T

Try to find the entity.

TryFindWithVersion(...)
Signature: (connection:DbConnection * id:obj * version:obj) -> 'T
Modifiers: abstract
Type parameters: 'T

Try to find the entity with the version.

Update(connection, entity, opt)
Signature: (connection:DbConnection * entity:'T * opt:UpdateOpt) -> unit
Modifiers: abstract
Type parameters: 'T

Updates the entity.

Update(connection, entity)
Signature: (connection:DbConnection * entity:'T) -> unit
Modifiers: abstract
Type parameters: 'T

Updates the entity.

Fork me on GitHub