Modeling composite Business entity

  • Thread starter Thread starter Balaji
  • Start date Start date
B

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
 
Balaji

A bit more information would help, please provide a description of the
domain problem you are trying to solve.
 
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.
 
Back
Top