Multiple instances of a C# Application updating a single MSSQL table

Question

We have several instances of our application running at the same time at various places.

And all instances execute an insert or update query on a single table Orders.

Orders
---------------------------------------

OrderID OrderDate OrderTime OrderAmount

The question is, if all instances of my application insert or update records at the same time, what might happen?

How does MSSQL database handle this scenario?

I googled out and found ROWLOCK, XLOCK, READPAST as a solution on concurrent access to MSSQL database but could not find an exact answer for the above scenario!

Any pointers is much appreciated.

[`MERGE`](http://msdn.microsoft.com/en-us/library/bb510625.aspx) — Remus Rusanu, Jan 27 '14 at 09:18
You can use the SQLTransaction Class like this: [enter link description here][1] [1]: http://stackoverflow.com/a/1127839/809613 — YJ Chen, Jan 27 '14 at 09:45
You can use the SQLTransaction Class like [this:][1] [1]: http://stackoverflow.com/a/1127839/809613 — YJ Chen, Jan 27 '14 at 09:47

score 1 · Accepted Answer · answered Jan 27 '14 at 09:22

Each INSERT or UPDATE will run in an (implicit) transaction such that the statements will be queued. This should normally not be a problem.

If the INSERT or UPDATE statements are part of a batch with other statements which need to be run uninterrupted (such as first reading from a table, then updating the table based on the result), you should consider enclosing these statements in an explicit BEGIN TRANSACTION / COMMIT TRANSACTION clause.

score 0 · Answer 2 · answered Jan 27 '14 at 09:20

0

You should read up on Transactions. This will enable you to avoid any data corruption which will occur from your current setup.

answered Jan 27 '14 at 09:20

Chris L

2,262
1
18
33

Multiple instances of a C# Application updating a single MSSQL table

2 Answers2