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.Name, ChildTable1.Id, ChildTable1.Name,
ChildTable2.Id, ChildTable2.Name
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