Class DbSqlExecuter

ADO.NET-based ISqlExecuter implementation that queues SQL open/execute and transaction operations and runs them against a generic DbConnection (via a DbProviderFactory) when flushed, with support for parameterized commands, insert blocks and partial (chunked) result-set filling.

Inheritance
object
DbSqlExecuter
Implements
Inherited Members
Namespace: Reportman.Drawing
Assembly: Reportman.Drawing.dll
Syntax
public class DbSqlExecuter : ISqlExecuter

Constructors

View Source

DbSqlExecuter(DbConnection, DbProviderFactory)

Declaration
public DbSqlExecuter(DbConnection nconnection, DbProviderFactory nfactory)
Parameters
Type Name Description
DbConnection nconnection
DbProviderFactory nfactory

Fields

View Source

transaction

Declaration
public DbTransaction transaction
Field Value
Type Description
DbTransaction

Methods

View Source

AddCustomOperation(int, string, byte[])

Declaration
public void AddCustomOperation(int operation, string data, byte[] binarydata)
Parameters
Type Name Description
int operation
string data
byte[] binarydata
View Source

AddExternalColumnsToLastCommand(string, string)

Declaration
public void AddExternalColumnsToLastCommand(string external_columns, string deletions)
Parameters
Type Name Description
string external_columns
string deletions
View Source

BeginInsertBlock()

Declaration
public void BeginInsertBlock()
View Source

Commit()

Declaration
public void Commit()
View Source

Connect()

Declaration
public void Connect()
View Source

CreateCommand(string)

Declaration
public DbCommand CreateCommand(string cadsql)
Parameters
Type Name Description
string cadsql
Returns
Type Description
DbCommand
View Source

Disconnect()

Declaration
public void Disconnect()
View Source

EndInsertBlock()

Declaration
public void EndInsertBlock()
View Source

Execute(DbCommand)

Declaration
public void Execute(DbCommand ncommand)
Parameters
Type Name Description
DbCommand ncommand
View Source

Execute(string)

Declaration
public void Execute(string sql)
Parameters
Type Name Description
string sql
View Source

ExecuteInmediate(string)

Declaration
public int ExecuteInmediate(string sql)
Parameters
Type Name Description
string sql
Returns
Type Description
int
View Source

Flush()

Declaration
public void Flush()
View Source

Flush(ISqlExecuterProgressEvent)

Declaration
public void Flush(ISqlExecuterProgressEvent nevent)
Parameters
Type Name Description
ISqlExecuterProgressEvent nevent
View Source

GetGenerator(string, int)

Declaration
public long GetGenerator(string generatorName, int increment)
Parameters
Type Name Description
string generatorName
int increment
Returns
Type Description
long
View Source

GetValueFromSql(string)

Declaration
public object GetValueFromSql(string sql)
Parameters
Type Name Description
string sql
Returns
Type Description
object
View Source

Open(DataSet, DbCommand, string)

Declaration
public void Open(DataSet ndataset, DbCommand nCommand, string tablename)
Parameters
Type Name Description
DataSet ndataset
DbCommand nCommand
string tablename
View Source

Open(DataSet, string, string)

Declaration
public void Open(DataSet ndataset, string sql, string tablename)
Parameters
Type Name Description
DataSet ndataset
string sql
string tablename
View Source

Open(DataSet, string, string, int, ISqlExecuterPartialFillEvent)

Declaration
public void Open(DataSet ndataset, string sql, string tablename, int maxrecords, ISqlExecuterPartialFillEvent nevent)
Parameters
Type Name Description
DataSet ndataset
string sql
string tablename
int maxrecords
ISqlExecuterPartialFillEvent nevent
View Source

OpenInmediate(DataSet, string, string)

Declaration
public DataTable OpenInmediate(DataSet ndataset, string sql, string tablename)
Parameters
Type Name Description
DataSet ndataset
string sql
string tablename
Returns
Type Description
DataTable
View Source

Rollback()

Declaration
public void Rollback()
View Source

RollbackInmediate()

Declaration
public void RollbackInmediate()
View Source

StartTransaction()

Declaration
public void StartTransaction()
View Source

StartTransaction(IsolationLevel)

Declaration
public void StartTransaction(IsolationLevel nlevel)
Parameters
Type Name Description
IsolationLevel nlevel

Implements