passing ArrayLists to database

From: Ken (Ken_at_discussions.microsoft.com)
Date: 10/06/04

  • Next message: Guhanath: "Single Sign-on with IIS and Oracle Application Server" 
    Date: Tue, 5 Oct 2004 21:55:01 -0700

    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
  • Next message: Guhanath: "Single Sign-on with IIS and Oracle Application Server"

    Relevant Pages

    • passing ArrayLists to DB
      ... I have to pass large objects (class intances) to SQL 2000 DB. ... usually contains ArrayLists of other objects (also classes intances). ... The final update is being done using stored procedures. ... What would be the best way to pass the ArrayLists as parameters to the ...
      (microsoft.public.dotnet.framework.performance)
    • RE: passing ArrayLists to DB
      ... This question was unswered in the distributed application newsgroup. ... > usually contains ArrayLists of other objects (also classes intances). ... The final update is being done using stored procedures. ...
      (microsoft.public.dotnet.framework.performance)