Log4Net : log vers SQLite

Bonjour,

Comme mon titre l'indique j'aimerais envoyer mes logs vers une base de données SQLite.
Cependant, je n'arrive pas a logger du tout.

Voici ma configuration :

Code:

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>

En précisant que le log vers l'appender "RollingFile" fonctionne.

Si vous avez une idée :).