N
Nemisis
Hi all,
I was wondering about where this code should go.
Basically i have several tables in my database, when i add a row to a
particular table, i will need to also add other entries in other
tables.
I would consider this to be code that should be in the BOL? Am i right
in thinking that?
The same if i was deleting records in the database, if a record is
deleted from one table, i need to also delete other entries in other
tables, BOL or DAL?
My database is setup with relationships so SQL will report errors on
foreign keys that cannot be deleted, so this is the one reason why i
thought it may go in the DAL, but then again, it is a business rule,
that if one row is deleted in one table, other row in other tables
should be deleted.
Can someone please let me know, or pass an article for me to read.
Cheers
I was wondering about where this code should go.
Basically i have several tables in my database, when i add a row to a
particular table, i will need to also add other entries in other
tables.
I would consider this to be code that should be in the BOL? Am i right
in thinking that?
The same if i was deleting records in the database, if a record is
deleted from one table, i need to also delete other entries in other
tables, BOL or DAL?
My database is setup with relationships so SQL will report errors on
foreign keys that cannot be deleted, so this is the one reason why i
thought it may go in the DAL, but then again, it is a business rule,
that if one row is deleted in one table, other row in other tables
should be deleted.
Can someone please let me know, or pass an article for me to read.
Cheers