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
Post a Comment