WIDatabase is a .Net 3.5 library which simplifies interfacing with various database venders without the need to know or use the SQL Language. This allows for one version of source code to be used with different databases with the simple flip of a software switch.
Knowledge of the SQL Language is not require as WIDatabase has simplified the major database functionality into basic function calls and automatically handles the differences and oddities of each database type there by removing the learning curve when dealing with multiple database venders.
Advanced functionality is available using the SQL Language in conjunction with low level function calls within the WIDatabase library.
The trial version of WIDatabase displays a persistent popup dialog that can be minimized but not closed. The retail full version does not contain this popup dialog.
Classes
Class | Description | |
---|---|---|
![]() | CCondition |
Used to create lists of conditions that must pass for an operation to be performed (WHERE)
|
![]() | CConditionCommon |
Common functions for CCondition class
|
![]() | CDatabase | Do not use the CDatabase class directly. Use the preallocated WIDatabase.Database variable instead.
Functions to interact directly with the database. Available functions include:
|
![]() | CDatabaseInfo |
Structure containing database location and login information.
Used when creating a new WIDatabase variable |
![]() | CDelete | Do not use the CDelete class directly. Use the preallocated WIDatabase.Delete variable instead.
Functions to Delete records from tables. |
![]() | CIndex | Do not use the CIndex class directly. Use the preallocated WIDatabase.Index variable instead.
Functions to interact with table Indexes. Available functions include:
|
![]() | CInsert | Do not use the CInsert class directly. Use the preallocated WIDatabase.Insert variable instead.
Functions to Insert data into tables. |
![]() | CInsertItem |
Used with WIDatabase.Insert.Bulk() to Bulk insert data into tables
|
![]() | CSearch | Do not use the CSearch class directly. Use the preallocated WIDatabase.Search variable instead.
Functions to Search (SELECT) data records from a database. Following steps are required for proper operation:
Optional operations:
|
![]() | CTable | Do not use the CTable class directly. Use the preallocated WIDatabase.Table variable instead.
Functions to interact with Tables. Available functions include:
|
![]() | CUpdate | Do not use the CUpdate class directly. Use the preallocated WIDatabase.Update variable instead.
Functions to update records in tables. |
![]() | CUpdateItem |
Used with WIDatabase.Update.Bulk() to Bulk Update data into tables
|
![]() | SETTINGS |
Various global library settings
|
![]() | TableColumnItem |
Contains information about table columns returned from function WIDatabase.Table.GetColumnInfo()
|
![]() | WIDatabase |
Starting point of library.
Once an instance is created, access to all functions and variables are available. Constructor for WIDatabase must contain server location and login information. WIDatabase is designed to be a single connection to a single database. If more than one connection to a server or database is required, multiple instances of WIDatabase must be created. |
![]() | WIDBUtil |
Functions to handle generic low level database operations using the SQL SELECT Language
|
Enumerations
Enumeration | Description | |
---|---|---|
![]() | eDatabaseType | Database vendor to use |
![]() | eDataType | Database column types |
![]() | eDBErrorCodes | Database error codes |
![]() | eJoinType | Table Join Type.
Joins are used to query data from two or more tables, based on a relationship between columns |
![]() | eLogic | How CCondition(WHERE) clauses combine |
![]() | eOperator | Compare operators for Search conditions |
![]() | eSort | Sort Types.
How to sort results. |
![]() | eTrim | Data string space trim settings |