Interface ISqlExecuter

Abstraction over a database connection used by the reporting engine to run SQL, open result sets, manage transactions, batch inserts, and obtain generator values, independent of the underlying data driver.

Namespace: Reportman.Drawing

Assembly: Reportman.Drawing.dll

Syntax

public interface ISqlExecuter

Methods

View Source

AddCustomOperation(int, string, byte[])

Declaration

void AddCustomOperation(int operation, string data, byte[] binarydata)

Parameters

Type	Name	Description
int	operation
string	data
byte[]	binarydata

View Source

AddExternalColumnsToLastCommand(string, string)

Declaration

void AddExternalColumnsToLastCommand(string externalcolumns, string deletes)

Parameters

Type	Name	Description
string	externalcolumns
string	deletes

View Source

BeginInsertBlock()

Declaration

void BeginInsertBlock()

View Source

Commit()

Declaration

void Commit()

View Source

Connect()

Declaration

void Connect()

View Source

CreateCommand(string)

Declaration

DbCommand CreateCommand(string cadsql)

Parameters

Type	Name	Description
string	cadsql

Returns

Type	Description
DbCommand

View Source

Disconnect()

Declaration

void Disconnect()

View Source

EndInsertBlock()

Declaration

void EndInsertBlock()

View Source

Execute(DbCommand)

Declaration

void Execute(DbCommand ncommand)

Parameters

Type	Name	Description
DbCommand	ncommand

View Source

Execute(string)

Declaration

void Execute(string sql)

Parameters

Type	Name	Description
string	sql

View Source

ExecuteInmediate(string)

Declaration

int ExecuteInmediate(string sql)

Parameters

Type	Name	Description
string	sql

Returns

Type	Description
int

View Source

Flush()

Declaration

void Flush()

View Source

Flush(ISqlExecuterProgressEvent)

Declaration

void Flush(ISqlExecuterProgressEvent pgevent)

Parameters

Type	Name	Description
ISqlExecuterProgressEvent	pgevent

View Source

GetGenerator(string, int)

Declaration

long GetGenerator(string generatorName, int increment)

Parameters

Type	Name	Description
string	generatorName
int	increment

Returns

Type	Description
long

View Source

GetValueFromSql(string)

Declaration

object GetValueFromSql(string sql)

Parameters

Type	Name	Description
string	sql

Returns

Type	Description
object

View Source

Open(DataSet, DbCommand, string)

Declaration

void Open(DataSet ndataset, DbCommand command, string tablename)

Parameters

Type	Name	Description
DataSet	ndataset
DbCommand	command
string	tablename

View Source

Open(DataSet, string, string)

Declaration

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

void Open(DataSet ndataset, string sql, string tablename, int maxrecords, ISqlExecuterPartialFillEvent eventpartial)

Parameters

Type	Name	Description
DataSet	ndataset
string	sql
string	tablename
int	maxrecords
ISqlExecuterPartialFillEvent	eventpartial

View Source

OpenInmediate(DataSet, string, string)

Declaration

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

void Rollback()

View Source

RollbackInmediate()

Declaration

void RollbackInmediate()

View Source

StartTransaction(IsolationLevel)

Declaration

void StartTransaction(IsolationLevel nisolation)

Parameters

Type	Name	Description
IsolationLevel	nisolation