DevForce Community Forum : ConcurrencyConflicts Learning Resources http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : ConcurrencyConflicts Learning Resources Sat, 11 Apr 2026 15:31:31 -700 Thu, 04 Mar 2010 19:30:38 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1667 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ ConcurrencyConflicts Learning Resources : Will inform my colleague, Viola,... http://www.ideablade.com/forum/forum_posts.asp?TID=1667&PID=6301#6301 Author: sebma
Subject: 1667
Posted: 04-Mar-2010 at 7:30pm

Will inform my colleague, Viola, who caught this, not me ;-)

Thanks much.]]> Thu, 04 Mar 2010 19:30:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1667&PID=6301#6301 ConcurrencyConflicts Learning Resources : Hey, good catch, Sebastian! Looks... http://www.ideablade.com/forum/forum_posts.asp?TID=1667&PID=6300#6300 Author: IdeaBlade
Subject: 1667
Posted: 04-Mar-2010 at 6:42pm

Hey, good catch, Sebastian! Looks like that little critter has been in there for a while.

Each of the saves, including the one in step 3, does update the RowVersion value in the database. But when the save doesn't go through because of a concurrency conflict, and you then elect to force your local changes through, we make that possible by jury rigging the entity so it thinks it's not in conflict with the version in the database.

That we do with this call to RefetchEntity in method ResolveMyConflicts():

   pEntityManager.RefetchEntity(pEntityWithError, MergeStrategy.PreserveChangesUpdateOriginal);

The idea there is that we'll leave EntityVersion.Current for the entity as is (so your local changes remain in place), but update EntityVersion.Original to the same set of values that currently exist in the database for the entity in question. That way, when we resubmit the entity for saving, the concurrency engine won't see a conflict anymore (between the value of RowVersion that it finds in the database and the EntityVersion.Original value in the entity). 

The problem is that, because we're only updating the original values from the database, the current value for RowVersion is now actually 1 behind its value in the database. So when the save increments it by 1, it ends up being exactly equal to the value currently in the database. The save goes through, and the RowVersion value is updated in the database, but it is updated to the same value it had before. So then the next save doesn't realize the record got changed in the period since it was retrieved.

The fix is to include the following code right after the above-referenced call to RefetchEntity():

      // Set the Current values of the concurrency columns to what we just
      // got from the database in our call to RefetchEntity(). We want them to
      // enter the Save in the same state they would if we had retrieved the
      // entity from the database in the state it has there now and THEN made
      // our changes.
      EntityMetadata instanceMetadata = pEntityWithError.EntityAspect.EntityMetadata;
      foreach (DataEntityProperty property in instanceMetadata.ConcurrencyProperties) {
        property.SetValue(pEntityWithError,
          (pEntityWithError as BaseEntity).GetRawPropertyValue(
          property, EntityVersion.Original));
      }

]]> Thu, 04 Mar 2010 18:42:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1667&PID=6300#6300 ConcurrencyConflicts Learning Resources : Not sure if anyone encountered... http://www.ideablade.com/forum/forum_posts.asp?TID=1667&PID=6278#6278 Author: sebma
Subject: 1667
Posted: 02-Mar-2010 at 10:16pm

Not sure if anyone encountered this from the Learning Resources Sample for ConcurrencyConflicts.

We found Concurrency Conflicts are not handled from the following issue steps:
 
0. Use sample code @..\IdeaBlade DevForce\Learning Resources\040_BusObjPersistence\ConcurrencyConflicts\Samples\300WNF_WinForms\CodeCS\UI\ConcurrencyHandler.cs
 
1. Call ResolveMyConflicts(...) to resolve conflicts
 
2. Modify a field (e.g. employee-> firstname) in app1, save, "Save Succeeded".

3. Update the same field in app2, save, a messagebox of the detailed conflicts will be shown, choose to save own copy, "Save Succeeded"

4. Then update the same field again in app1. No warning about conflicts, end up with "Save Succeeded" again.
 
Cause of problem: concurrency column(RowVersion) won't be updated by user2's SaveChanges()@step3. Which means @step4, app1 thinks its copy is the latest because of the RowVersion == the latest RowVersion in DB.

Is the above as designed?

Thanks
Sebastian
 
]]> Tue, 02 Mar 2010 22:16:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1667&PID=6278#6278