Hi,
I need to update some BLOB field by manual SQL statement in the same transaction which updates my entity objects. Those BLOBs must be updated only partialy by UPDATETEXT (MS SQL), so I can't use any entity with byte array property.
When I open a hibernate session and then begin new transaction to update some entities, everything works fine. However, then I need an IDbCommand with the same transaction, so I get the command:
IDbCommand cmd = session.Connection.CreateCommand();

But I can't find any way how to get the IDbTransaction started by NHibernate session :(
This transaction must be associated with command:
cmd.Transaction = [IDbTransaction object]

Any hints?

Check out the NHibernate-SDK file and look at ITransaction.Enlist(..)