Hello!

I am using Spring.Net 1.3.1 with NHibernate 3.0 and have a strange problem regarding exception translation if a unique key violation (on SQL Server/SQL Express) occurs.
If an entity (f.e. Product) is updated via CurrentSession.SaveOrUpdate in the DAOs MakePersistent and a unique key violation (f.e. Product.Name) occurs the SqlException with code 2627 is correctly translated to an DataIntegrityViolationException.
But if the same MakePersistent is called for a new entity and an SqlException with code 2627 is thrown (Product with same name already exists) then the exception is translated to an UncategorizedAdoException! I would expect/need an DataIntegrityViolationException (even better a DuplicateKeyException) here too.

I would appreciate any ideas/solutions on this problem.

Regards