The difficulty is in entering and maintaining the DB Table And Column Names in code. Doing so manually is a tedious, time consuming and error prone process. This is particularly true when a database is being designed and set up during a development project. Or when an application is being developed to interface with an existing database. Keeping the database table and column names in code in sync with the database can be challenging.
That's where DBExpose comes in. Using this wizard, creation and maintenance of the DB Table And Column Names in code is an easy process that is typically completed in seconds.
DBExpose is a FREE development tool that speeds and simplifies the building of a VB.NET Module, VB.NET Class or C#.NET Class that exposes, in code, the table and column names from either an Access, SQL, MySQL or dBase database. The generated Module or Class will expose one, all or a selection of tables in the connected database. Once built, the generated .vb or .cs file is ready to be added to a Visual Studio project as an existing item.
DBExpose creates an entirely new module whenever it is run. There is no maintenace mode where, for example, only the changes to a database table are made in an existing project module. Generating an entire module is so quick that trying to do maintenance would most likely take longer. Ergo, each time DBExpose is run a file generated during a previous run for the same database is completely replaced with an updated copy.
DBExpose is used whenever any changes have been made to a database. In other words, if there is any doubt whatsoever that the database table and column names being used in code are in sync with the database, run DBExpose to generate an up to date module or class.
RazorSQL - RazorSQL is a SQL database query tool, SQL editor, database browser, and administration tool with support for all major databases and built in connection capabilities for DB2, Derby, Firebird,... ...