ISqlDataContext (SQLProvider)

ISqlDataContext Type

Namespace: FSharp.Data.Sql.Common
Assembly: FSharp.Data.SqlProvider.dll
Base Type: obj
All Interfaces: ISqlDataContext

Instance members

Instance member	Description
`this.CallSproc` Full Usage: `this.CallSproc` Parameters: arg0 : `RunTimeSprocDefinition` arg1 : `QueryParameter[]` arg2 : `obj[]` 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: arg0 : `RunTimeSprocDefinition` arg1 : `QueryParameter[]` arg2 : `obj[]` 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: arg0 : `SqlEntity` arg1 : `string` arg2 : `string` arg3 : `string` arg4 : `string` arg5 : `string` arg6 : `RelationshipDirection` 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: arg0 : `string` arg1 : `ColumnLookup` arg2 : `IDataReader` 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: arg0 : `string` arg1 : `ColumnLookup` arg2 : `DbDataReader` 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: arg0 : `SqlEntity` 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>`