Class OracleCRUDScriptQueryHandler

Executes Oracle CRUD script-based queries

Inheritance
System.Object
CRUDQueryHandler
CRUDQueryHandler<OracleDataStore>
OracleCRUDScriptQueryHandler
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.Oracle
Assembly: Azos.Oracle.dll
Syntax
public sealed class OracleCRUDScriptQueryHandler : CRUDQueryHandler<OracleDataStore>, INamed

Constructors

OracleCRUDScriptQueryHandler(OracleDataStore, QuerySource)

Declaration
public OracleCRUDScriptQueryHandler(OracleDataStore store, QuerySource source)
Parameters
Type Name Description
OracleDataStore 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, OracleDataReader, QuerySource, out Schema.FieldDef[])

Gets schema from reader taking Query.ResultDocType in consideration

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

GetSchemaFromReader(String, QuerySource, OracleDataReader)

Gets CRUD schema from OracleReader 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, OracleDataReader reader)
Parameters
Type Name Description
System.String name
QuerySource source
Oracle.ManagedDataAccess.Client.OracleDataReader 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(OracleCRUDQueryExecutionContext, Type, Schema, Schema.FieldDef[], OracleDataReader)

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

Declaration
public static Doc PopulateDoc(OracleCRUDQueryExecutionContext context, Type tDoc, Schema schema, Schema.FieldDef[] toLoad, OracleDataReader reader)
Parameters
Type Name Description
OracleCRUDQueryExecutionContext context
System.Type tDoc
Schema schema
Schema.FieldDef[] toLoad
Oracle.ManagedDataAccess.Client.OracleDataReader reader
Returns
Type Description
Doc

PopulateParameters(OracleCommand, Query)

Populates OracleCommand 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(OracleCommand cmd, Query query)
Parameters
Type Name Description
Oracle.ManagedDataAccess.Client.OracleCommand cmd
Query query

PopulateRowset(OracleCRUDQueryExecutionContext, OracleDataReader, String, Query, QuerySource, Boolean)

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

Declaration
public static Rowset PopulateRowset(OracleCRUDQueryExecutionContext context, OracleDataReader reader, string target, Query query, QuerySource qSource, bool oneDoc)
Parameters
Type Name Description
OracleCRUDQueryExecutionContext context
Oracle.ManagedDataAccess.Client.OracleDataReader reader
System.String target
Query query
QuerySource qSource
System.Boolean oneDoc
Returns
Type Description
Rowset

Implements

Extension Methods