WIDatabase is a .Net 3.5 library which simplifies interfacing with various database vendors 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 vendors.
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.
/* Simple example to search table 'tblPeople' returning data in columns 'FirstName' & 'LastName' */
WIDatabase WIDB;
string First, Last;
WIDB = new WIDatabase("c:\\Sqlite.db3"); /* Open SQLite Database */
WIDB.Search.Table("tblPeople"); /* Search Table 'tblPeople' */
WIDB.Search.Column("FirstName"); /* Request data in columns 'FirstName' & 'LastName' */
WIDB.Search.Column("LastName");
WIDB.Search.Execute(); /* Perform search request */
while(WIDB.Search.Read()) /* Loop though results */
{
WIDB.Search.Get("LastName", out Last); /* Get data in 'LastName' */
WIDB.Search.Get("FirstName", out First); /* Get data in 'FirstName' */
}
WIDB.Close(); /* Close Database */
Key Features of WIDatabase
· Knowledge of the SQL Language is not required
· Modularized into major feature categories (Search, Insert, Update, etc)
· One set of code for any supported database
· Request and retrieve data by column names not ordinal/index
· Record results are read as objects then converted to requested data type there by eliminating the need to know the exact table structure
· No royalties fees
Supported Environments
· Windows 7
· Windows Vista
· Windows XP
· Windows 2000
· Windows 2000 Server and newer
Supported Databases
· Microsoft SQL Server
· MySQL (MySql.com)
· SQLite (www.SQLite.org)
Contact Us
Wiker Industries LLC
1476 Lititz Pike
Suite 106
Lancaster PA. 17601