B
Bart
Using SQL Server...my question specifically revolves
around triggers
If there is business logic in triggers..should that be
moved over to the business layer when creating a new
application?
The reason I ask this is because the application I am
working with now, has lots of triggers. The only way
really to abstract large portions of it is to have stored
procedures (which has its faults, because u then have to
write loop logic instead of writing possible single
insert\update statemments using the inserted\deleted
tables). I was thinking to move this to the business
layer with transactional processing?
Any one else have come across a design problem like this?
around triggers
If there is business logic in triggers..should that be
moved over to the business layer when creating a new
application?
The reason I ask this is because the application I am
working with now, has lots of triggers. The only way
really to abstract large portions of it is to have stored
procedures (which has its faults, because u then have to
write loop logic instead of writing possible single
insert\update statemments using the inserted\deleted
tables). I was thinking to move this to the business
layer with transactional processing?
Any one else have come across a design problem like this?