Hii to All,

My Question is,

I have developed object hierarchy. Now i want to strore data from object hierarchy to database. I have datatbse where each object in hierarchy connected to one table in database.

Root node table's primary key is used as foreign key for leaf node tables. So, i have to first perform "Insert" for root node table and then get the primary key and use to store leaf node data into it's attached table.

In my design i have seperate database layer where each class is connected to one table in database. I did this because i want to seperate functional classes from database classes.

How i can implement this using ADO or ADO.Net?

Any example or reference or suggestions are welcomed....

Thanks....

HDave