I Hate This Code
I'm trying to run a SqlBulkCopy operation as a part of NHibernate transaction, and it is not going so well. It wants to either start its own transaction, or join an existing one. The problem is that I don't have access to the real transaction in NHibernate, it is wrapped away.
Here is how I finally solved the issue:
private SqlTransaction GetTransaction(ISession session)
using(IDbCommand command = session.Connection.CreateCommand())
return command.Transaction as SqlTransaction;
Ugly, but it seems to be working.