Hello,

I'm trying to mix nHibernate & Ado.Net transaction, is it possible? Here is the psudo code:

trx = mySession.BeginTransaction();
//do some hibernate stuff with mySession
IDBCommand cmd = mySession.Connection.CreateCommand();
cmd.CommandText = rawSql;
cmd.ExecuteNonQuery();
//some other stuff
trx.Commit();

I'm getting an exception from ADO when I do ExecuteNonQuery telling me that the command requires a transaction.

How can I assign the existing transaction (trx) to the Command (cmd).

I guess I could do cmd.Transaction = mySession.Connection.BeginTransaction();

But that's a new transaction.

Is there a way I can get around this?

Thanks

try this:

trx.Enlist(cmd);

Thank you! That worked!

We do this quite a bit since we have a lot of legacy SQL access (and some long-time developers with political authority unfortunately resist using NHibernate and keep creating new code that does straight SQL). It seems to work OK for us ...

Another option is to use the ISQL interface as an alternative to straight ADO.NET