如何解决SqlTransaction.ZombieCheck异常？ [英] How to Solve SqlTransaction.ZombieCheck Exception?

问题描述

大家好，



在我的.NET应用程序（Windows应用程序）中，我得到异常SqlTransaction.ZombieCheck。我是应用程序的新手，我得到了这个例外。从技术上讲，一般情况下会抛出异常吗？如何解决错误？如果您遇到此异常，请与我分享您的观点。在此先感谢。

Hi All,

In my .NET application(Windows Application) I get exception SqlTransaction.ZombieCheck. I'm new to the application where I get this exception. Technically in general in which scenario the exception would be thrown? How to resolve the error? If you come across this exception please do share your points with me. Thanks in advance.

推荐答案

您好b $ b

当您尝试在已经提交的交易中操作或回滚。当事务正在使用的固有连接关闭然后您尝试提交或回滚事务时，可以观察到这种情况。



您可能想在这里查看此博客 http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/08/24/zombie-check-on-transaction-error-this-sqltransaction-has-completed-it- is-no-longer-useful.aspx [ ^ ]



问候

Pawan

Hi
It happens when you try to operate in a transaction which has already been committed or rolled back. The scenario could be observed when the inherent connection that the transaction is using is closed and then you try to commit or rollback the transaction.

You may wanna check this blog here http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/08/24/zombie-check-on-transaction-error-this-sqltransaction-has-completed-it-is-no-longer-usable.aspx[^]

Regards
Pawan

这篇关于如何解决SqlTransaction.ZombieCheck异常？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！