替代品的SqlTransaction公开活动 - C＃？ [英] Alternate to SqlTransaction exposing Events - C#?

问题描述

我想执行一些日志记录时的SqlTransaction提交或rolledback。我看到的SqlTransaction类没有公开任何这样的事件，如OnCommit或OnRollback。

I want to perform some logging when a SqlTransaction is committed or rolledback. I see that SqlTransaction class does not expose any such events like OnCommit or OnRollback.

该死的！的SqlTransaction类是密封的，我不能帮助它与继承。

damn! SqlTransaction class is sealed, I cant help it out with inheritance.

现在，什么才是真正的原因，他们没有让这些事件发生？

Now, what must be the reason they have not allowed these events to happen ?

有没有办法做到这些事件的SqlTransaction或的SqlTransaction任何这样的替代提供？

Is there a way to do these events with SqlTransaction or any such alternate of SqlTransaction that provides ?

感谢。

推荐答案

一种可能性是创建一个实现IDbTransaction一类，包装内部的SqlTransaction。这样，你会不得不说是这样的：

One possibility is to create a class that implements IDbTransaction, and wraps an internal SqlTransaction. You would then have to say something like:

IDbCommand icommand = (IDbCommand)command; // Where command is a SqlCommand.
command.Transaction = itransaction; // Class implementing IDbTransaction and wrapping SqlTransaction.

我的没有的尝试这样做，上面必须考虑伪code。我很怀疑它甚至会工作，但它可能是值得一试。

I have not tried this and the above must be considered pseudocode. I'm skeptical it will even work, but it's probably worth a try.

这篇关于替代品的SqlTransaction公开活动 - C＃？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！