日志位置
由于NProfile不可以使用了,无法直观的看到sql 很是蛋疼,
现需要配置NHibernate及Log4Net完成记录sql的工作
如下,Error文件夹及NHibernate文件夹是公司架构师配置的原有文件,本次升级的是增加了NHibernateSQL文件夹
Logs\Error
Logs\NHibernate
Logs\NHibernateSQL
具体配置
如下图所示log4Net的配置,测试环境vs2017 log4net版本 log4net for .netFramework4.0
<log4net>
<appender name="ErrorLogAppender" type="log4net.Appender.RollingFileAppender">
<param name="File" value="Logs/Error/" />
<param name="DatePattern" value="yyyyMMdd".txt"" />
<param name="AppendToFile" value="true" />
<param name="RollingStyle" value="Date" />
<param name="StaticLogFileName" value="false" />
<layout type="log4net.Layout.PatternLayout">
<param name="ConversionPattern" value="%d [%t] %-5p %c [%x] - %m%n" />
</layout>
</appender>
<appender name="HibernateLog" type="log4net.Appender.RollingFileAppender">
<file value="logs/NHibernate/log.txt" />
<appendToFile value="true" />
<rollingStyle value="Date" />
<datePattern value="yyyyMMdd" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
</layout>
</appender>
<appender name="RollingLogFileAppender" type="log4Net.Appender.RollingFileAppender">
<file value="logs/NHibernateSQL/log.txt" /><appendToFile value="true" />
<rollingStyle value="Date" />
<datePattern value="yyyyMMdd" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
</layout>
</appender>
<logger name="ErrorLog">
<level value="ALL" />
<appender-ref ref="ErrorLogAppender" />
</logger>
<logger name="NHibernate">
<level value="ALL" />
<appender-ref ref="HibernateLog" />
</logger>
<!--配置显示sql 与下面的log4Net配合使用-->
<logger name="NHibernate.SQL">
<level value="ALL"></level>
<appender-ref ref="RollingLogFileAppender"></appender-ref>
</logger>
</log4net>
无关配置
<property name="show_sql">true</property>
Global.asax.cs
//log4net初始化
log4net.Config.XmlConfigurator.Configure();
sql样例解读
SELECT org0_.Id as Id6_0_,
org0_.Name as Name6_0_,
org0_.ParentId as ParentId6_0_,
org0_.Branch as Branch6_0_,
org0_.LinkMan as LinkMan6_0_,
org0_.LinkTel as LinkTel6_0_,
org0_.CreateTime as CreateTime6_0_,
org0_.CreateUserId as CreateUs8_6_0_,
org0_.OrgUnitTypeId as OrgUnitT9_6_0_,
org0_.IsDefault as IsDefault6_0_,
org0_.UnitCode as UnitCode6_0_,
org0_.ParentCode as ParentCode6_0_,
org0_.CrmId as CrmId6_0_,
org0_.Address as Address6_0_
FROM test_org org0_
where :p0 = 1 --==> WHERE 1 = 1
and org0_.Id = :p1; --==> and org0_.Id = 3;
:p0 = True [ Type :Boolean(0) ], -- 表示:p0==1 ,True是Boolean 类型
:p1 = 3 [ Type :Int32(0) ] -- 表示:p1==3 ,将sql中的:p1用3替换