Click here to Skip to main content
11,477,625 members (74,444 online)
Click here to Skip to main content
Articles » Database » Database » Databases » Downloads
Add your own
alternative version

Object-Oriented database design with the DatabaseObjects library

, 31 Jan 2007 82.3K 3.3K 62
Demonstrates creating object-oriented database systems with the DatabaseObjects library.
databaseobjects_demo_net.zip
VB.NET
demo
source
Northwind
NorthwindDB
bin
Northwind.vbproj.user
AxInterop.SHDocVw.dll
DatabaseObjects.dll
Interop.SHDocVw.dll
Northwind.exe
NorthwindDatabase.dll
NorthwindDatabase.vbproj.user
Attributes
bin
Database
DatabaseObjects.vbproj.user
Misc
SQL
DatabaseObjects.dll
Data
mysql_northwind.zip
Documentation
DatabaseObjects.chm
databaseobjects_demo_vb6.zip
VB6
demo
regsvr32.exe
source
Northwind
Northwind.vbg
NorthwindDB
ControlAnchor.cls
frmMain.frm
frmMain.frx
frmOrder.frm
frmOrder.frx
frmProducts.frm
frmProducts.frx
frmProductSearch.frm
frmProductSearch.frx
frmProductSearchExtended.frm
frmProductSearchExtended.frx
frmSuppliers.frm
frmSuppliers.frx
Northwind.exe
northwind.RES
Northwind.vbp
Categories.cls
Category.cls
Data.bas
LateBoundObject.cls
NorthwindDatabase.cls
NorthwindDatabase.OBJ
NorthwindDB.dll
NorthwindDB.vbp
Order.cls
OrderDetail.cls
OrderDetails.cls
Orders.cls
Product.cls
Products.cls
ProductSearch.cls
Supplier.cls
Suppliers.cls
bin
Database.cls
DBO.vbp
GlobalDatabase.cls
GlobalDatabaseObjects.cls
IDatabaseObject.cls
IDatabaseObjects.cls
IGlobalDatabaseObjects.cls
ISQLStatement.cls
modMisc.bas
SQLAlterTable.cls
SQLAutoIncrementValue.cls
SQLCondition.cls
SQLConditionFieldCompare.cls
SQLConditionInSelect.cls
SQLConditions.cls
SQLConditionSelect.cls
SQLCreateIndex.cls
SQLCreateTable.cls
SQLDelete.cls
SQLDropIndex.cls
SQLDropTable.cls
SQLFieldValue.cls
SQLFieldValues.cls
SQLIndexExists.cls
SQLIndexField.cls
SQLIndexFields.cls
SQLInsert.cls
SQLSelect.cls
SQLSelectField.cls
SQLSelectFields.cls
SQLSelectGroupByField.cls
SQLSelectGroupByFields.cls
SQLSelectOrderByField.cls
SQLSelectOrderByFields.cls
SQLSelectTable.cls
SQLSelectTableJoin.cls
SQLSelectTableJoinCondition.cls
SQLSelectTableJoinConditions.cls
SQLSelectTableJoins.cls
SQLSelectTables.cls
SQLTableExists.cls
SQLTableField.cls
SQLTableFields.cls
SQLUpdate.cls
SQLUpdateCopyField.cls
SQLUpdateCopyFields.cls
DatabaseObjects_vb6.dll
mysql_northwind.zip
images
templates
databaseobjects_classdiagram.jpg
logo.jpg
databaseobjects_src_net.zip
DatabaseObjects.vbproj.user
DatabaseObjects.dll
databaseobjects_src_vb6.zip
Database.cls
DBO.vbp
GlobalDatabase.cls
GlobalDatabaseObjects.cls
IDatabaseObject.cls
IDatabaseObjects.cls
IGlobalDatabaseObjects.cls
ISQLStatement.cls
modMisc.bas
SQLAlterTable.cls
SQLAutoIncrementValue.cls
SQLCondition.cls
SQLConditionFieldCompare.cls
SQLConditionInSelect.cls
SQLConditions.cls
SQLConditionSelect.cls
SQLCreateIndex.cls
SQLCreateTable.cls
SQLDelete.cls
SQLDropIndex.cls
SQLDropTable.cls
SQLFieldValue.cls
SQLFieldValues.cls
SQLIndexExists.cls
SQLIndexField.cls
SQLIndexFields.cls
SQLInsert.cls
SQLSelect.cls
SQLSelectField.cls
SQLSelectFields.cls
SQLSelectGroupByField.cls
SQLSelectGroupByFields.cls
SQLSelectOrderByField.cls
SQLSelectOrderByFields.cls
SQLSelectTable.cls
SQLSelectTableJoin.cls
SQLSelectTableJoinCondition.cls
SQLSelectTableJoinConditions.cls
SQLSelectTableJoins.cls
SQLSelectTables.cls
SQLTableExists.cls
SQLTableField.cls
SQLTableFields.cls
SQLUpdate.cls
SQLUpdateCopyField.cls
SQLUpdateCopyFields.cls
DatabaseObjects_vb6.dll
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="default.css" rel="stylesheet" type="text/css">
</head>

<body>
<h1><strong>Welcome to the DatabaseObjects demonstration</strong><br>
</h1>
<p>This program provides some examples of the different ways the Database
  Objects (DBO) library can be used. Currently,
  the
  DBO
  library
  can
  successfully connect to SQL Server and Microsoft Access databases. If you would
  like me to add another database feel free to send me an email - <a href="mailto:toby.wicks@aviationsoftware.com.au">toby.wicks@hisystems.com.au</a>.
  By default the
  program will connect to the <strong>C:\Program Files\Microsoft Visual Studio\VB98\nwind.mdb </strong>  database.
  The nwind.mdb database is available at the Microsoft website <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=EN" target="_blank">here</a> should
  you need it. If you would like to test with SQL
  Server uncomment
  the
  NorthWindDB.Connect_SQLServer
  function in frmMain and change the database server if necessary. Or to test
  with MySQL extract the mysql version of the northwind database from <a href="../../../../data/mysql_northwind.zip">data/mysql_northwind.zip</a> into
  the data directory and uncomment the NorthWindDB.Connect_MySQL function in
  frmMain. To view all
  of the SQL statements that are being executed, turn
  on
  the DebugSQL compilation
  option in the DatabaseObjects project.</p>
<p>The .NET version provides an additional method of using
  the DatabaseObjects library (as opposed to the VB6 version) with the inclusion
  of the DatabaseObjects, DatabaseObjectsEnumerable and DatabaseObject
  MustInherit/abstract classes. These classes still implement the IDatabaseObjects
  and IDatabaseObject interfaces
  but implement the
  basic
  functionality that they require, and provide a more convenient and
  intuitive use of the library. The demonstration program utilises both the interface
  and inheritance methods; the Suppliers
  and Supplier classes demonstrate implementing the IDatabaseObjects and IDatabaseObject
  interfaces, the Products and Product classes demonstrate inheriting
  from the DatabaseObjects and DatabaseObject MustInherit/abstract classes.<br>
</p>
<h3>1. View Suppliers</h3>
<p>Demonstrates some of the DBO basics, including adding, editing
  and deleting a list of suppliers. It also demonstrates maintaing referential
  integrity by not allowing  suppliers to be deleted if they are referenced
  by a product. This particular feature is implemented in the Supplier.IsDeletable
  property.</p>
<h3><br>
  2. View Products </h3>
<p>Demonstrates the use of the Subset
  function in the Products class. Subset allows the Products
  class to either contain ALL of the products in the database or only contain
  the products for a particular category.</p>
<h3><br>
  3. View an Order</h3>
<p>Demonstrates an implementation for a <em>header </em>and
  associated<em> detail</em> table. In this example, with the Orders and OrderDetails
  tables.</p>
<h3><br>
  4. Search Products</h3>
<p>Demonstrates how to implement the SearchCriteria
function in the Products class.</p>
<h3><br>
  5. Search Products (Extended)</h3>
<p>Demonstrates a more complex set of search criteria as opposed
  to the simple search demonstrated in the 'Search Products' window.
  It also demonstrates joining tables (in this case the Products table
  and
  the Supplier table) to optimise the loading speed of the products, in addition
  to demonstrating how to load a
Product and Supplier object from the same database record.</p>
<h3><br>
  6. Territories &amp; Regions</h3>
<p>Demonstrates the use of the Territory and Region classes. </p>
</body>
</html>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Toby Wicks

United States United States
No Biography provided

| Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.150520.1 | Last Updated 31 Jan 2007
Article Copyright 2005 by Toby Wicks
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid