Class MySQLCRUDScriptQueryHandler

Executes MySql CRUD script-based queries

Inheritance
System.Object
CRUDQueryHandler
CRUDQueryHandler<MySQLDataStore>
MySQLCRUDScriptQueryHandler
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: NFX.DataAccess.MySQL
Assembly: NFX.MySQL.dll
Syntax
public sealed class MySQLCRUDScriptQueryHandler : CRUDQueryHandler<MySQLDataStore>, INamed

Constructors

MySQLCRUDScriptQueryHandler(MySQLDataStore, QuerySource)

Declaration
public MySQLCRUDScriptQueryHandler(MySQLDataStore store, QuerySource source)
Parameters
Type Name Description
MySQLDataStore store
QuerySource source

Methods

Execute(ICRUDQueryExecutionContext, Query, Boolean)

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

ExecuteAsync(ICRUDQueryExecutionContext, Query, Boolean)

Declaration
public override Task<RowsetBase> ExecuteAsync(ICRUDQueryExecutionContext context, Query query, bool oneRow = false)
Parameters
Type Name Description
ICRUDQueryExecutionContext context
Query query
System.Boolean oneRow
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, MySqlDataReader, QuerySource, out Schema.FieldDef[])

Gets schema from reader taking Query.ResultRowType in consideration

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

GetSchemaFromReader(String, QuerySource, MySqlDataReader)

Gets CRUD schema from MySqlReader 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, MySqlDataReader reader)
Parameters
Type Name Description
System.String name
QuerySource source
MySqlDataReader 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

PopulateParameters(MySqlCommand, Query)

Populates MySqlCommand 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(MySqlCommand cmd, Query query)
Parameters
Type Name Description
MySqlCommand cmd
Query query

PopulateRow(MySQLCRUDQueryExecutionContext, Type, Schema, Schema.FieldDef[], MySqlDataReader)

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

Declaration
public static Row PopulateRow(MySQLCRUDQueryExecutionContext context, Type tRow, Schema schema, Schema.FieldDef[] toLoad, MySqlDataReader reader)
Parameters
Type Name Description
MySQLCRUDQueryExecutionContext context
System.Type tRow
Schema schema
Schema.FieldDef[] toLoad
MySqlDataReader reader
Returns
Type Description
Row

PopulateRowset(MySQLCRUDQueryExecutionContext, MySqlDataReader, String, Query, QuerySource, Boolean)

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

Declaration
public static Rowset PopulateRowset(MySQLCRUDQueryExecutionContext context, MySqlDataReader reader, string target, Query query, QuerySource qSource, bool oneRow)
Parameters
Type Name Description
MySQLCRUDQueryExecutionContext context
MySqlDataReader reader
System.String target
Query query
QuerySource qSource
System.Boolean oneRow
Returns
Type Description
Rowset

Implements

Extension Methods