Hi everyone,

I am creating a system that tracks the real time location of people and devices within a medical facility. I have two relevant tables in SQL Server to maintain the location state. One table has the real time location of the entities, real time, one record per entity per location. The other subordinate table is a location history table. I have a SQL Server on delete trigger that inserts a history record when the entity location record is deleted.

Here is the problem, SQL Server includes the record row counts that the trigger changed with the delete of the primary location table. So NHibernate is expecting a delete row count of 1 and SQL Server is returning a row count of 2. Which is causing the NHibernate transaction to fail.

Anyone have any experience getting SQL Sever triggers to work and play well with NHibernate?

try adding this to your trigger's body (within the begin and end)

I had the same problem and your solution is working well...
I credit you ;-)

ehhe, then you should rate his post as being helpful ;-)