ADO.NET Roundtrip DataAdapter Question

Guys,

When using the SQLDataAdapter or OLEDBDataAdapter to talk to the database, if you set each of the commands (ie. Select, Insert, update and delete) how many round trips does it do to the database?

For example, obviously the FILL function would use the Select statement and this would only have to contact the database once, but how about the UPDDATE command?  If you changed 5 records in the database and then added 2, would it need to contact the database 7 times or is it smart enough to send the commands as a batch and therefore only have to contact the database once?

Cheers

Matthew Hunter

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.