Log4Net Appender MS AccessLocal Database

If you want to use an Access Database in your App_Data directory for Log4Net, you can use the following...

<!-- *** log4net *** -->
<log4net debug="false">
<appender name="AccessDatabase" type="log4net.Appender.AdoNetAppender">
<connectionString value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DataDirectoryAccess.mdb;"/>
<commandText value="INSERT INTO Log ([Thread],[Level],[Logger],[Message], [Exception]) VALUES (@thread, @log_level, @logger, @message, @exception)"/>
<bufferSize value="1"/>
<parameter>
<parameterName value="@thread"/>
<dbType value="String"/>
<size value="255"/>
<layout type="log4net.Layout.PatternLayout" value="%thread"/>
</parameter>
<parameter>
<parameterName value="@log_level"/>
<dbType value="String"/>
<size value="50"/>
<layout type="log4net.Layout.PatternLayout" value="%level"/>
</parameter>
<parameter>
<parameterName value="@logger"/>
<dbType value="String"/>
<size value="255"/>
<layout type="log4net.Layout.PatternLayout" value="%logger"/>
</parameter>
<parameter>
<parameterName value="@message"/>
<dbType value="String"/>
<size value="4000"/>
<layout type="log4net.Layout.PatternLayout" value="%message"/>
</parameter>
<parameter>
<parameterName value="@exception"/>
<dbType value="String"/>
<size value="4000"/>
<layout type="log4net.Layout.PatternLayout" value="%exception"/>
</parameter>
</appender>
<root>
<level value="All"/>
<appender-ref ref="AccessDatabase"/>
</root>
</log4net>