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

  ClassDescription
Public classCCondition
Used to create lists of conditions that must pass for an operation to be performed (WHERE)
Public classCConditionCommon
Common functions for CCondition class
Public classCDatabase
Do not use the CDatabase class directly. Use the preallocated WIDatabase.Database variable instead.

Functions to interact directly with the database.

Available functions include:

  • Create - Creates a database on the server
  • Delete - Deletes a database from the server
  • Exists - Checks if a database has already been created on the server
Public classCDatabaseInfo
Structure containing database location and login information.

Used when creating a new WIDatabase variable

Public classCDelete
Do not use the CDelete class directly. Use the preallocated WIDatabase.Delete variable instead.

Functions to Delete records from tables.

Public classCIndex
Do not use the CIndex class directly. Use the preallocated WIDatabase.Index variable instead.

Functions to interact with table Indexes.

Available functions include:

  • Create - Creates a table Index
  • Delete - Deletes a table Index
  • Exists - Checks if a table Index has already been created
Public classCInsert
Do not use the CInsert class directly. Use the preallocated WIDatabase.Insert variable instead.

Functions to Insert data into tables.

Public classCInsertItem
Used with WIDatabase.Insert.Bulk() to Bulk insert data into tables
Public classCSearch
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:

  • Clear - Clear previous search criteria and results. Not required if first time used.
  • Column - Select tables and columns with optional aliases of data to be retrieved
  • Table - Set main table to retrieve data from
  • Condition - Define conditions (WHERE) of search
  • Execute - Execute the search upon the database
  • Read - Read a single record or loop though all results
  • Get - Get data from record just retrieved from Read() and store in selected variables

 

 

Optional operations:
  • Join - Retrieve data from more than one table
  • Count - Return number of records in table
  • Distinct - Return number of different/distinct records in table
  • DistinctCount - Number of different/distinct records in table
  • Sort - Select how to sort search results
  • Limit - Specify how many results to return
Public classCTable
Do not use the CTable class directly. Use the preallocated WIDatabase.Table variable instead.

Functions to interact with Tables.

Available functions include:
  • Create - Creates a table in the database
  • Delete - Deletes a table from the database
  • Exists - Checks if a table has already been created in the database
  • GetColumnInfo - Returns information about columns in a table
Public classCUpdate
Do not use the CUpdate class directly. Use the preallocated WIDatabase.Update variable instead.

Functions to update records in tables.

Public classCUpdateItem
Used with WIDatabase.Update.Bulk() to Bulk Update data into tables
Public classSETTINGS
Various global library settings
Public classTableColumnItem
Contains information about table columns returned from function WIDatabase.Table.GetColumnInfo()
Public classWIDatabase
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.

Public classWIDBUtil
Functions to handle generic low level database operations using the SQL SELECT Language

Enumerations

  EnumerationDescription
Public enumerationeDatabaseType
Database vendor to use
Public enumerationeDataType
Database column types
Public enumerationeDBErrorCodes
Database error codes
Public enumerationeJoinType
Table Join Type.

Joins are used to query data from two or more tables, based on a relationship between columns

Public enumerationeLogic
How CCondition(WHERE) clauses combine
Public enumerationeOperator
Compare operators for Search conditions
Public enumerationeSort
Sort Types.

How to sort results.

Public enumerationeTrim
Data string space trim settings