I think you could use transaction in database I'm not sure whether you are using ADO.NET directly or any ORM but definitely Transaction is way to go. Transactions in database make sure that it maintains the concurrency of database. Following is couple of link how you could use transactions with ADO.NET and Orms like Entity Framework.
codeproject.com/Articles/10223/Using-Transactions…
This is how you can do with ORMs like entity framework