Removing Locking that is not needed

Locking is overused specifically for Business Process. If you don't absolutely need it - remove it.

The reason you see too much locking in migrated applications is that in magic locking was the default, and also locking was implied when you wanted to update. It's perfectly safe to update without looking in most cases.

This is especially true for application that were migrated from Pervasive to SQL, where the lock only exists for a millisecond and is almost always redundant.

protected override void OnLoad()
    {
-       RowLocking = LockingStrategy.OnRowLoading;
-       TransactionScope = TransactionScopes.Task;
        AllowUserAbort = true;
    } 

Help us improve, Edit this page on GitHub
or email us at info@fireflymigration.com