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

Question

So I'm trying to update an object in my MS SQL 2005 database using NHibernate. Please keep in mind that this is a legacy database used in many live systems and I can't remove the triggers.

When my data provider tries to .SaveOrUpdate() a row I get two returns (one for the actual update, and one when the trigger executes)

The raw return looks like this:

(1 row(s) affected)

NHibernate then throws an exception like this: "Unexpected row count: 2; expected: 1"

I'm essentially looking an equivalent to "SET NOCOUNT ON" from within the session.

Any ideas?

score 35 · Accepted Answer · answered May 05 '09 at 00:37

35

And you can't update the trigger to disable/enable the SET NOCOUNT before/after the trigger's code ?

SET NOCOUNT ON -- your trigger SET NOCOUNT OFF

answered May 05 '09 at 00:37

MatthieuGD

4,552
2
30
29

It's so rare to just get the answer quickly and easily. Thanks Matthieu. – David Jun 22 '10 at 08:37
You rock my world! Thank you so much - Exactly what i was looking for :) – JuniorCoder Sep 25 '15 at 08:10
Best answer ever! Thanks Matt you're a Rockstar! – Chris Lamothe Sep 30 '15 at 13:46
You are a genius, spent an hour wondering why it wasnt working – krilovich Mar 19 '19 at 18:50

score 2 · Answer 2 · edited Jan 15 '14 at 23:44

2

NHibernate JIRA NH-1353 provides a patch to deactive row count checking in the config file. It appears that this patch hasn't made it into the 2.x trunk.

edited Jan 15 '14 at 23:44

madth3

7,275
12
50
74

answered May 05 '09 at 00:59

Jamie Ide

48,427
16
81
117

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

2 Answers2

Linked