Code:
<add key="hibernate.show_sql" value="true" />
edit: sorry
In your config, if you're using the namevalue handler, then add this to the <nhibernate section:
Code:
<add key="hibernate.show_sql" value="true" />
if you're using the nhibernate config handler, then add this to the <hibernate-configuration><session-factory> section:
Code:
<property name="hibernate.show_sql">true</property>
Hopefully you have log4net configured, if not then add something like this:
Code:
<configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
</configSections>
<log4net>
<appender
name="rollingFile"
type="log4net.Appender.RollingFileAppender">
<file value="c:/log/mobyProject.log" />
<appendToFile value="true" />
<rollingStyle value="Date" />
<datePattern value="yyyyMMdd" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern
value="--%n%date %-5p(%F:%L)%n Class: %c %n %m %n" />
</layout>
</appender>
<root>
<priority value="ERROR" />
<appender-ref ref="rollingFile" />
</root>
</log4net>