1 <?xml version="1.0" encoding="utf-8"?>
4 <level value="DEBUG" />
5 <!--<appender-ref ref="AdoNetAppender" />-->
6 <appender-ref ref="FileAppender" />
8 <appender name="FileAppender" type="log4net.Appender.FileAppender">
10 <file value="D:\Log_files\CpeApi_log4net.log" />
11 <appendToFile value="true" />
12 <layout type="log4net.Layout.PatternLayout">
13 <conversionPattern value="%date [%thread] %-5level %logger [%ndc] - %message%newline" />
16 <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
17 <bufferSize value="1" />
18 <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
20 <connectionString value="Data Source=DESKTOP-Q4S6BS5;Initial Catalog=webcpe_reporting;Persist Security Info=True;User ID=sa;Password=1" />
21 <commandText value="INSERT INTO ServiceLog ([Created],[ServiceMethod],[Details]) VALUES (@log_date, @logger, @message)" />
23 <parameterName value="@log_date" />
24 <dbType value="DateTime" />
25 <layout type="log4net.Layout.RawTimeStampLayout" />
28 <parameterName value="@logger" />
29 <dbType value="String" />
31 <layout type="log4net.Layout.PatternLayout">
32 <conversionPattern value="%logger" />
36 <parameterName value="@message" />
37 <dbType value="String" />
39 <layout type="log4net.Layout.PatternLayout">
40 <conversionPattern value="%message" />