NHibernate启用log4net

using System;
using System.IO;
using log4net;
using log4net.Config;
using NHibernate;
using NHibernate.Cfg;

namespace NHibernateExample
{
    class Program
    {
        private static readonly ILog log = LogManager.GetLogger(typeof(Program));

        static void Main(string[] args)
        {
            // 配置 log4net
            XmlConfigurator.Configure(new FileInfo("log4net.config"));

            // 配置 NHibernate
            var configuration = new Configuration();
            configuration.Configure();
            configuration.SetProperty("show_sql", "true");
            configuration.SetProperty("format_sql", "true");
            configuration.SetProperty("use_outer_join", "true");

            // 启用 log4net
            var loggerFactory = new log4net.Core.LoggerFactory();
            var logger = loggerFactory.CreateLogger("NHibernate.SQL");
            configuration.SetProperty("log4net.LoggerFactory", logger.GetType().AssemblyQualifiedName);

            // 创建 NHibernate 会话工厂
            var sessionFactory = configuration.BuildSessionFactory();

            // 使用 NHibernate 查询数据
            using (var session = sessionFactory.OpenSession())
            {
                var query = session.CreateQuery("from Employee");
                var employees = query.List<Employee>();

                foreach (var employee in employees)
                {
                    Console.WriteLine($"Employee: {employee.Name}");
                }
            }
        }
    }
}