Advance 3-tier architecture

[Monish30]

Hi,
I am using 3-tier architecture using C# as code behind language. I am making BO , BLL , DAL. I am using store procedure for insert, update ,delete , select Operation.

BO
I am making property of database field. For each database table i am making seperate BO.

DAL
I am making static method for insert update delete select operation by passing the object of BO. For each database table i am making seperate DAL_tablename

BLL
Business logic is used to call the DAL and get the data. ALL business logic are written there which need to check before calling the data.

For each database table i am making seperate storeprocedure and in that for particular table insert update delete selec t operation are there.

Now i need advance architecture. When i Delete data i need to delete for all child table to. And when i need to save data i need to save data in Master table as well as child table. If any update is happen in Master table then its also update in child table. In BO i am making object of foreign key table so that when i get the data the data is also get in that object. Its like employMaster table and employLeaveDetail. Then in BO of employMaster i am making object of employleaveDetail because employMaster has leaveDetail. has a relationship is there between table.

Please guide me i am much confuse how to achieve this task using pure oops
Thanks in advance

[Frinavale]

This sounds like a job for the Database to handle.
Your stored procedures should do this.

What database are you using?

[themenace]

Have you looked into Entity Framework? It has OR mapping that you're looking for and knows the relationship between entities (tables). It will handle related records and can be updated or deleted as queried.