DevForce Community Forum : Cascading Delete http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Cascading Delete Sat, 11 Apr 2026 11:23:30 -700 Mon, 20 Aug 2012 13:17:49 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3587 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Cascading Delete : Sven,I could not reproduce the... http://www.ideablade.com/forum/forum_posts.asp?TID=3587&PID=14231#14231 Author: sbelini
Subject: 3587
Posted: 20-Aug-2012 at 1:17pm

Sven,
 
I could not reproduce the issue here.
I am attaching a sample solution where I took the same steps as you did: updated the database for cascade delete the orders related to a customer (I updated the FK_Order_Customer Delete Rule to Cascade), updated the model from database, and ran the sample. (Note I attached a "modified version of NorthwindIB, so you wouldn't run into other constraints while trying to delete)
uploads/892/T12077.zip
 
Regards,
   Silvio. 
 
 
]]> Mon, 20 Aug 2012 13:17:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3587&PID=14231#14231 Cascading Delete : Hi,I created cascading deletions... http://www.ideablade.com/forum/forum_posts.asp?TID=3587&PID=14210#14210 Author: sven4tmn
Subject: 3587
Posted: 17-Aug-2012 at 2:37am

Hi,

I created cascading deletions on SqlServer, updated my entity model and ran custom tool. Now, if I delete a entity the child record's foreign key changes to empty guid and switches state to modified. Saving changes tries now to save modified child entity and retrieves error from DB (foreign key violation). Deleting entity directly on SqlServer works fine and cascades deletion.

Do I need further settings or what am I doing wrong?

Thank you
Sven

DevForce: 6.1.8
Cocktail: 1.0

]]> Fri, 17 Aug 2012 02:37:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3587&PID=14210#14210