app.config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <configSections>

    <!-- <section name="nhibernate" type="System.Configuration.NameValueSectionHandler " /> -->
    <section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" />
    <!-- <section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate"/> -->
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net"/>
  </configSections>
  <!-- Sql server connection -->

  <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
    <session-factory>
      <property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
      <property name="dialect">NHibernate.Dialect.MySQLDialect</property>
      <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
      <property name="connection.connection_string">Server=localhost;Database=test;User Id=root;Password=massimo870;</property>
      <property name="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle</property>
      <property name="show_sql">true</property>
      <property name="use_proxy_validator">true</property>
      <property name="adonet.batch_size">16</property>
      <property name="generate_statistics">true</property>
      <mapping resource="NHibernateConsole.Mappings.Person.hbm.xml" assembly="NHibernateConsole" />
    </session-factory>
  </hibernate-configuration>

  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <qualifyAssembly partialName="MySql.Data"
                       fullName="MySql.Data, Version=5.1.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d">
      </qualifyAssembly>
    </assemblyBinding>
  </runtime>


  <log4net>
    <appender name="OutputSQL" type="log4net.Appender.FileAppender">
      <param name="File" value="OutputSql.txt" />
      <param name="AppendToFile" value="false" />
      <layout type="log4net.Layout.PatternLayout">
        <param name="ConversionPattern" value="%m;" />
      </layout>
    </appender>
    <logger name="NHibernate.SQL" additivity="false">
      <level value="DEBUG" />
      <appender-ref ref="OutputSQL" />
    </logger>
  </log4net>
</configuration>

Person.hbm.xml

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
                   assembly="NHibernateConsole"
                   namespace="NHibernateConsole.Entity">

  <class name="Person" table="Person" lazy="false">
    <id name="Id" type="System.Int32">
      <generator class="native" />
    </id>

    <property name="Name" column="Name" type="System.String"/>
    <property name="Surname" column="Surname" type="System.String"/>
    <property name="Age" column="Age" type="System.Int32" />
  </class>
</hibernate-mapping>