Skip to content

API Library ADO

Robert Polak edited this page Aug 9, 2019 · 31 revisions

Home / API Library / ADO

API Library ADO handle SQL Server. The API Library ADO Methods list with Parameters.

Configuration

Configuration of ADO variables at App.config.

More details about The Server API Library Configuration at Configuration API - ADO


ADO

API Library ADO handle SQL Server Open Connection to Data Base (defaultConnection).

Method: API.ADO.ADO

Parameters:

Name Type Default Description
connectionName String API_ADO_DEFAULT_CONNECTION default Connection

Return: Void.


OpenConnection

Open Connection to Data Base.

Method: API.ADO.OpenConnection

Parameters:

Name Type Default Description
connectionName String API_ADO_DEFAULT_CONNECTION default Connection

Return: void.


CloseConnection

Close Connection to Data Base.

Method: API.ADO.CloseConnection

Parameters:

Name Type Default Description
onDispose Bool false default Connection

Return: void.


StartTransaction

Start Transaction on active Data Base Connection.

Method: API.ADO.StartTransaction

Parameters:

Name Type Default Description
transactionIsolation IsolationLevel IsolationLevel.Snapshot Isolation Level

More detail Snapshot Isolation Level SQL Server at Snapshot Isolation Level SQL Server

Return: void.


ResetTransaction

Reset Transaction on active Data Base Connection.

Method: API.ADO.ResetTransaction

Parameters: N/A

Return: void.


CommitTransaction

Commit Transaction on active Data Base Connection.

Method: API.ADO.CommitTransaction

Parameters: N/A

Return: void.


RollbackTransaction

Rollback Transaction on active Data Base Connection.

Method: API.ADO.RollbackTransaction

Parameters: N/A

Return: void.


ExecuteNonQueryProcedure

Execute Non Query Procedure on active Data Base Connection.

Method: API.ADO.ExecuteNonQueryProcedure

Parameters:

Name Type Default Description
procedureName String Procedure Name
inputParams Array[ADO_inputParams] inputParams Input Params
returnParam object Return Param
outputParam object ADO_outputParam Output Param