Hi,

I've been asked to integrated NHibernate with a Linq-SQL development and have hit an issue with updating data through NHibernate and Linq-SQL within the same transaction.

I'm struggling to integrate the two technologies so that a crash in one rolls back the SQL changes in the other.

I was considering creating a TransactionScope within the HNibernate Begin/Commit code but I think I still need to do a TransactionScope Commit... which may work but the HNibernate Commit may still fail... I need to tie the Linq-SQL commit into the HNibernate Commit.

Any ideas?

I've looked at the Java transaction docs but they don't really help me that much.