I have an existing DB schema with the following tables,
Items(item_id, item_price, item_description, category, creation_date, last_update_date)
Item_Components(parent_id, component_id, effective_date, creation_date, last_update_date)
I can only figure out a wat to create a mapping and use this Item class:
And the ItemComponent class:
But I would like to end up with a class similar to this one:
Notice that instead of a list of ItemComponents I would like a list of items.
I can't figure out a way to create a mapping where I can use this last class with my current schema.
(Note: The columns component_id and parent_id are foreign key references of the column item_id if the Items table)
Can someone help?
Thanks.
Items(item_id, item_price, item_description, category, creation_date, last_update_date)
Item_Components(parent_id, component_id, effective_date, creation_date, last_update_date)
I can only figure out a wat to create a mapping and use this Item class:
And the ItemComponent class:
But I would like to end up with a class similar to this one:
Notice that instead of a list of ItemComponents I would like a list of items.
I can't figure out a way to create a mapping where I can use this last class with my current schema.
(Note: The columns component_id and parent_id are foreign key references of the column item_id if the Items table)
Can someone help?
Thanks.