Welcome

Welcome to the Database Objects website. The site is for VB6 and .NET programmers interested in developing object-oriented systems to encapsulte their relational database systems and business logic. Object-oriented design together with the DatabaseObjects library can significantly simplify the development and maintenance of small and large systems by providing a mechanism to consolidate business logic, maintain data integrity, increase productivity and minimise errors.

  Database Library - Object Relation Mapper

The DatabaseObjects library is a.NET object relational mapping tool that contains a large set of powerful classes that interface to the underlying database system. Classes and properties in the business layer / model are marked with attributes (or functions overridden) in order to indicate the table and field mappings to the database. The library is simple, powerful and easy to learn. There are no external files to setup - everything is setup using standard object-oriented techniques. It is light-weight, flexible and provides facilities for ensuring maximum performance. It is also under active development and requests for changes are always welcome. The source code is hosted on GitHub here.

SQL Code Generation

The library also supports other database commands for creating / altering tables, indexes, views and specifying table joins, arithmetic expressions, aggregates, grouping, ordering, unions and support for all common data types and more. All commands are database agnostic. There are two versions of the library one for VB6 and .NET. Both versions support access to Microsoft Access, SQL Server, MySQL. The .NET library also supports Pervasive and HyperSQL database systems. The library can be used for commercial and non-commercial purposes.

  Why Another Object-Relational Mapper?

There are a number of object-relational mapping tools available, some open source and some providing extensive features. My general experience has been that they are overly complicated to learn and use. Unlike most other tools available, this library is simple, powerful and quick to learn, and not limited in any way. There are no external files to setup - everything is setup using standard object-oriented techniques. It is light-weight, flexible and provides facilities for ensuring maximum performance. And because it is open source you can 'peek' under the hood if you need to. It can also be easily retro-fitted into your existing applications. There is simply nothing this library cannot handle!

The library has been extensively tested and used on a number of large projects written for the aviation and transport industries. Specifically:

• Airstrips Management Software for Australian Pilots
• Aircraft Currency
• Task Management and Software
• Warehousing/Logistics software
• Accounting Software
• Payroll

If you have any questions or comments please feel free to email me toby.wicks@hisystems.com.au