ISqlProvider (SQLProvider)

ISqlProvider Type

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

Instance members

Instance member	Description
`this.CloseConnectionAfterQuery` Full Usage: `this.CloseConnectionAfterQuery` Returns: `bool` Modifiers: abstract	MS Access needs to keep connection open Returns: `bool`
`this.CreateCommand` Full Usage: `this.CreateCommand` Parameters: arg0 : `IDbConnection` arg1 : `string` Returns: `IDbCommand` Modifiers: abstract	return a new command associated with the provided connection and command text arg0 : `IDbConnection` arg1 : `string` Returns: `IDbCommand`
`this.CreateCommandParameter` Full Usage: `this.CreateCommandParameter` Parameters: arg0 : `QueryParameter` arg1 : `obj` Returns: `IDbDataParameter` Modifiers: abstract	return a new command parameter with the provided name, value and optionally type, direction and length arg0 : `QueryParameter` arg1 : `obj` Returns: `IDbDataParameter`
`this.CreateConnection` Full Usage: `this.CreateConnection` Parameters: arg0 : `string` Returns: `IDbConnection` Modifiers: abstract	return a new, unopened connection using the provided connection string arg0 : `string` Returns: `IDbConnection`
`this.CreateTypeMappings` Full Usage: `this.CreateTypeMappings` Parameters: arg0 : `IDbConnection` Modifiers: abstract	This function will be called when the provider is first created and should be used to generate a cache of type mappings, and to set the three mapping function properties arg0 : `IDbConnection`
`this.DesignConnection` Full Usage: `this.DesignConnection` Returns: `bool` Modifiers: abstract	MSSDT doesn't do design-time connection Returns: `bool`
`this.ExecuteSprocCommand` Full Usage: `this.ExecuteSprocCommand` Parameters: arg0 : `IDbCommand` arg1 : `QueryParameter[]` arg2 : `QueryParameter[]` arg3 : `obj[]` Returns: `ReturnValueType` Modifiers: abstract	Builds a command representing a call to a stored procedure arg0 : `IDbCommand` arg1 : `QueryParameter[]` arg2 : `QueryParameter[]` arg3 : `obj[]` Returns: `ReturnValueType`
`this.ExecuteSprocCommandAsync` Full Usage: `this.ExecuteSprocCommandAsync` Parameters: arg0 : `DbCommand` arg1 : `QueryParameter[]` arg2 : `QueryParameter[]` arg3 : `obj[]` Returns: `Task<ReturnValueType>` Modifiers: abstract	Builds a command representing a call to a stored procedure, executing async arg0 : `DbCommand` arg1 : `QueryParameter[]` arg2 : `QueryParameter[]` arg3 : `obj[]` Returns: `Task<ReturnValueType>`
`this.GenerateQueryText` Full Usage: `this.GenerateQueryText` Parameters: arg0 : `SqlQuery` arg1 : `string` arg2 : `Table` arg3 : `Dictionary<string, ResizeArray<ProjectionParameter>>` arg4 : `bool` arg5 : `IDbConnection` Returns: `string * ResizeArray<IDbDataParameter>` Modifiers: abstract	Accepts a SqlQuery object and produces the SQL to execute on the server. the other parameters are the base table alias, the base table, and a dictionary containing the columns from the various table aliases that are in the SELECT projection arg0 : `SqlQuery` arg1 : `string` arg2 : `Table` arg3 : `Dictionary<string, ResizeArray<ProjectionParameter>>` arg4 : `bool` arg5 : `IDbConnection` Returns: `string * ResizeArray<IDbDataParameter>`
`this.GetColumnDescription` Full Usage: `this.GetColumnDescription` Parameters: arg0 : `IDbConnection` arg1 : `string` arg2 : `string` Returns: `string` Modifiers: abstract	Queries column descriptions / comments for tooltip-info, table name, column name to description arg0 : `IDbConnection` arg1 : `string` arg2 : `string` Returns: `string`
`this.GetColumns` Full Usage: `this.GetColumns` Parameters: arg0 : `IDbConnection` arg1 : `Table` Returns: `ColumnLookup` Modifiers: abstract	Queries the given table and returns a list of its columns this function should also populate a primary key cache for tables that have a single non-composite primary key arg0 : `IDbConnection` arg1 : `Table` Returns: `ColumnLookup`
`this.GetIndividualQueryText` Full Usage: `this.GetIndividualQueryText` Parameters: arg0 : `Table` arg1 : `string` Returns: `string` Modifiers: abstract	Returns the db vendor specific SQL query to select a single row based on the table and column name specified arg0 : `Table` arg1 : `string` Returns: `string`
`this.GetIndividualsQueryText` Full Usage: `this.GetIndividualsQueryText` Parameters: arg0 : `Table` arg1 : `int` Returns: `string` Modifiers: abstract	Returns the db vendor specific SQL query to select the top x amount of rows from the given table arg0 : `Table` arg1 : `int` Returns: `string`
`this.GetLockObject` Full Usage: `this.GetLockObject` Returns: `obj` Modifiers: abstract	Provider specific lock to do provider specific locking Returns: `obj`
`this.GetPrimaryKey` Full Usage: `this.GetPrimaryKey` Parameters: arg0 : `Table` Returns: `string option` Modifiers: abstract	Returns the primary key column for a given table from the pre-populated cache as generated by calls to GetColumns arg0 : `Table` Returns: `string option`
`this.GetRelationships` Full Usage: `this.GetRelationships` Parameters: arg0 : `IDbConnection` arg1 : `Table` Returns: `Relationship array * Relationship array` Modifiers: abstract	Returns constraint information for a given table, returning two lists of relationships, where the first are relationships where the table is the primary entity, and the second where it is the foreign entity arg0 : `IDbConnection` arg1 : `Table` Returns: `Relationship array * Relationship array`
`this.GetSchemaCache` Full Usage: `this.GetSchemaCache` Returns: `SchemaCache` Modifiers: abstract	Returns cached schema information, depending on the provider the cached schema may contain the whole database schema or only the schema for entities referenced in the current context Returns: `SchemaCache`
`this.GetSprocs` Full Usage: `this.GetSprocs` Parameters: arg0 : `IDbConnection` Returns: `Sproc list` Modifiers: abstract	Returns a list of stored procedure metadata arg0 : `IDbConnection` Returns: `Sproc list`
`this.GetTableDescription` Full Usage: `this.GetTableDescription` Parameters: arg0 : `IDbConnection` arg1 : `string` Returns: `string` Modifiers: abstract	Queries table descriptions / comments for tooltip-info, table name to description arg0 : `IDbConnection` arg1 : `string` Returns: `string`
`this.GetTables` Full Usage: `this.GetTables` Parameters: arg0 : `IDbConnection` arg1 : `CaseSensitivityChange` Returns: `Table array` Modifiers: abstract	Queries the information schema and returns a list of table information arg0 : `IDbConnection` arg1 : `CaseSensitivityChange` Returns: `Table array`
`this.ProcessUpdates` Full Usage: `this.ProcessUpdates` Parameters: arg0 : `IDbConnection` arg1 : `ConcurrentDictionary<SqlEntity, DateTime>` arg2 : `TransactionOptions` arg3 : `Option<int>` Modifiers: abstract	Writes all pending database changes to database arg0 : `IDbConnection` arg1 : `ConcurrentDictionary<SqlEntity, DateTime>` arg2 : `TransactionOptions` arg3 : `Option<int>`
`this.ProcessUpdatesAsync` Full Usage: `this.ProcessUpdatesAsync` Parameters: arg0 : `DbConnection` arg1 : `ConcurrentDictionary<SqlEntity, DateTime>` arg2 : `TransactionOptions` arg3 : `Option<int>` Returns: `Task<unit>` Modifiers: abstract	Asynchronously writes all pending database changes to database arg0 : `DbConnection` arg1 : `ConcurrentDictionary<SqlEntity, DateTime>` arg2 : `TransactionOptions` arg3 : `Option<int>` Returns: `Task<unit>`
`this.StoredProcedures` Full Usage: `this.StoredProcedures` Returns: `bool` Modifiers: abstract	SQLITE doesn't have command type of stored procedures Returns: `bool`