ISqlDataContext (SQLProvider)

ISqlDataContext Type

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

The main interface for SQL data context operations. This interface provides all the core functionality for querying, creating, updating, and deleting data through the SQL type provider. Users typically access this through the generated GetDataContext() method.

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.IsReadOnly` Full Usage: `this.IsReadOnly` Returns: `bool` Modifiers: abstract	Context meant to be read operations only Returns: `bool`
`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>`