Hi!

New to hibernate, so forgive me if this question is stupid.

I have one class whose data is compromised out of 2 tables, depending on what kind of object it is. (there are more columns in them, but I have execluded them for simplicity)

Table:Merchandise
ID
OrderID
Type
Quantity

Table:TShirtMerchandise
MerchandiseID
Size
Sleeves
Color

Table:BadgeMerchandise
MerchandiseID
Size
BackgroundColor
BackgroundImage
Back

Now, for instance, the
Badge class is compromised of data from BadgeMerchandise and Merchandise table. How do I go about mapping this with NHibernate? Can anyone point me in the right direction?

Oh, and sorry for posting as Guest there. :P

Hi mattiasjte,
I would suggest sublcassing the merchandise classes into BadgeMerchandise and ShirtMerchandise. To do that, u need to have only onle table called merchandise. But, have a field that will help in distinguishing the type of merchandise. This column should then be set as discriminator in the hbm file. In case you need more details on the hbm, let me know. I shall post it here.

HTH,
~Venki

Hey. If you want to keep the three tables, you will want a joined-subclass (table-per-subclass) mapping.

Just set the subclass key to the MerchandiseID column.

Thank you very much!