Re: Mapping SQL Result Sets to Browsers

I know these were aimed at Maurice, but...

What language do you use?

C#, although it would work in any .Net language.

How do you handle foreign key instantiation?

Not sure what you mean. To you mean linkages between objects.
(OrderLine->Order->Customer)? If so, we code for them. Not that the code
is complex:

#region Property Contact
public Contact Contact
{
get
{
EnsureLoaded();
if (_Contact == null)
_Contact =
Contact.GetContact(_Contact_ID);
return _Contact;
}
}
#endregion

How do you specify that a calculation is done once when the object is
retrieved as opposed to every time the getter method is invoked?

We code it. Again, not complex. For example, the "calculation" in the
example above is to only retrieve the Contact if it's not already
retrieved.

Do you cache instances?

No, although we're considering it. However, in our design requirements
for it we require synchronization across web servers so that's part of
the plan (and the cause for the delay). Besides, we're subsecond on page
loads w/out it. :)

Do you make dirty instances visible between sessions?

No.

Do you perform notifications when database changes occur?

No.

--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)