Manage multiple concurrent inserts in sql server db using c#

Question

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

Regards V.

bcp, BULK INSERT... bulk load syntax.

OMG Ponies
– OMG Ponies

2012-02-17 05:11:09 +00:00
Commented Feb 17, 2012 at 5:11 — OMG Ponies
– OMG Ponies, Commented Feb 17, 2012 at 5:11

Branko Dimitrijevic · Accepted Answer · 2012-02-17 05:52:24Z

2

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"?

answered Feb 17, 2012 at 5:52

Branko Dimitrijevic

52.3k12 gold badges104 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Manage multiple concurrent inserts in sql server db using c#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related