Cascade updating/deleting and 3 tier architecture

[Nemisis]

Hi everyone,

Wonder if anyone can shed some light on how i should setup cascade
deletes of object data within my database.

One option is to use SQL triggers, is this a good idea? Should the
logic be in my business layer instead? or maybe even the data access
layer?

I also have the problem when performing an insert. If i insert a
record into one table, i also need to insert other values into foreign
key tables. Again, where do i do this?

This is my first 3 tier application and i am not sure which way i
should set this up, so any help would be greatful.

Thanks in advance

 

[Steve C. Orr [MVP, MCSD]]

This is a complex subject.
I suggest you read the following book which is widely considered to the the
authority on the subject:

Expert VB 2005 Business Objects (by Rocky Lhotka)
http://www.amazon.com/exec/obidos/A...14573&adid=0MN5QNXF4KW05MF3J962&link_code=as1

or here's the C# version if you prefer:
http://www.amazon.com/exec/obidos/A...14573&adid=0DX2YFNHQP6HRCVHN7X0&link_code=as1