Hi Forum,

I am using table per hierarchy mapping strategy. I have a situation where a single table stores various types of objects mapped to generic columns. The table has to have a composite key.

My base class would have:

A
B
C
attirbutes mapped to columns a,b,c in the database table.

Each derived class has extra attributes D,E,F mapped to the table columns
d,e,f.

Now my composite key comprises of a,b,c,d.

How should i map these objects to this single table?

Any other strategy that you could suggest?

I use B or column b as a descriminator?

Thanking in anticipation...

I'm not sure I understand what is hard about this. How about you show your attempt at a mapping, and let others suggest tweaks.