How to check query statement in Linq to NHibernate?

I'd like to see sql query once linq to nhibernate query is executed to log 开发者_开发问答or check sql query. How can I do?

You could either configure log4net or use an SQL Profiler to see what's actually sent to the database. Yet another option (if you are willing to spend a few bucks) is to checkout Ayende's excellent tool.

Use SQL Profiler.