I have one scenario where i m using both Nhibernate and ADO.NET Code but it needs to be executed in single transaction.
Here is the scenario
1> I have three tables Table A, Table B, Table C . Insertion of data related to A, B is done using NHibernate.
2> Insertion of data is done using ADO.NET code, tradional using connection , command object.
3> Now if i m using Session.Save() on my NHibernate object(A,B) , it works fine and now i m saving to C , some erros come and i want to rollback all the changes including in A & B.
Can anyone give some pointers to this !!!!!!
|