Class MsSqlCRUDScriptQueryHandler

Executes MsSql CRUD script-based queries

Inheritance
System.Object
CRUDQueryHandler
CRUDQueryHandler<MsSqlDataStore>
MsSqlCRUDScriptQueryHandler
Implements
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Azos.Data.Access.MsSql
Assembly: Azos.MsSql.dll
Syntax
public sealed class MsSqlCRUDScriptQueryHandler : CRUDQueryHandler<MsSqlDataStore>, INamed

Constructors

MsSqlCRUDScriptQueryHandler(MsSqlDataStore, QuerySource)

Declaration
public MsSqlCRUDScriptQueryHandler(MsSqlDataStore store, QuerySource source)
Parameters
Type Name Description
MsSqlDataStore store
QuerySource source

Methods

Execute(ICRUDQueryExecutionContext, Query, Boolean)

Declaration
public override RowsetBase Execute(ICRUDQueryExecutionContext context, Query query, bool oneDoc = false)
Parameters
Type Name Description
ICRUDQueryExecutionContext context
Query query
System.Boolean oneDoc
Returns
Type Description
RowsetBase
Overrides

ExecuteAsync(ICRUDQueryExecutionContext, Query, Boolean)

Declaration
public override Task<RowsetBase> ExecuteAsync(ICRUDQueryExecutionContext context, Query query, bool oneDoc = false)
Parameters
Type Name Description
ICRUDQueryExecutionContext context
Query query
System.Boolean oneDoc
Returns
Type Description
System.Threading.Tasks.Task<RowsetBase>
Overrides

ExecuteWithoutFetch(ICRUDQueryExecutionContext, Query)

Declaration
public override int ExecuteWithoutFetch(ICRUDQueryExecutionContext context, Query query)
Parameters
Type Name Description
ICRUDQueryExecutionContext context
Query query
Returns
Type Description
System.Int32
Overrides

ExecuteWithoutFetchAsync(ICRUDQueryExecutionContext, Query)

Declaration
public override Task<int> ExecuteWithoutFetchAsync(ICRUDQueryExecutionContext context, Query query)
Parameters
Type Name Description
ICRUDQueryExecutionContext context
Query query
Returns
Type Description
System.Threading.Tasks.Task<System.Int32>
Overrides

GetSchema(ICRUDQueryExecutionContext, Query)

Declaration
public override Schema GetSchema(ICRUDQueryExecutionContext context, Query query)
Parameters
Type Name Description
ICRUDQueryExecutionContext context
Query query
Returns
Type Description
Schema
Overrides

GetSchemaAsync(ICRUDQueryExecutionContext, Query)

Declaration
public override Task<Schema> GetSchemaAsync(ICRUDQueryExecutionContext context, Query query)
Parameters
Type Name Description
ICRUDQueryExecutionContext context
Query query
Returns
Type Description
System.Threading.Tasks.Task<Schema>
Overrides

GetSchemaForQuery(String, Query, SqlDataReader, QuerySource, out Schema.FieldDef[])

Gets schema from reader taking Query.ResultDocType in consideration

Declaration
public static Schema GetSchemaForQuery(string target, Query query, SqlDataReader reader, QuerySource qSource, out Schema.FieldDef[] toLoad)
Parameters
Type Name Description
System.String target
Query query
System.Data.SqlClient.SqlDataReader reader
QuerySource qSource
Schema.FieldDef[] toLoad
Returns
Type Description
Schema

GetSchemaFromReader(String, QuerySource, SqlDataReader)

Gets CRUD schema from MsSqlReader per particular QuerySource. If source is null then all columns from reader are copied. Note: this code was purposely made provider specific because other providers may treat some nuances differently

Declaration
public static Schema GetSchemaFromReader(string name, QuerySource source, SqlDataReader reader)
Parameters
Type Name Description
System.String name
QuerySource source
System.Data.SqlClient.SqlDataReader reader
Returns
Type Description
Schema

OpenCursor(ICRUDQueryExecutionContext, Query)

Declaration
public override Cursor OpenCursor(ICRUDQueryExecutionContext context, Query query)
Parameters
Type Name Description
ICRUDQueryExecutionContext context
Query query
Returns
Type Description
Cursor
Overrides

OpenCursorAsync(ICRUDQueryExecutionContext, Query)

Declaration
public override Task<Cursor> OpenCursorAsync(ICRUDQueryExecutionContext context, Query query)
Parameters
Type Name Description
ICRUDQueryExecutionContext context
Query query
Returns
Type Description
System.Threading.Tasks.Task<Cursor>
Overrides

PopulateDoc(MsSqlCRUDQueryExecutionContext, Type, Schema, Schema.FieldDef[], SqlDataReader)

Reads data from reader into rowset. the reader is NOT disposed

Declaration
public static Doc PopulateDoc(MsSqlCRUDQueryExecutionContext context, Type tDoc, Schema schema, Schema.FieldDef[] toLoad, SqlDataReader reader)
Parameters
Type Name Description
MsSqlCRUDQueryExecutionContext context
System.Type tDoc
Schema schema
Schema.FieldDef[] toLoad
System.Data.SqlClient.SqlDataReader reader
Returns
Type Description
Doc

PopulateParameters(SqlCommand, Query)

Populates SqlCommand with parameters from CRUD Query object Note: this code was purposely made provider specific because other providers may treat some nuances differently

Declaration
public void PopulateParameters(SqlCommand cmd, Query query)
Parameters
Type Name Description
System.Data.SqlClient.SqlCommand cmd
Query query

PopulateRowset(MsSqlCRUDQueryExecutionContext, SqlDataReader, String, Query, QuerySource, Boolean)

Reads data from reader into rowset. the reader is NOT disposed

Declaration
public static Rowset PopulateRowset(MsSqlCRUDQueryExecutionContext context, SqlDataReader reader, string target, Query query, QuerySource qSource, bool oneDoc)
Parameters
Type Name Description
MsSqlCRUDQueryExecutionContext context
System.Data.SqlClient.SqlDataReader reader
System.String target
Query query
QuerySource qSource
System.Boolean oneDoc
Returns
Type Description
Rowset

Implements

Extension Methods