CODEWITHSUNDEEP
.netsqlsql-serversql-server-2008ado.net
viraz
viraz

Reputation: 45

Manage multiple concurrent inserts in sql server db using c#

How can we manage 1000s of concurrent insert at a time in sql server using c#...

Regards V.

Upvotes: 0

Views: 799

Answers (1)

Branko Dimitrijevic
Branko Dimitrijevic

Reputation: 52117

You'll need to think what kind of transaction isolation will provide the right mix of performance and correctness. Also, each concurrent transaction will need to be inside its own SqlConnection (BeginTransaction will throw an exception if you try to call it without first ending the previous transaction).

I can't say more until you explain what you mean by "manage"?

Upvotes: 2

Related Questions