title: Mixing Nhibernate and ADO transactions?
body: <p>I have a rather odd requirement due to a codebase I've inherited. The DAL is based on the Repository pattern however some of the repositories are coded using the SqlConnection/SqlCommand with straight SQL and parameterised queries and some are coded using NHibernate.</p>
  
  <p>I need to perform a series of data manipulations that requires repositories from both divides and if it fails at any stage along the way it all needs to rollback. What is the best way to go about this?</p>
  
  <p>System.Data exposes an IDbTransaction and NHibernate an ITransaction, are these 2 compatible in anyway? Could I run both transactions at the same time and then roll them both back if something goes wrong? Would TransactionScope help me in this scenario? </p>