Thanks,
Bill

I am starting to see that.  Nevertheless, I am still quite confused about the custom property thing.  To me, the business object is an ideal place for some of these things.  The database is not the best location.  You and Trent are suggesting that I need to relocate the business logic back into the database.

Here is an example of some custom properties on the Parts business object that I have (declarations/tags/comments removed for brevity):

public int OnWorkOrder
{
    get
    {
        string mPartindex = this.partindex.ToString();
        return (int)ExecuteScalar("spx_GetAmountOnWorkOrder '" + mPartindex + "'");
    }
}

public int OnSalesOrder
{
    get
    {
        string mPartindex = this.partindex.ToString();
        return (int)ExecuteScalar("spx_GetAmountOnSalesOrder '" + mPartindex + "'");
    }
}

public int RequiredQty
{
    get
    {
        int mReqQty = (this.minstocklevel - this.onhandqty) + (this.OnSalesOrder - this.OnWorkOrder);
        if (mReqQty < 0) mReqQty = 0;
        return mReqQty;
    }
}

As you can see, the logic becomes rather complex.  Easily handled in the business object.  The stored procedure that would handle this same stuff would be atrocious...doable, but a near nightmare to construct.  I really do not want to put all this back into the DB.  If I do, then these custom properties become unneeded.  In fact, I cannot see a good use for custom properties, since all of this can be done in the DB.

Bill

ArgumentException
  An item with the same key has already been added.

Source     : mscorlib

Stack Trace:
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at MicroFour.StrataFrame.UI.Windows.Forms.BrowseDialogSearchingEventArgs..ctor(BrowseDialog Browse, WhereStatementCollection WhereStatements)
   at MicroFour.StrataFrame.UI.Windows.Forms.BrowseDialogwindow.ExecuteSearch()
   at MicroFour.StrataFrame.UI.Windows.Forms.BrowseDialogwindow.tsiSearch_Click(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
   at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Thought I had something there...I was going to plop a browsedialog on the form and force the user to work through that (with the custom property set to not visible).  Not sure what that error means, but I assume it is saying, "Uh uh uh!".  That won't work, I guess.