Hi,

We have got a strange scenario to map in NHibernate. The database that we are using is Oracle 10g. One of the Parent Table has a Primary Key that is made up of two columns- 1) ID and 2) A Number Defining the Year and Month (not Date). Also this Primary Key acts as a Foreign Key (as well as Primary Key) to all other child tables (fifteen in number). The design is such that there is a Parent Table having all the Transactions (generic information) and then there are Child Tables that actually refer to particular type of transactions (having transaction specific information).

The problem we have is that we checked that the table has a Sequence attached to it. But the Sequence is designed only for the ID column. Sequence is used only for one column but the table takes two columns as its Primary Key. So how do I write the mapping file for the id tag? Any suggestions would be welcomed.

Just would like to add that redesigning the database is unfortunately not a option that we have. We have to adhere to this design.