Divooka.Database.ODBC
Divooka.Database.ODBC.ODBCHelper
An Divooka style API with explicit configuration for all methods and returns Divooka.DataAnalytics.DivookaDataGrid
Divooka.Database.ODBC.ODBCHelper.ConfigureODBC()
Configures the DSN for the ODBC service.
Parameters
| Name | Description | Default |
|---|---|---|
dsn |
A DSN name. Notice the application requires x64 DSNs. |
Returns
An ODBC service configuration
Divooka.Database.ODBC.ODBCHelper.Query()
Query raw DataTable
Divooka.Database.ODBC.ODBCHelper.Command()
Executes one or many SQL commands in a single transaction (auto-commit).
A sql string may itself contain several statements separated by semicolons.
Parameters
| Name | Description | Default |
|---|---|---|
sql |
Divooka.Database.ODBC.ODBCHelper.Command()
Executes an explicit list / array of SQL commands in a single transaction.
Divooka.Database.ODBC.ODBCHelper.SplitSql()
Very small SQL-script splitter: cuts on ';' that are **not** inside single or double quotes.
Good enough for ad-hoc admin scripts; replace with a full SQL parser if we need 100 % accuracy.
ODBC.ODBCPure
Remarks
Formerly static "Main" for Pure.
ODBC.ODBCPure.DSN
Sets the DSN to connect to.
Always set this prior to calling any query functions.
ODBC.ODBCPure.Query()
Query raw DataTable
ODBC.ODBCPure.Select``1()
Select strongly typed rows from the query.
This is one of THE most commonly used function of this library.
ODBC.ODBCPure.Insert()
Execute an insert query.
Automatically commits.
Equivalent to Command(); This function is just provided for semantic clarity.
ODBC.ODBCPure.Update()
Execute an update query.
Automatically commits.
Equivalent to Command(); This function is just provided for semantic clarity.
ODBC.ODBCPure.Delete()
Execute a delete query.
Automatically commits.
Equivalent to Command(); This function is just provided for semantic clarity.
ODBC.ODBCPure.Command()
Execute arbitrary SQL command.
Automatically commits.
ODBC.ODBCPure.OpenTransaction
Starts a transaction. The transaction object has the same sort of interfaces as the Main interface.