1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70
| <log4net debug="true">
<appender name="RollingFile" type="log4net.Appender.RollingFileAppender">
<file value="c:/Log/Log.txt"/>
<threshold value="ALL"/>
<appendToFile value="true"/>
<rollingStyle value="Date"/>
<datePattern value="yyyyMMdd"/>
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="*%-10level %-30date %-25logger %message %newline"/>
</layout>
</appender>
<appender name="DatabaseAppender" type="log4net.Appender.AdoNetAppender">
<bufferSize value="1" />
<threshold value="ALL"/>
<connectionType value="System.Data.SQLite.SQLiteConnection, System.Data.SQLite, Version=1.0.81.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
<connectionString value="Data Source=C:/DataLog.sqlite" />
<commandText value="INSERT INTO Logs(date, page, filename, message, level) VALUES(@log_date, @page, @filename, @message, @log_level)" />
<parameter>
<parameterName value="@log_date" />
<dbType value="DateTime" />
<size value="255" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date{yyyy'-'MM'-'dd HH':'mm}" />
</layout>
</parameter> <parameter>
<parameterName value="@log_level" />
<dbType value="String" />
<size value="50" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%level" />
</layout>
</parameter>
<parameter>
<parameterName value="@message" />
<dbType value="String" />
<size value="500" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%message" />
</layout>
</parameter>
<parameter>
<parameterName value="@page"/>
<dbType value="String" />
<size value="255" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{page}" />
</layout>
</parameter>
<parameter>
<parameterName value="@filename"/>
<dbType value="String" />
<size value="255" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{filename}" />
</layout>
</parameter>
</appender>
<root>
<level value="ALL"/>
</root>
<logger name="MonitoringLogger">
<level value="ALL"/>
<appender-ref ref="RollingFile"/>
<appender-ref ref="DatabaseAppender"/>
</logger>
</log4net>
</configuration> |
Partager