Modeling composite Business entity

[Balaji]

Hi

I have three database tables - Location, Part and Detail.
Location and Part have a one-many relationship to detail.
Location and Part need to be inserted into the database
before inserting a detail record.
I am having problems designing the business entity objects
for these tables becoase we have one composite that
Depends on Two Parent Objects.

Anybody have a suggestion on how to model this ?

Thanks,

Balaji

[solex]

Balaji

A bit more information would help, please provide a description of the
domain problem you are trying to solve.
"Balaji" <an*******@discussions.microsoft.com> wrote in message
news:04****************************@phx.gbl...

Hi

I have three database tables - Location, Part and Detail.
Location and Part have a one-many relationship to detail.
Location and Part need to be inserted into the database
before inserting a detail record.
I am having problems designing the business entity objects
for these tables becoase we have one composite that
Depends on Two Parent Objects.

Anybody have a suggestion on how to model this ?

Thanks,

Balaji

[SaiPavan]

In these Cases Create a dataset for one table and with the
help of datareaders add new columns to the dataset and get
the output by appending the columns to the dataset (or) u
can produce the output by creating a new datareader with
these conditions.

First create a Dataset with detail info.
Later write the query using out come of the Dateset Table.

-----Original Message-----
Hi

I have three database tables - Location, Part and Detail.
Location and Part have a one-many relationship to detail.
Location and Part need to be inserted into the database
before inserting a detail record.
I am having problems designing the business entity objectsfor these tables becoase we have one composite that
Depends on Two Parent Objects.

Anybody have a suggestion on how to model this ?

Thanks,

Balaji
.