2
In a network system (Several using the same database), how do I know if any user is already editing the record. Because if in case two computers edit the same record at the same time, a problem occurs because only the changes of the last user who edited will be saved.
2
If you’re using the Entity Framework, use Data Annotation [Concurrencycheck], which the context itself will help you handle the competition, check on http://www.entityframeworktutorial.net/code-first/concurrencycheck-dataannotations-attribute-in-code-first.aspx. Also check the link passed in the @Qmechanic73 comment, https://msdn.microsoft.com/en-us/library/aa0416cz%28v=vs.110%29.aspx
Browser other questions tagged c# sql-server entity-framework
You are not signed in. Login or sign up in order to post.
User, as it is an edition made by users, I do not see this type of control as a good thing, after all you have no way of knowing if the user who started the editing process will finish or inform that you no longer want to edit that file. It may be more interesting for the user to see the latest changes made and their author
– Tobias Mesquita
@user18748, but even so if you block and then release for editing, this last change will be validated. Sometimes swimming against the current doesn’t make any sense. But look at the link from Qmechanic73, I read it and I think it solves your problem.
– pnet