Looks like another option is to keep track of the changes
with something like the Unit Of Work pattern in Patterns of Enterprise
Architecture, by Martin Fowler. I'm thinking I'll try that
route.
Nathan
From: Nathan Ward [mailto:[EMAIL PROTECTED]
Sent: Monday, October 09, 2006 7:35 AM
To: [email protected]
Subject: Re: Updating Multiple Tables per Single Root Object
Hello,
I'm considering how
best to update a list of objects referenced by a "root" object. I see a
discussion of this topic from July (http://www.mail-archive.com/[email protected]/msg05237.html).
In order to update
the related tables, I suppose my DAO needs to query those tables in order to
compare to the in-memory list to figure out if objects have been added and/or
removed in order to know what operations need to be done on those tables. Is
that correct? I suppose this processing is why Larry suggests that stored
procedures for this would be faster. Is that right?
Nathan
Nathan Ward
ResQSoft, Inc.
703.861.9103
www.resqsoft.com
