If you ar using MsSql you can add

Set NOCOUNT on

in your trigger

John Davidson

On Wed, Jan 12, 2011 at 11:24 AM, Giulio Petrucci <[email protected]
> wrote:

> Hi there,
>
> I have a class "Foo" mapped on a table "Foo".
> The table has some triggers set, so that when a record is deleted from
> Foo, another record is deleted from another table.
> In my code, I have:
>
> ISessionFactory sf = ...;
> var session = sf.OpenSession();
> Foo foo = ...;
> session.Delete(foo);
> session.Flush();
>
> and I get a "TooManyRowsAffectedException" as *2* rows have been
> deleted (the Foo's one and the "triggered" one) while only one was
> expected.
> What am I doing wrong? ;-)
>
> Thanks in advance,
> Giulio - Italia
>
> --
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<nhusers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to