如何使用NHibernate将SQL调用记录到Visual Studio的控制台？

Install-Package NHibernate
Install-Package NHibernate.Cfg.MappingSchema
Install-Package NHibernate.Mapping.ByCode
Install-Package NHibernate.Tool.hbm2ddl

 <configSections>
   <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
  </configSections>
  <log4net>
    <appender name="ConsoleAppender" type="log4net.Appender.ConsoleAppender">
     <layout type="log4net.Layout.PatternLayout">
        <conversionPattern value="%d [%t] %-5p %c - %m%n" />
      </layout>
    </appender>
   <logger name="NHibernate">
     <level value="DEBUG" />
      <appender-ref ref="ConsoleAppender" />
    </logger>
    <root>
     <level value="DEBUG" />
      <appender-ref ref="ConsoleAppender" />
    </root>
  </log4net>
</configuration>

var configuration = new Configuration();
configuration.Configure();
configuration.SetProperty("show_sql", "true");
configuration.SetProperty("format_sql", "true");
configuration.SetProperty("use_sql_comments", "true");
var sessionFactory = configuration.BuildSessionFactory();

using (var session = sessionFactory.OpenSession())
{
    using (var transaction = session.BeginTransaction())
    {
        var query = session.Query<User>();
        var users = query.ToList();
        transaction.Commit();
    }
}