Conversion of Business Objects to Flat Data Table and Viceversa...

[Shibu]

Hi,

I have a situation where I need to convert business objects to a flat table.
The reverse is also required. I am using c# and Oracle ODP. I am looking for
an easier method to do the below steps.

Steps I follows for populating Business Objects is as follows
(1) Get a list of records containing various tables joined together from DB
using a single PL/SQL
(This is a specific requirement, So cannot change the design)

Data will be redundent as shown below.

eg:- COLUMNS
ParentTable.Id, ParentTable.Nam e, ChildTable1.Id, ChildTable1.Nam e,
ChildTable2.Id, ChildTable2.Nam e

Sample data with respect to the above columns

1 "A" 1 "a" 1 "aa"
1 "A" 1 "a" 2 "bb"
1 "A" 2 "b" 1 "aa"
1 "A" 2 "b" 2 "bb"
1 "A" 2 "b" 3 "cc"
1 "A" 3 "c" 1 "bb"

(2) Iterate through each row and applying logic to separate data required to
build Buiness object
Eg., of business object :-

ParentClass
{
//contains collection of child 1

}

Child1_Class
{
//contains Collection of child 2
}

The reverse of this process is done to update/insert records from Buiness
objects.

My requirement is, to know whether there's any mechanism by which i can
convert
Business objects to Flat Table (DataTable) and Viceversa.

Looking for suggestions
Shibu