Multiple named check constraints

[peetw]

Currently it's possible to specify multiple check constraints for an entity by just joining each constraint together with "AND","OR", etc. and passing the concatenated string to mapping.CheckConstraint().

However, this results in a single check constraint in the database. For cases where there are multiple constraints it would be very useful to be able to specify them separately so that they appear as multiple check constraints within the database. This would make it much more obvious why an insert has failed as the check constraint would be much more specific.

Would this be something that can be easily implemented?

[hazzik]

This is the area of the NHibernate.

[peetw]

@hazzik so is this a limitation of NHibernate itself rather than FluentNHibernate then? Happy to have a quick look at this if you could point me in the right general direction 😄

[hazzik]

Yes, it is limitation of NHibernate. Sorry, I misstyped "area" first time as "are" :-)

The NHibernate allows to specify only a single check for a column/class/etc.

nhibernate-core/src/NHibernate/nhibernate-mapping.xsd

Line 208 in 9255435

<xs:attribute name="check" type="xs:string" />

nhibernate-core/src/NHibernate/nhibernate-mapping.xsd

Line 242 in 9255435

<xs:attribute name="check" type="xs:string" />