DevForce Community Forum : Deleting an Object http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Deleting an Object Wed, 29 Apr 2026 15:18:30 -700 Fri, 06 Feb 2009 08:33:44 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1086 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Deleting an Object : IdeaBlade does not normally automatically... http://www.ideablade.com/forum/forum_posts.asp?TID=1086&PID=3885#3885 Author: davidklitzke
Subject: 1086
Posted: 06-Feb-2009 at 8:33am

IdeaBlade does not normally automatically delete related entities.  For example, if I delete an Order, it is probably incorrect to delete the Customer associated with that Order. Therefore, in most cases, you must delete the related entities yourself.
 
 There are some exceptions to this rule (see the Intermediate tutorial on "Cascading Deletes").


Edited by davidklitzke - 06-Feb-2009 at 8:34am]]> Fri, 06 Feb 2009 08:33:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1086&PID=3885#3885 Deleting an Object : I have the following database... http://www.ideablade.com/forum/forum_posts.asp?TID=1086&PID=3884#3884 Author: msosa
Subject: 1086
Posted: 06-Feb-2009 at 6:23am

I have the following database structure:
 
Table: User
Fields: Id, Name, Password, Status
 
Table: Rol
Fields: Id, Description
 
Table UserRol
Fields: UserId, RolId
 
So, I mapped those tables to devforce objects. Now, I can insert or update the objects and then calling SaveChanges() to the manager, everithing works all right.
 
The problem that I'm facing is that when I want to delete an User object, witch has some roles asigned and call SaveChanges(), the following error arises:
 
Save failed - The statement has been terminated.
The DELETE statement conflicted with the REFERENCE constraint "FK_UsuarioRol_Usuario"
 
The problem, I presume, is that the persistence engine is not deleting the related rows in UsuarioRol table, so when tries to delete the User the constraint error apperars... Is this by desing? What should I do?
 
Thanks.
]]> Fri, 06 Feb 2009 06:23:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1086&PID=3884#3884