Re: Mapping SQL Result Sets to Browsers

["Maurice O'Prey" <maurice.oprey@xxxxxxxxx>]

Walden

A quick apology. I know you know more than me :-)

Maurice


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Walden H. Leverich
Sent: 08 July 2008 21:29
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] 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.)