SQLProvider

ISqlDataContext Type

Instance members

Instance member Description

this.CallSproc

Full Usage: this.CallSproc

Parameters:
Returns: obj
Modifiers: abstract

Call stored procedure: Definition, return columns, values. Returns result.

arg0 : RunTimeSprocDefinition
arg1 : QueryParameter[]
arg2 : obj[]
Returns: obj

this.CallSprocAsync

Full Usage: this.CallSprocAsync

Parameters:
Returns: Task<SqlEntity>
Modifiers: abstract

Call stored procedure: Definition, return columns, values. Returns result task.

arg0 : RunTimeSprocDefinition
arg1 : QueryParameter[]
arg2 : obj[]
Returns: Task<SqlEntity>

this.ClearPendingChanges

Full Usage: this.ClearPendingChanges

Modifiers: abstract

Remove changes that are in context.

this.CommandTimeout

Full Usage: this.CommandTimeout

Returns: Option<int>
Modifiers: abstract

Command timeout (in seconds)

Returns: Option<int>

this.ConnectionString

Full Usage: this.ConnectionString

Returns: string
Modifiers: abstract

Connection string to database

Returns: string

this.CreateConnection

Full Usage: this.CreateConnection

Returns: IDbConnection
Modifiers: abstract

return a new, unopened connection using the provided connection string

Returns: IDbConnection

this.CreateEntities

Full Usage: this.CreateEntities

Parameters:
    arg0 : string

Returns: IQueryable<SqlEntity>
Modifiers: abstract

Create entities for a table.

arg0 : string
Returns: IQueryable<SqlEntity>

this.CreateEntity

Full Usage: this.CreateEntity

Parameters:
    arg0 : string

Returns: SqlEntity
Modifiers: abstract

Takes table-name. Returns new entity.

arg0 : string
Returns: SqlEntity

this.CreateRelated

Full Usage: this.CreateRelated

Parameters:
Returns: IQueryable<SqlEntity>
Modifiers: abstract

CreateRelated: instance, _, primary_table, primary_key, foreing_Table, foreign_key, direction. Returns entities

arg0 : SqlEntity
arg1 : string
arg2 : string
arg3 : string
arg4 : string
arg5 : string
arg6 : RelationshipDirection
Returns: IQueryable<SqlEntity>

this.GetIndividual

Full Usage: this.GetIndividual

Parameters:
    arg0 : string
    arg1 : obj

Returns: SqlEntity
Modifiers: abstract

Get individual row. Takes tablename and id.

arg0 : string
arg1 : obj
Returns: SqlEntity

this.GetPendingEntities

Full Usage: this.GetPendingEntities

Returns: SqlEntity list
Modifiers: abstract

List changes that are in context.

Returns: SqlEntity list

this.GetPrimaryKeyDefinition

Full Usage: this.GetPrimaryKeyDefinition

Parameters:
    arg0 : string

Returns: string
Modifiers: abstract

Give a tablename and this returns the key name

arg0 : string
Returns: string

this.ReadEntities

Full Usage: this.ReadEntities

Parameters:
Returns: SqlEntity[]
Modifiers: abstract

Read entity. Table name, columns, data-reader. Returns entities.

arg0 : string
arg1 : ColumnLookup
arg2 : IDataReader
Returns: SqlEntity[]

this.ReadEntitiesAsync

Full Usage: this.ReadEntitiesAsync

Parameters:
Returns: Task<SqlEntity[]>
Modifiers: abstract

Read entity. Table name, columns, data-reader. Returns entities task.

arg0 : string
arg1 : ColumnLookup
arg2 : DbDataReader
Returns: Task<SqlEntity[]>

this.SaveContextSchema

Full Usage: this.SaveContextSchema

Parameters:
    arg0 : string

Modifiers: abstract

Save schema offline as Json

arg0 : string

this.SqlOperationsInSelect

Full Usage: this.SqlOperationsInSelect

Returns: SelectOperations
Modifiers: abstract

Operations of select in SQL-side or in .NET side?

Returns: SelectOperations

this.SubmitChangedEntity

Full Usage: this.SubmitChangedEntity

Parameters:
Modifiers: abstract

Save entity to database.

arg0 : SqlEntity

this.SubmitPendingChanges

Full Usage: this.SubmitPendingChanges

Modifiers: abstract

Save database-changes in a transaction to database.

this.SubmitPendingChangesAsync

Full Usage: this.SubmitPendingChangesAsync

Returns: Task<unit>
Modifiers: abstract

Save database-changes in a transaction to database.

Returns: Task<unit>

Type something to start searching.