Error during save

   Hello, 
I am keep on seeing following exception when saving in silverlight.:

"Store update, insert, or delete statement affected an unexpected number of rows(0). Entities may have been modified or deleted since entities were loaded. Referesh ObjectStateManager entries". 

This error usually happens if I were to save multiple objects. It saves successfully to database, but when checking for error once the Async save has been completed there is an exception. I also noticed this message when I am the only updating records, so i don�t think this would be concurrency issue when though it looks like.   Does anyone know what could be the underlying issue?

Thanks,
Amit

Author	Message Share Topic Printable Version Delicious Digg Facebook Furl Google Boomarks Google Buzz MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search Topic Options Post Reply Create New Topic
amit007 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: Mar-10-2009 Posts: 10	Post Options Post Reply Quote amit007 Report Post Quote Reply Topic: Error during save Posted: Apr-15-2010 at 10:36am
	Hello, I am keep on seeing following exception when saving in silverlight.: "Store update, insert, or delete statement affected an unexpected number of rows(0). Entities may have been modified or deleted since entities were loaded. Referesh ObjectStateManager entries". This error usually happens if I were to save multiple objects. It saves successfully to database, but when checking for error once the Async save has been completed there is an exception. I also noticed this message when I am the only updating records, so i don�t think this would be concurrency issue when though it looks like. Does anyone know what could be the underlying issue? Thanks, Amit

davidklitzke Members Profile Send Private Message Find Members Posts Add to Buddy List IdeaBlade Joined: Jun-14-2007 Posts: 690	Post Options Post Reply Quote davidklitzke Report Post Quote Reply Posted: Apr-15-2010 at 10:55am
	Have you tried looking at these links? http://msmvps.com/blogs/kevinmcneish/archive/2009/12/03/understanding-the-entity-framework-concurrencyexception-store-update-insert-or-delete-statement-affected-an-unexpected-number-of-rows.aspx http://naspinski.net/post/Store-update2c-insert2c-or-delete-statement-affected-an-unexpected-number-of-rows-(0)-Entities-may-have-been-modified-or-deleted-since-entities-were-loaded-Refresh-ObjectStateManager-entries.aspx

amit007 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: Mar-10-2009 Posts: 10	Post Options Post Reply Quote amit007 Report Post Quote Reply Posted: Apr-15-2010 at 11:29am
	All my updates are done via ideaBlade. I am not explicitly attaching or detaching entities, plus all the fields in EntityManager are set to CuncurrencyMode="None". If I had any of the fields CuncurrencyMode set to Fixed then this error would have made sense.

davidklitzke Members Profile Send Private Message Find Members Posts Add to Buddy List IdeaBlade Joined: Jun-14-2007 Posts: 690	Post Options Post Reply Quote davidklitzke Report Post Quote Reply Posted: Apr-16-2010 at 7:18am
	See if you can identify any of the entities causing the concurrency violation: Please see the solution in the Concurrency Conflicts folder in the Learning Resources at LearningResources\040_BusObjPersistence\ConcurrencyConflicts

amit007 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: Mar-10-2009 Posts: 10	Post Options Post Reply Quote amit007 Report Post Quote Reply Posted: Apr-21-2010 at 8:21am
	It turns out that if i call saves twice in program within millisecond, i will see the error. Now I am checking if there is already save in progress, then wait for second save to complete.