View Single Post
 
Old May 1st, 2009, 05:00 AM
yevi yevi is offline
Authorized User
 
Join Date: Mar 2009
Posts: 75
Thanks: 16
Thanked 1 Time in 1 Post
Default

What should be the actual implementation?
I was thinking about 2 options:

1)Create a new category "Uncategorised" - make it protected against
deletion operation.Then assign id of this category as default value to
CategoryId column in Articles table.
Finally set the relationship delete rule to "Set Default"

2)Without creating any category, just assigning a default value(maybe 0 or
-999).
When articles are listed, we check if it assigned to category with id 0 (so
there is no matched category in category table for this id) and manually
set "Uncategorised" caption.


*Both options would have SP DeleteCategoryWithArticles(categoryId)