How to get the sql query from a NHibernate save

Question

I am trying to create a type of recorded data transaction that I can replay on a different database.

For example I am capturing an order into a system, when I save that I want to be able to "export" a sql script that I can run on another database to create the same order.

I am using NHibernate and I am trying to catch the sql query string for the save operation to save to a file, but with no success.

Answer 1

Try running a DB profiler, you'll be 100% sure about the queries being sent to DB. In case of MS SQL Server more info is here. Also you can try Nhibernate profiler.

Answer 2

Checkout this question: http://stackoverflow.com/questions/1264132/get-executed-sql-from-nhibernate

I'm not sure if there is a better alternative like an event listener, if not, the IInterceptor approach seems to be the best.