Oh, and please post this to the new newsgroups. A lot of folks have gone on digest mode. Or unsubscribed to this one entirely.
Thanks, Bob -----Original Message----- From: Beauchemin, Bob Sent: Friday, June 14, 2002 7:11 PM To: [EMAIL PROTECTED] Subject: Re: [DOTNET] ADO.NET Roundtrip DataAdapter Question It doesn't connect to the database 7 times, but it would make 7 round trips. By default; unless you code it differently, remember there are a couple of hooks in the process, including complete manual control. It does this in order to judge success or failure of each action statement (0 or non-zero rows affected, non-zero = success). You can transact these statement series (manually) as well. If you use a CommandBuilder, the provider may make an extra round trip for metadata to build commands (one per CommandBuilder instance). Hope this helps, Bob Beauchemin [EMAIL PROTECTED] -----Original Message----- From: Matthew Hunter [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 5:09 PM To: [EMAIL PROTECTED] Subject: [DOTNET] 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. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
