How to get SQL query from NHibernate save

Question

I am trying to create a transaction type of recorded data that I can play in another database.

For example, I collect an order on the system when I save that I want to “export” an sql script that I can run in another database to create the same order.

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

Answer 1

Checkout this question: Get executable SQL from nHibernate

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