setting concurrency mode of sqlcommand

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i updated a large amount of data with sqlcommand, will this command lock the table for other users to read, write?
is there any code for setting these concurrency mode? Thanks for your help!

Tabo
 
How are you doing your update? You can set the Concurrency type in the DA
Configuration Wizard. The COmmand Builder doesn't let you manipulate it.
Check out Bill Vaughn's article at www.betav.com Articles, MSDN -> Weaning
Developers from the CommandBuilder.

HTH,

Bill
Tabo said:
When i updated a large amount of data with sqlcommand, will this command
lock the table for other users to read, write?
 
Tabo,
It is very interesting topic and there is no concies article. Currently, I
am working on the post about Optimistic Concurrency and ADO.NET for my blog
www.ipattern.com. I should publish it sometimes next week.

Thanks, Maxim

Tabo said:
When i updated a large amount of data with sqlcommand, will this command
lock the table for other users to read, write?
 
Back
Top