Object-Oriented database design with the DatabaseObjects library

Toby Wicks

Rate me:

4.00/5 (6 votes)

31 Jan 20076 min read

109.4K

3.9K

Demonstrates creating object-oriented database systems with the DatabaseObjects library.

databaseobjects_src_net.zip
- VB.NET
  - source
databaseobjects_demo_net.zip
- Data
  - mysql_northwind.zip
- Documentation
  - DatabaseObjects.chm
  - default.css
  - demo
    - Northwind.sln
    - Northwind
      - AssemblyInfo.vb
      - bin
        
        AxInterop.SHDocVw.dll
        
        DatabaseObjects.dll
        
        DatabaseObjects.xml
        
        default.css
        
        Interop.SHDocVw.dll
        
        Northwind.exe
        
        Northwind.xml
        
        NorthwindDatabase.dll
        
        NorthwindDatabase.xml
        
        welcome.html
      - frmInputDialog.resx
      - frmInputDialog.vb
      - frmMain.resX
      - frmMain.vb
      - frmOrder.resX
      - frmOrder.vb
      - frmProducts.resX
      - frmProducts.vb
      - frmProductSearch.resX
      - frmProductSearch.vb
      - frmProductSearchExtended.resX
      - frmProductSearchExtended.vb
      - frmSuppliers.resX
      - frmSuppliers.vb
      - Northwind.vbproj
      - Northwind.vbproj.user
      - Northwind.xml
    - NorthwindDB
      - AssemblyInfo.vb
      - Categories.vb
      - Misc.vb
      - NorthwindDatabase.vbproj
      - NorthwindDatabase.vbproj.user
      - NorthwindDatabase.xml
      - NorthwindDB.vb
      - Orders.vb
      - Products.vb
      - Regions.vb
      - Suppliers.vb
      - Territories.vb
      - FieldMappingAttribute.vb
      - FieldMappingObjectHookAttribute.vb
      - DatabaseObjects.dll
      - DatabaseObjects.xml
      - Database.vb
      - DatabaseObject.vb
      - DatabaseObjectLockable.vb
      - DatabaseObjectLockController.vb
      - DatabaseObjects.vb
      - DatabaseObjectsEnumerable.vb
      - DatabaseObjectsVolatile.vb
      - DatabaseObjectUsingAttributes.vb
      - DatabaseObjectUsingAttributesLockable.vb
      - IDatabaseObject.vb
      - IDatabaseObjectLockable.vb
      - IDatabaseObjects.vb
      - IGlobalDatabaseObjects.vb
      - ObjectReference.vb
    - DatabaseObjects.sln
    - DatabaseObjects.vbproj
    - DatabaseObjects.vbproj.user
    - DatabaseObjects.xml
    - AssemblyInfo.vb
    - Exceptions.vb
    - Exceptions.vb
    - ISQLStatement.vb
    - Misc.vb
    - SQL.vb
    - SQLAutoIncrementValue.vb
    - SQLCondition.vb
    - SQLConditionFieldCompare.vb
    - SQLConditionInSelect.vb
    - SQLConditions.vb
    - SQLConditionSelect.vb
    - SQLCreateIndex.vb
    - SQLDelete.vb
    - SQLDropIndex.vb
    - SQLDropTable.vb
    - SQLFieldValue.vb
    - SQLFieldValues.vb
    - SQLInsert.vb
    - SQLSelect.vb
    - SQLSelectField.vb
    - SQLSelectFields.vb
    - SQLSelectGroupByField.vb
    - SQLSelectGroupByFields.vb
    - SQLSelectOrderByField.vb
    - SQLSelectOrderByFields.vb
    - SQLSelectTable.vb
    - SQLSelectTableJoin.vb
    - SQLSelectTableJoinCondition.vb
    - SQLSelectTableJoinConditions.vb
    - SQLSelectTableJoins.vb
    - SQLSelectTables.vb
    - SQLStatement.vb
    - SQLTable.vb
    - SQLTableExists.vb
    - SQLTransactions.vb
    - SQLUnion.vb
    - SQLUpdate.vb
    - SQLUpdateCopyFields.vb
databaseobjects_src_vb6.zip
- VB6
  - source
databaseobjects_demo_vb6.zip
- mysql_northwind.zip
- DatabaseObjects_Connect.htm
- DatabaseObjects_Object.htm
- DatabaseObjects_ObjectByKey.htm
- DatabaseObjects_ObjectByOrdinal.htm
- DatabaseObjects_ObjectByOrdinalFirst.htm
- DatabaseObjects_ObjectDelete.htm
- DatabaseObjects_ObjectExists.htm
- DatabaseObjects_ObjectFromFieldValues.htm
- DatabaseObjects_ObjectFromRecordset.htm
- DatabaseObjects_ObjectItem.htm
- DatabaseObjects_ObjectSave.htm
- DatabaseObjects_ObjectsCollection.htm
- DatabaseObjects_ObjectsCount.htm
- DatabaseObjects_ObjectsDeleteAll.htm
- DatabaseObjects_ObjectsSearch.htm
- DatabaseObjects_QuickStart.htm
- default.css
- GlobalDatabase_GlobalObject.htm
- IDatabaseObject.htm
- IDatabaseObject_DistinctValue.htm
- IDatabaseObject_IsSaved.htm
- IDatabaseObject_Load.htm
- IDatabaseObject_Save.htm
- IDatabaseObjects.htm
- IDatabaseObjects_DistinctFieldAutoIncrements.htm
- IDatabaseObjects_DistinctFieldName.htm
- IDatabaseObjects_ItemInstance.htm
- IDatabaseObjects_KeyFieldName.htm
- IDatabaseObjects_OrderBy.htm
- IDatabaseObjects_Subset.htm
- IDatabaseObjects_TableJoins.htm
- IDatabaseObjects_TableName.htm
- IGlobalDatabaseObjects.htm
- IGlobalDatabaseObjects_Object.htm
- images
  - databaseobjects_classdiagram.jpg
  - logo.jpg
  - reference.htm
  - templates
  - demo
    - Northwind.vbg
    - Northwind
      - ControlAnchor.cls
      - default.css
      - 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
      - welcome.html
    - NorthwindDB
      - 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
  - Open Demo & Register Dlls.bat
  - regsvr32.exe
  - DatabaseObjects_vb6.dll
  - 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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/templates/function.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Database Objects</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
<link href="default.css" rel="stylesheet" type="text/css">
</head>

<body>
<h1>

<h1><!-- InstanceBeginEditable name="heading" -->DatabaseObjects	<!-- InstanceEndEditable --></h1>
<h3><!-- InstanceBeginEditable name="subheader" -->ObjectByOrdinalFirst(<span class="keyword">ByVal</span>    objCollection <span class="keyword">As</span> IDatabaseObjects) <span class="keyword">As</span> IDatabaseObject<!-- InstanceEndEditable --><br>
</h3>
</h1>

<!-- InstanceBeginEditable name="text" -->
<p>ObjectByOrdinalFirst returns the first object in the collection sorted by
  the collection's <a href="IDatabaseObjects_OrderBy.htm">IDatabaseObjects_OrderBy</a>.
  It differs from ObjectByOrdinal in that it only loads the first record from
  the database table not the entire table.</p>
<!-- InstanceEndEditable --><font face="Courier New, Courier, mono">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td bgcolor="#f6f6f6"><pre><!-- InstanceBeginEditable name="example" --><span class="keyword">
Dim</span> objDefaultSupplier<span class="keyword"><font face="Courier New, Courier, mono"> As</font></span><font face="Courier New, Courier, mono"> Supplier</font>
<span class="comment">
'<font face="Courier New, Courier, mono">ObjectByOrdinalFirst is ideal for loading </font>default ob<font face="Courier New, Courier, mono">jects</font></span>
<span class="keyword"><font face="Courier New, Courier, mono">Set</font></span><font face="Courier New, Courier, mono"> objDefaultSupplier = DBO.ObjectByOrdinalFirst(objGlobalSuppliersInstance)</font>

<!-- InstanceEndEditable --></pre></td>
  </tr>
</table>
</font>

<p>&nbsp;</p>
<p align="center"><font size="1">�  Hi Integrity Systems 2005. All rights reserved.</font></p>
</body>

<!-- InstanceEnd --></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

Written By

Toby Wicks

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Object-Oriented database design with the DatabaseObjects library

License

Comments and Discussions