sqlnhibernateloggingoutput

How to know query generated by Fluent NHibernate

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?

Solution

  • 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>