ExecuteNonQuery返回-1以成功插入/更新 [英] ExecuteNonQuery returns -1 for successful insert/update
问题描述
我正在使用Microsoft.Practices.EnterpriseLibrary。在我的项目的数据层中很常见。当我使用库的Database类中提供的ExecuteNonQuery方法来保存/更新给定事务中的记录,即db.ExecuteNonQuery(commandObject,dbTransaction)。
即使记录得到保存/更新,此函数也返回-1。有人可以解释我哪里出错吗?
这很可能是因为在SQL中使用了SET NOCOUNT ON。
我前段时间写了一篇关于这个的文章,但总之,注释掉或者根本不使用SET NOCOUNT。
SqlCommand.ExecuteNonQuery()返回-1在进行插入/更新/删除时 http://blogs.msdn.com/spike/archive/2009/01/27/sqlcommand-executenonquery-returns-1-when-doing-insert-update-delete.aspx
HTH
//迈克尔
Hi,
I am reffering Microsoft.Practices.EnterpriseLibrary.Common in the data layer of my project. When i am using ExecuteNonQuery method provided in Database class of the library for saving/updating record within a given transaction i.e. db.ExecuteNonQuery(commandObject,dbTransaction).
This function is returning -1 even the record get's saved/updated. Can someone please explain where I am going wrong?
Most likely this is the result of SET NOCOUNT ON being used in the SQL.
I wrote a post about this some time ago, but in short, comment out or do not use SET NOCOUNT ON at all.
SqlCommand.ExecuteNonQuery() returns -1 when doing Insert / Update / Delete
http://blogs.msdn.com/spike/archive/2009/01/27/sqlcommand-executenonquery-returns-1-when-doing-insert-update-delete.aspx
HTH
//Michael
这篇关于ExecuteNonQuery返回-1以成功插入/更新的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!