How to know query generated by Fluent NHibernate

Question

Hi,

I am using linq to Nhibernate to fire some select query to data base.

My question is, how do I know, the query generated by Fluent NHibernate?

Answer 1

See this. What you need is hibernate.show_sql.

Answer 2

With Fluent NHibernate, you can turn on show_sql like this:

Fluently.Configure().Database( MsSqlConfiguration.MsSql2005.ShowSql().ConnectionString(...) )...

NHibernate will now print every sql statement to Console.Out.

Answer 3

You might also find this useful http://nhprof.com/

Answer 4

You can use sql profilers like this one too.

Answer 5

You can also hook in log4net.

Answer 6

If you want the SQL to be in log4net, make sure you set the logger in your configuration section.

I put the NHibernate package at "INFO" to reduce the noise and the NHibernate.SQL to all so I can log all SQL statements.

  
 <logger name="NHibernate">
   <level value="INFO" />
 </logger>


  <logger name="NHibernate.SQL">
    <level value="ALL" />
  </logger>

Answer 7

Definitely buy and use NHProf. This is an awesome product and not only shows you what queries are being run, but also shows you any potential performance problems with your NHibernate mappings and queries.