Hi,

i am getting error when getting rows from view.

error is:- NHibernate.AdoNet.TooManyRowsAffectedException: Unexpected row count: 2; expected: 1

this view has got 3 triggers. these trigger have specified set nocount on as very first statement.Even though set nocount specified i am getting this error. I am fed up with this error. Could yiu please tell ehy i am getting this error, whats the solution for this. I have been struggling with error since 2 days.

Thanks in advance.

Is it possible that the view returns more than one row for an id ?

No, one id returns one row only.

Hm, try the SQL Profiler and check what statement hibernate sends to the server and what is returned.

i am trying to get all rows from view to display in gridview.. i am getting this error :- NHibernate.AdoNet.TooManyRowsAffectedException: Unexpected row count: 2; expected: 1.

View would not return more than one row for an id.

i do not know how to check sql profiler. what is SQL profiler. In what cases we do get above error?

Thanks in advance.

Sorry, I can't give you answers to your problem, I can just give you help to find the reason. I know that this can happen with triggers and insert/update, but never heard of problems during select.

SQL Profiler is a tool that comes with SQL server (not the express edition). You can monitor the statements that are send to the server. If you don't have the profiler installed, you can start with setting NHibernate logging to DEBUG and add hibernate.show_sql="true" to the configuration. Maybe you find something helpful in the log.

Hi,

Thank you for your help. I have SQL profiler, i checked in that. My view contains 2 rows fro one id. Thats why its giving me error. I removed one row and its working fine.

Thanks & Regards
Sandy