How do I view the SQL that is generated by nHibernate?

by

You can put something like this in your app.config/web.config file :

in the configSections node :

<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net"/>

in the configuration node :

<log4net>
  <appender name="NHibernateFileLog" type="log4net.Appender.FileAppender">
    <file value="logs/nhibernate.txt" />
    <appendToFile value="false" />
    <layout type="log4net.Layout.PatternLayout">
      <conversionPattern value="%d{HH:mm:ss.fff} [%t] %-5p %c - %m%n"  />
    </layout>
  </appender>
  <logger name="NHibernate.SQL" additivity="false">
    <level value="DEBUG"/>
    <appender-ref ref="NHibernateFileLog"/>
  </logger>
</log4net>

And don’t forget to call 

log4net.Config.XmlConfigurator.Configure();

at the startup of your application, or to put 

[assembly: log4net.Config.XmlConfigurator(Watch=true)]

in the assemblyinfo.cs

In the configuration settings, set the “show_sql” property to true.

More Related Contents:

  1. How to Eager Load Associations without duplication in NHibernate?
  2. Nhibernate: How to represent Many-To-Many relationships with One-to-Many relationships?
  3. What are the First and Second Level caches in (N)Hibernate?
  4. Inverse Attribute in NHibernate
  5. Fighting cartesian product (x-join) when using NHibernate 3.0.0
  6. What’s the difference between session.Merge and session.SaveOrUpdate?
  7. How do you map an enum as an int value with fluent NHibernate?
  8. JSON.NET and nHibernate Lazy Loading of Collections
  9. List vs Set vs Bag in NHibernate
  10. When to use inverse=false on NHibernate / Hibernate OneToMany relationships?
  11. nHibernate mapping to custom types
  12. IndexOutOfRangeException Deep in the bowels of NHibernate
  13. Is this the right way to eager load child collections in NHibernate
  14. Unable to cast object of type NHibernate.Collection.Generic.PersistentGenericBag to List
  15. How to create OR statements for NHibernate?
  16. Binary Blob truncated to 8000 bytes – SQL Server 2008 / varbinary(max)
  17. How to save a child with assigned id in nhibernate
  18. NHibernate configuration for uni-directional one-to-many relation
  19. Generate XML mappings from fluent Nhibernate
  20. What is the difference between JoinQueryOver and JoinAlias?
  21. Get Distinct result set from NHibernate using Criteria API?
  22. DateTime precision in NHibernate and support for DateTime2 in NHibernate SchemeExport
  23. Why doesn’t Entity Framework support ODBC?
  24. NHibernate: difference between Interceptor and Listener
  25. What exactly is “persistence ignorance”?
  26. How do add NOLOCK with nHibernate?
  27. Syntax to define a NHibernate Filter with Fluent Nhibernate?
  28. How to implement batch fetching with Fluent NHibernate when working with Oracle?
  29. NHibernate – Many to Many Query using Junction/Joiner Table
  30. What should be the lifetime of an NHibernate session?

Leave a Comment