c# - logging into DB with log4net -

i use log4net logging errors in project. want log messages db (sql server) added adonetappender not work (other appenders work fine, connection string correct). can wrong?

i decided create bare-bones example project. works. perhaps should try making work.

create empty console application project. add reference log4net. c# code:

using log4net;  [assembly: log4net.config.xmlconfigurator(watch = true)]  namespace litter {     class program     {         static void main()         {             logmanager.getlogger("default").info("hello, world!");         }     } } 

config file:

<?xml version="1.0" encoding="utf-8" ?> <configuration>   <configsections>     <section name="log4net" type="log4net.config.log4netconfigurationsectionhandler, log4net"/>   </configsections>   <startup>      <supportedruntime version="v4.0" sku=".netframework,version=v4.5" />   </startup>   <log4net>     <appender name="adonetappender" type="log4net.appender.adonetappender">       <buffersize value="1"/>       <connectiontype value="system.data.sqlclient.sqlconnection, system.data, version=1.0.3300.0, culture=neutral, publickeytoken=b77a5c561934e089"/>       <connectionstring value="data source=localhost\sqlexpress;initial catalog=litter;integrated security=true;"/>       <commandtext value="insert logs ([message]) values (@message)"/>       <parameter>         <parametername value="@message"/>         <dbtype value="string"/>         <size value="2000"/>         <layout type="log4net.layout.patternlayout">           <conversionpattern value="%message"/>         </layout>       </parameter>     </appender>     <root>       <level value="debug"/>       <appender-ref ref="adonetappender"/>     </root>   </log4net> </configuration> 

database table:

create table [dbo].[logs]([message] [nvarchar](2000) not null) go 

that's simple gets. if can make work, i'd start looking closely @ app's adonetappender configuration.