I am getting
"Transaction not connected, or was disconnected error"
using(var tran = Session.Session().BeginTransaction(IsolationLevel.Serializable))
// do something
fullSession.Session().CreateSQLQuery(query).ExecuteUpdate();// this query bulk insert in a temp db
// do something else
tran.Commit()/ tran.RollBack();// if transaction is active and not already rolled back/committed
Bulk Insert is a combination of Insert statements so if it fails it doesn't roll back the transaction so if you really want to catch the error try using Try and catch block inside BEGIN and END transaction