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

 

Support@Wiker.net

www.Wiker.net