xp-dev.com Git - CPE_learningsite/blob - CPE/CPE.App/CPE.App.Api/log4net.config

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <log4net debug="true">
   3   <root>
   4     <level value="DEBUG" />
   5     <appender-ref ref="AdoNetAppender" />
   6     <appender-ref ref="FileAppender" />
   7   </root>
   8   <appender name="FileAppender" type="log4net.Appender.FileAppender">
   9     <!-- Prod -->
  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" />
  14     </layout>
  15   </appender>
  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" />
  19     <!-- Prod -->
  20         <connectionString="Data Source=cpeonlinewebcasts.com;Initial Catalog=webcpe_reporting;Persist Security Info=True;User ID=webcpe_reporting;Password=Pa$$w0rd" />
  21     <commandText value="INSERT INTO ServiceLog ([Created],[ServiceMethod],[Details]) VALUES (@log_date, @logger, @message)" />
  22     <parameter>
  23       <parameterName value="@log_date" />
  24       <dbType value="DateTime" />
  25       <layout type="log4net.Layout.RawTimeStampLayout" />
  26     </parameter>
  27     <parameter>
  28       <parameterName value="@logger" />
  29       <dbType value="String" />
  30       <size value="255" />
  31       <layout type="log4net.Layout.PatternLayout">
  32         <conversionPattern value="%logger" />
  33       </layout>
  34     </parameter>
  35     <parameter>
  36       <parameterName value="@message" />
  37       <dbType value="String" />
  38       <size value="-1" />
  39       <layout type="log4net.Layout.PatternLayout">
  40         <conversionPattern value="%message" />
  41       </layout>
  42     </parameter>
  43   </appender>
  44 </log4net>