Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

multiple unique-key

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

simpledo

Post subject: multiple unique-key

Posted: Thu Jan 03, 2008 7:34 am

Newbie

Joined: Fri Dec 21, 2007 1:17 pm
Posts: 11

NHibernate version: 1.2.1 GA

Name and version of the database you are using: SQLServer 2005

Hi,
I'm experiencing a problem trying to create two unique constraints over multiple properties, where one of these is inside both constraints.

I tried this mapping but it generates one more constraint over the shared property as an alone unique constraint.

Code:

      <many-to-one name="Commissionario" class="EntitaLegale, SetecoEntities" column="Commissionario_Id" foreign-key="fk_Commessa_commissionario" unique-key="provaunica,provadue"/>
      <property name="ProgressivoCommessa" type="Int32" unique-key="provaunica"/>
      <property name="ProgressivoOfferta" type="Int32" unique-key="provadue"/>

I don't know what can I do... Please, can You help me ?
Thanks.

Top

simpledo

Post subject: UP

Posted: Fri Jan 04, 2008 5:42 am