DataAdapter.Update - batch or round trips?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew Stephen (andrew.stephen_at_imagesoft-fiserv.com)
Date: 03/03/04 

Date: 2 Mar 2004 16:44:26 -0800

Hi - I've seen several clues to this but I wonder if any experts can
definitively confirm ......

Does the DataAdapter.Update method pass all updated datarows to the
database for some kind of batch process with multiple calls to the
update command but only one open and close of the connection, or does
it do multiple round trips to the database and multiple connection
open/closes, one for each updated datarow?
(My specific interest is in the OracleDataAdapter but I'm guessing the
answer applies to all DB providers).

Thanks for any responses.

Relevant Pages

  • Re: Caching Queries in DataTable
    ... I am implementing this by storing the command ... database itself is likely to cache query results. ... values and the generated DataRows that have been queried thus far. ... How can I be sure that my hash codes ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Quickest way to update a DataColumns values?
    ... collection of "DataRows" in Memory. ... But if your concern is efficiency of updating database, ... UPDATE SQL statement to database directly. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Store data into Access
    ... because you are talking about Datarows. ... This method you show is probably just to store values in a database by ... > I have a small table in an Access database, ... I looked at the view SQL in Access ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Datatable to string array.
    ... Just a peanut, but what you are using is not a string array. ... It is an arraylist filled with datarows. ... now each table in my database can be accessed by idex number in the ...
    (microsoft.public.dotnet.languages.csharp)
  • Manipulating the size of the track and knob in a scrollbar of a JTable
    ... I only want to load the datarows from the database when they ... from where data is loaded from the database. ... datamodel is therefore always the size of the rows visible. ... databasetable and not to the rowcount of the datamodel. ...
    (comp.lang.java.gui)