469,602 Members | 1,799 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Cascade updating/deleting and 3 tier architecture

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

Sep 25 '06 #1
1 1320
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

Sep 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Fraser Hanson | last post: by
25 posts views Thread by David Noble | last post: by
4 posts views Thread by Patrick | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.