Search code examples
nhibernate

NHibernate multiple primary keys mapping

I have a table called "Orderrow". Orderrow has a a compound primary key (CPK) with the following columns: OrderId, ProductId, RowNumber

OrderId and ProductId are also foreign keys refering to the tables Order and Product. The RowNumber is generated in the app.

I was wondering how this is mapped in NHibernate because I can only set 1 id element and 1 generator subelement.

Solution

  • There is a 'composite-id' property you can use in your class mapping instead of the 'id' property. However, you should know that the nHibernate team strongly discourages the use of it. It sounds like you are dealing with a legacy database, in which you have no control over the schema. So, the 'composite-id' is specifically for your situation.

    Check out the NH docs for more info: http://nhibernate.info/doc/nh/en/index.html