How to create composite UNIQUE constraint in FluentNHibernate?

Question

I know that I can Map(x => x.GroupName).WithUniqueConstraint() for a single property.

But how do create a composite unique constraint in fluent nHibernate (where the unique constraint operates on the combination of two columns)?

Answer 1

In the latest version that I have used, it isUniqueKey("KeyName")that does this.

Map(x => x.Something).UniqueKey("KeyName"); Map(x => x.SomeOtherThing).UniqueKey("KeyName"); 

Answer 2

Use SetAttribute in your mapping file like so:

Map(x => x.Something).SetAttribute("unique-key", "someKey"); Map(x => x.SomeOtherThing).SetAttribute("unique-key", "someKey");