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/AS...&link_code=as1

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

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Nemisis" <da*********@hotmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...

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