关于Nhibernate使用的问题。

最新推荐文章于 2022-10-06 17:07:01 发布

sunearlier

最新推荐文章于 2022-10-06 17:07:01 发布

阅读量1.3k

点赞数

分类专栏： .NET圈子文章标签： object session insert delete sql 数据库

本文链接：https://blog.csdn.net/sunearlier/article/details/1025844

版权

.NET圈子专栏收录该内容

40 篇文章 0 订阅

订阅专栏

数据库里面增加触发器的时候，会出现错误。不知道如何解决这样的问题。

ERROR Eoffice.Factory.TblFactory [(null)] - NHibernate.HibernateException: SQL insert, update or delete failed (expected affected row count: 1, actual affected row count: 3). Possible causes: the row was modified or deleted by another user, or a trigger is reporting misleading row count.
   at NHibernate.Impl.NonBatchingBatcher.AddToBatch(Int32 expectedRowCount)
   at NHibernate.Persister.EntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, SqlString sql, Object obj, ISessionImplementor session)
   at NHibernate.Persister.EntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session)
   at NHibernate.Impl.ScheduledInsertion.Execute()
   at NHibernate.Impl.SessionImpl.Execute(IExecutable executable)
   at NHibernate.Impl.SessionImpl.ExecuteAll(IList list)
   at NHibernate.Impl.SessionImpl.Execute()
   at NHibernate.Impl.SessionImpl.Flush()
   at NHibernate.Transaction.AdoTransaction.Commit()

找到了大致的原因。就是有直接关联关系的表使用NHibernate操作时候，不能使用触发器操作关联表，因为那样可能会导致Nhibernate无法实现其数据同步，导致如上错误。