DevForce Community Forum : SaveChangesAsync http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : SaveChangesAsync Thu, 14 May 2026 18:37:18 -700 Tue, 18 Jan 2011 18:15:19 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2448 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ SaveChangesAsync : OK, thanks, I didn't know... http://www.ideablade.com/forum/forum_posts.asp?TID=2448&PID=9687#9687 Author: gregweb
Subject: 2448
Posted: 18-Jan-2011 at 6:15pm

OK, thanks, I didn't know that about the EntityAspect, I will try using that.
 
Greg
]]> Tue, 18 Jan 2011 18:15:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2448&PID=9687#9687 SaveChangesAsync : Greg, How exactly are you... http://www.ideablade.com/forum/forum_posts.asp?TID=2448&PID=9680#9680 Author: sbelini
Subject: 2448
Posted: 18-Jan-2011 at 3:16pm

Greg,

 
How exactly are you deleting the entity? (code)
 
You should be using:
 
myEntity.EntityAspect.Delete();
 
Also, when exactly are you getting the exception? When calling SaveChanges?
 
Silvio.
]]> Tue, 18 Jan 2011 15:16:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2448&PID=9680#9680 SaveChangesAsync : I have a grid with entities with... http://www.ideablade.com/forum/forum_posts.asp?TID=2448&PID=9673#9673 Author: gregweb
Subject: 2448
Posted: 17-Jan-2011 at 7:03pm

I have a grid with entities with a delete button.  When I delete an item I basically just set IsDeleted to true on the Entity and Save the Item.  This works fine.  However, if there are two deletes in a row, the second delete throws an error.  Is there a recommended handling for this?  In Ria Services, I stopped using SaveChanges, and just used an InvokeMethod and saved the item manually.
 
Do you have any recommendations on this?
 
Greg
 
Entity Save Error: System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SELECT `vemailmessageentities`.`FolderId`, `vemailmessageentities`' at line 1 at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySql.Data.Entity.EFMySqlCommand.ExecuteNonQuery() at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at IdeaBlade.EntityModel.Edm.EdmSaveExecutor.ProcessSaves(IEnumerable`1 groupsByType) at IdeaBlade.EntityModel.Edm.EdmSaveExecutor.SaveWithinContext() at IdeaBlade.EntityModel.Edm.EdmSaveExecutor.Save(DataSourceResolver dataSourceResolver, IDataSourceKey dsKey, SaveWorkState workState)
]]> Mon, 17 Jan 2011 19:03:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2448&PID=9673#9673