API Library ADO
Home / API Library / ADO
API Library ADO
API Library ADO handle SQL Server. The API Library ADO Methods list with Parameters, Return examples.
Configuration- Details
Configuration of ADO variables at App.config.
<configuration>
<AppSettings>
<!-- ADO - Default Connection Name -->
<add key="API_ADO_DEFAULT_CONNECTION" value="defaultConnection" />
<!-- ADO - Execution timeout in seconds -->
<add key="API_ADO_EXECUTION_TIMEOUT" value="600" />
<!-- ADO - Bulk Copy timeout in seconds -->
<add key="API_ADO_BULKCOPY_TIMEOUT" value="600" />
<!-- ADO - Bulk Copy BatchSize in rows (below 5000 to avoid Table locking) -->
<add key="API_ADO_BULKCOPY_BATCHSIZE" value="4999" />
</AppSettings>
<connectionStrings>
<add name="defaultConnection" connectionString="Server=;Initial Catalog=;User ID=;Password=;Persist Security Info=False;Column Encryption Setting=enabled;" />
</connectionStrings>
</configuration>ADO - Details
API Library ADO handle SQL Server Open Connection to Data Base.
Method: API.ADO.ADO
Parameters: connectionName
| Name | Type | Default | Description |
|---|---|---|---|
connectionName |
String | API_ADO_DEFAULT_CONNECTION |
default Connection |
Return: Access to SQL Server.
Open Connection- Details
Open Connection to Data Base.
Method: API.ADO.OpenConnection
Parameters: connectionName
| Name | Type | Default | Description |
|---|---|---|---|
connectionName |
String | API_ADO_DEFAULT_CONNECTION |
default Connection |
Return: void.
Open Connection- Details
Close Connection to Data Base.
Method: API.ADO.CloseConnection
Parameters: onDispose
| Name | Type | Default | Description |
|---|---|---|---|
onDispose |
Bool | false |
default Connection |
Return: void.
Start Transaction - Details
Start Transaction on active Data Base Connection.
Method: API.ADO.StartTransaction
Parameters: transactionIsolation
| Name | Type | Default | Description |
|---|---|---|---|
transactionIsolation |
IsolationLevel | IsolationLevel.Snapshot |
Isolation Level |
IsolationLevel enum - Details
* A different isolation level than the one specified is being used, but the level
cannot be determined.
`Unspecified `= -1,
* The pending changes from more highly isolated transactions cannot be overwritten.
`Chaos `= 16,
A dirty read is possible, meaning that no shared locks are issued and no exclusive
locks are honored.
`ReadUncommitted `= 256,
Shared locks are held while the data is being read to avoid dirty reads, but
the data can be changed before the end of the transaction, resulting in non-repeatable
reads or phantom data.
`ReadCommitted `= 4096,
* Locks are placed on all data that is used in a query, preventing other users
from updating the data. Prevents non-repeatable reads but phantom rows are still
possible.
`RepeatableRead `= 65536,
* A range lock is placed on the System.Data.DataSet, preventing other users from
updating or inserting rows into the dataset until the transaction is complete.
`Serializable `= 1048576,
* Reduces blocking by storing a version of data that one application can read while
another is modifying the same data. Indicates that from one transaction you cannot
see changes made in other transactions, even if you requery.
`Snapshot `= 16777216Return: void.
Reset Transaction- Details
Reset Transaction on active Data Base Connection.
Method: API.ADO.ResetTransaction
Parameters: N/A
Return: void.
Commit Transaction- Details
Commit Transaction on active Data Base Connection.
Method: API.ADO.CommitTransaction
Parameters: N/A
Return: void.
Rollback Transaction- Details
Rollback Transaction on active Data Base Connection.
Method: API.ADO.RollbackTransaction
Parameters: N/A
Return: void.
