在使用NHibernate时出现SqlClient异常,我想看一下NHibernate给我生成的SQL语句,如何察看? 如题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 LZ的*.hbm.xml有没有设置成"嵌入的资源"? 配置一下log4net,nhibernate生成的sql语句有记录的 如果你后台是sqlserver2005的话,可以使用sql server profiler,在sqlserver的性能分析里面,进去以后新建跟踪,然后运行,这样就会对你建立跟踪的数据库所有操作看到执行语句了!sql2000也有的,只是忘了在那个目录了,很方便用的。 log4net的配置方法<?xml version="1.0" encoding="utf-8" ?><configuration> <configSections> <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" /> </configSections> <!-- This section contains the log4net configuration settings --> <log4net debug="false"> <!-- Define some output appenders --> <appender name="trace" type="log4net.Appender.TraceAppender, log4net"> <layout type="log4net.Layout.PatternLayout,log4net"> <param name="ConversionPattern" value="%d [%t] %-5p %c - %m%n" /> </layout> </appender> <appender name="console" type="log4net.Appender.ConsoleAppender, log4net"> <layout type="log4net.Layout.PatternLayout,log4net"> <param name="ConversionPattern" value="%d [%t] %-5p %c - %m%n" /> </layout> </appender> <appender name="rollingFile" type="log4net.Appender.RollingFileAppender,log4net" > <param name="File" value="log.txt" /> <param name="AppendToFile" value="false" /> <param name="RollingStyle" value="Date" /> <param name="DatePattern" value="yyyy.MM.dd" /> <param name="StaticLogFileName" value="true" /> <layout type="log4net.Layout.PatternLayout,log4net"> <param name="ConversionPattern" value="%d [%t] %-5p %c - %m%n" /> </layout> </appender> <!-- Setup the root category, add the appenders and set the default priority --> <root> <priority value="INFO" /> <appender-ref ref="rollingFile" /> </root> <logger name="NHibernate.Cache"> <level value="DEBUG" /> </logger> <logger name="NHibernate.Impl.BatcherImpl"> <level value="WARN" /> </logger> <logger name="NHibernate.SQL"> <level value="ALL" /> </logger> </log4net></configuration> VS2010有没有记录BUG功能 c#打印固定区域,请前辈指点!小弟先感谢了! 求助,局域网内远程控制,求思路。 VS2005中使用///注释 不知道为什么无法获得kuaidi100物流信息?还有其他方法吗? 大家看看这个DataGrid问题: 如何在当前位置前面插入一行? 很简单的问题 最近很少答题,信誉分却长了三十,散分. 小问题,快来抢分! 求写一个正则表达式,超出了我的水平,偿试没有写成功 进来帮帮小妹吧,C#怎么样可以调用自己的DLL,而不用系统自带的一个同名DLL word 打印问题、在线等、、、
<configuration>
<configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
</configSections> <!-- This section contains the log4net configuration settings -->
<log4net debug="false"> <!-- Define some output appenders -->
<appender name="trace" type="log4net.Appender.TraceAppender, log4net">
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d [%t] %-5p %c - %m%n" />
</layout>
</appender> <appender name="console" type="log4net.Appender.ConsoleAppender, log4net">
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d [%t] %-5p %c - %m%n" />
</layout>
</appender> <appender name="rollingFile" type="log4net.Appender.RollingFileAppender,log4net" >
<param name="File" value="log.txt" />
<param name="AppendToFile" value="false" />
<param name="RollingStyle" value="Date" />
<param name="DatePattern" value="yyyy.MM.dd" />
<param name="StaticLogFileName" value="true" /> <layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d [%t] %-5p %c - %m%n" />
</layout>
</appender> <!-- Setup the root category, add the appenders and set the default priority -->
<root>
<priority value="INFO" />
<appender-ref ref="rollingFile" />
</root> <logger name="NHibernate.Cache">
<level value="DEBUG" />
</logger> <logger name="NHibernate.Impl.BatcherImpl">
<level value="WARN" />
</logger>
<logger name="NHibernate.SQL">
<level value="ALL" />
</logger>
</log4net>
</configuration>