Hello,

I'm building a web application in Visual Studio 2008 using NHibernate. This is the NHibernate section in my Web.config:

<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="dialect">NHibernate.Dialect.MsSql2000Dialect</property>
<property name="connection.connection_string">*****************************</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="show_sql">true</property>
</session-factory>
</hibernate-configuration>

Where exactly is the SQL shown? I'm running the solution within VS. It doesn't appear in the VS output window, and I've searched in every place that seems reasonable for log files. I have log4net.dll referenced in most of the projects in the solution.

I also can't find any SQL output when I run unit tests. In this case the configuration is built programmatically using NHibernate.Cfg.Configuration, but the properties are identical.

Can anybody help?

Chris

Afaik, you have to set log level to DEBUG in your log4net configuration.