The log4net configuration file is as follows:
<!--Insert Database--><appender name= "Adonetappender_mysql" type= "log4net. Appender.adonetappender "><buffersize value=" 1 "/><connectiontype value=" MySql.Data.MySqlClient.MySqlConnection, Mysql.data "/><!--<connectiontype value=" MySql.Data.MySqlClient.MySqlConnection, Mysql.data, version=6.8.3.0, Culture=neutral, publickeytoken= c5687fc88969c44d "/>--><connectionstring value=" server= server address; user id= username; pwd= password; port= port number; pooling=true; database= database "Providername=" MySql.Data.MySqlClient; "/><commandtext value=" INSERT into db_LOG (Log_datetime, log_thread,log_level,log_logger,log_message,log_exception) VALUES (@log_date, @thread, @log_level, @logger, @message , @exception) "/><parameter><parametername value=" @log_date "/><dbtype value=" DateTime "/>< Layout type= "log4net. Layout.rawtimestamplayout "/><!--log Time--><!--<layout type=" log4net. Layout.patternlayout "value="%date{yyyy '-' mm '-' dd HH ': ' mm ': ' ss} '/>--></parameter><p arameter><parametername value= "@thread"/><dbtype value= "String"/><size value= "255"/>< Layout type= "log4net. Layout.patternlayout "><conversionpattern value="%thread "/><!--logging thread number--></layout></ Parameter><parameter><parametername value= "@log_level"/><dbtype value= "String"/><size Value= "/><layout type=" log4net. Layout.patternlayout "><conversionpattern value="%level "/><!--log level--></layout></ Parameter><parameter><parametername value= "@logger"/><dbtype value= "String"/><size value= "255"/><layout type= "log4net. Layout.patternlayout "><conversionpattern value="%logger "/><!--which logger is stored by this log--></layout></ Parameter><parameter><parametername value= "@message"/><dbtype value= "String"/><size value = "4000"/><layout type= "log4net. Layout.patternlayout "><conversionpattern value="%message "/><!--log information--></layout≫</parameter><parameter><parametername value= "@exception"/><dbtype value= "String"/> <size value= "/><layout type=" log4net. Layout.exceptionlayout "/><!--exception information--></parameter></appender><root><level value=" All "/><appender-ref ref=" Adonetappender_mysql "/></root>
Log4net log information into the MySQL database?