views:

13

answers:

0

Can someone please give me an example of what the mappings would look like for two classes that both have composite keys and a one-to-many relationship? I have looked everywhere and tried 100 different things with no luck.

E.g.,

HeaderTable
-HCONO Decimal
-HDVNO Decimal
-HDTTK Decimal
-HDES2 String
-HDESC String
-HDESC3 String

HCONO, HDVNO, HDTTK, HDES2 make up the primary key

ProddataTable
-PCONO Decimal
-PDVNO Decimal
-PDTTK Decimal
-PWKAR String
-PTKNO Decimal
-PDESC String
-PDESC2 String
-PDESC3 String

PCONO, PDVNO, PDTTK, PWKAR, PTKNO make up the key

The tables would join on: HCONO/PCONO, HDVNO/PDVNO, HDTTK/PDTTK, HDES2/PWKAR. There is one header and many production data records.

Thank You.