how to perform Nested "INSERT" for object heirarchy which is connected to database?
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