How to see the SQL queries generated by NHibernate

I'm using SQL server express edition with ASP.NET MVC, there is not a profiler in express editions so I can't see the queries generated by NHibernate. I'm concerned about the performance and how I can see the queries without a profiler?

Have you taken a look at nhprof? It's a profiler for NHibernate written by Ayende and should (I think) work with express. There's a trial version you can test with.

You could enable logging.

I haven't tried myselft, but theoretically you could use IntelliTrace