hibernate - NHibernate - Updating a table with a trigger on it causes an error - Unexpected row count: 2; expected: 1 -


So I am trying to update an object in my MS SQL 2005 database using NHibernate. Keep that it is a legacy database used in many live systems and I can not remove the trigger.

When my data provider tries. One line gets me a reverse (one for

(1 line is affected)

(1 line NHibernate throws an exception like this: "Unexpected row count: 2 ; Required: 1 "

I'm essentially looking at" SET NOCOUNT ON "from within the session.

Any ideas?

And you can not do this, update trigger to disable / enable SET NOCOUNT before or after the trigger's code?

SET NOCOUNT ON - you Received trigger SET knock off


Comments

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -