Repository navigation
API Library ADO
Home / API Library / ADO
Configuration of ADO variables at App.config.
More details about The Server API Library Configuration at Configuration API - 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.
Open Connection to Data Base.
Method: API.ADO.OpenConnection
Parameters:
| Name | Type | Default | Description |
|---|---|---|---|
connectionName |
String | API_ADO_DEFAULT_CONNECTION |
default Connection |
Return: void.
Close Connection to Data Base.
Method: API.ADO.CloseConnection
Parameters:
| Name | Type | Default | Description |
|---|---|---|---|
onDispose |
Bool | false |
default Connection |
Return: void.
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.
Reset Transaction on active Data Base Connection.
Method: API.ADO.ResetTransaction
Parameters: N/A
Return: void.
Commit Transaction on active Data Base Connection.
Method: API.ADO.CommitTransaction
Parameters: N/A
Return: void.
Rollback Transaction on active Data Base Connection.
Method: API.ADO.RollbackTransaction
Parameters: N/A
Return: void.
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 |