Hi,
I have to pass large objects (class intances) to SQL 2000 DB. The objects
usually contains ArrayLists of other objects (also classes intances). The
objects are returning from the client and some of their data was maybe
modified by the user. The final update is being done using stored procedures.
Few questions:
1. What would be the best systematic way to find out what properties in the
object was modified - taking into account that some of the properties are
collection of other objects?

2. I would like to be as chunky as possible but without updating what need
not to be updated. So on one hand I want to pass the data with the minimum
numbers of calls to the DB, and on the other hand I don't want to send the
whole object and update data the the user did not modified. This is
especially important with the Arraylist as any update means locking a row in
the table for nothing.

3. What would be the best way to pass the ArrayLists as parameters to the
stored procedure? I was thinking converting them to datasets or to xml
strings?

Thanks,

--
Ken

This question was unswered in the ditributed application newsgroup.
Thanks,
Ken

"Ken" wrote: