Wrox Programmer Forums
|
BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio
This is the forum to discuss the Wrox book ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solution by Vincent Varallo; ISBN: 9780470396865
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 26th, 2009, 10:46 AM
Authorized User
 
Join Date: Mar 2008
Posts: 62
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via Yahoo to kalel_4444
Default DB Foreign Key - Delete Rule not set to Cascade ?

Hello,

In the sample database, there are a couple of tables that I've come across and would think they should 'cascade' and delete the FK table row(s) when deleting the PK table row, but it's set to 'No Action'.
  • This relationship does NOT delete
  • ENTUserAccount (pk) --> ENTRoleUserAccount (fk)
  • ENTCapability (pk) --> ENTRoleCapability (fk)
  • But, these DO...
  • ENTRole (pk) --> ENTRoleUserAccount (fk)
  • ENTRole (pk) --> ENTRoleCapability (fk)
Not sure if this is intentional or an error? Any confirmation, explanation, or thoughts on this is appreciated.

Ronnie





Similar Threads
Thread Thread Starter Forum Replies Last Post
Similar Delete Cascade prasanna.nadgir C# 6 August 28th, 2007 04:12 AM
Foreign key not updating with Primary key xavier1945 BOOK: Access 2003 VBA Programmer's Reference 2 July 4th, 2007 09:48 PM
Delete MS Access Foreign Key from Code pkipe Access 3 February 21st, 2006 06:45 PM
FOREIGN KEY and PRIMARY KEY Constraints junemo Oracle 10 June 15th, 2004 01:00 AM
Urgent: Implement Cascade Delete through Code rcmetta BOOK: Professional Crystal Reports for VS.NET 0 June 7th, 2004 12:49 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.