Loading

prevent Multiple users read / update table at same time

Piyush Mohan

7y3.5k

I have proplem i have table Buyer with fields BuyerId,BuyerNAme,Email Id

In my company more one user can edit in same record in same time

How to allow only one user to edit record and another user when edit same record

get message the record edit now by another user

if possible help me

what i can do to prevent this proplem

my database sql server 2017,visual studio 2017

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sourav Mukherjee7y ago
Hi Piyush, Read through the SQL Server isolation levels to implement a correct solution for you.

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-2017
0
Sanwar Ranwa7y ago
Hello Piyush

Please check these Links

https://www.youtube.com/watch?v=TWv2jpmxaf8

https://www.codeproject.com/Articles/114262/6-ways-of-doing-locking-in-NET-Pessimistic-and-opt

https://technet.microsoft.com/en-us/library/cc917674.aspx

https://stackoverflow.com/questions/13432489/concurrent-updates-handling-in-asp-net-or-sql-server-2008

https://www.red-gate.com/simple-talk/dotnet/net-framework/using-entity-framework-with-an-existing-database-data-access/
0