当前文件路径：BugNet/BugNET_WAP/Config/Log4Net.config

		            
 1<?xml version="1.0" encoding="utf-8"?>
 2<log4net>
 3  <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
 4    <bufferSize value="100" />
 5    <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
 6    <connectionString value="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|BugNet.mdf;Integrated Security=True;User Instance=True" />
 7    <commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[User],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger,@user, @message, @exception)" />
 8    <parameter>
 9      <parameterName value="@log_date" />
10      <dbType value="DateTime" />
11      <layout type="log4net.Layout.RawTimeStampLayout" />
12    </parameter>
13    <parameter>
14      <parameterName value="@thread" />
15      <dbType value="String" />
16      <size value="255" />
17      <layout type="log4net.Layout.PatternLayout">
18        <conversionPattern value="%thread" />
19      </layout>
20    </parameter>
21    <parameter>
22      <parameterName value="@log_level" />
23      <dbType value="String" />
24      <size value="50" />
25      <layout type="log4net.Layout.PatternLayout">
26        <conversionPattern value="%level" />
27      </layout>
28    </parameter>
29    <parameter>
30      <parameterName value="@logger" />
31      <dbType value="String" />
32      <size value="255" />
33      <layout type="log4net.Layout.PatternLayout">
34        <conversionPattern value="%logger" />
35      </layout>
36    </parameter>
37    <parameter>
38      <parameterName value="@user" />
39      <dbType value="String" />
40      <size value="50" />
41      <layout type="log4net.Layout.PatternLayout">
42        <conversionPattern value="%X{user}" />
43      </layout>
44    </parameter>
45    <parameter>
46      <parameterName value="@message" />
47      <dbType value="String" />
48      <size value="4000" />
49      <layout type="log4net.Layout.PatternLayout">
50        <conversionPattern value="%message" />
51      </layout>
52    </parameter>
53    <parameter>
54      <parameterName value="@exception" />
55      <dbType value="String" />
56      <size value="2000" />
57      <layout type="log4net.Layout.ExceptionLayout" />
58    </parameter>
59  </appender>
60  <appender name="FileAppender" type="log4net.Appender.FileAppender">
61    <file value="log-file.txt" />
62    <appendToFile value="true" />
63    <layout type="log4net.Layout.PatternLayout">
64      <conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
65    </layout>
66  </appender>
67  <!--
68  <appender name="SmtpAppender" type="log4net.Appender.SmtpAppender">
69    <to value="test@test.com" />
70    <from value="test@test.com" />
71    <subject value="test logging message" />
72    <smtpHost value="localhost" />
73    <bufferSize value="0" />
74    <lossy value="true" />
75    <evaluator type="log4net.Core.LevelEvaluator">
76      <threshold value="ERROR"/>
77    </evaluator>
78    <layout type="log4net.Layout.PatternLayout">
79      <conversionPattern value="%newline%date [%thread] %-5level %logger [%property{NDC}] - %message%newline%newline%newline" />
80    </layout>
81  </appender>
82 <logger name="BugNET.DataAccessLayer.GenericDataAccessLayer" additivity="true">
83    <level value="DEBUG"/>
84    <appender-ref ref="FileAppender" />
85  </logger>
86  -->
87  <root>
88    <level value="DEBUG" />
89    <appender-ref ref="AdoNetAppender" />
90    <!-- 
91      <appender-ref ref="SmtpAppender" />
92    -->
93  </root>
94</log4net>
95