1. Add log4net configuration file Log4net.config
Configuration file properties are set to:
The configuration is as follows:
<?XML version= "1.0" encoding= "Utf-8"?><log4netDebug= "false"> <Appendername= "Adonetappender"type= "log4net." Appender.adonetappender "> <buffersizevalue= "2" /> <ConnectionTypevalue= "System.Data.SqlClient.SqlConnection, System.Data, version=2.0.0.0, Culture=neutral, publickeytoken= b77a5c561934e089 " /> <connectionStringvalue= "Data source=.\sqlexpress;initial catalog=testdb;integrated security=true" /> <CommandTextvalue= "INSERT into syslogs ([date],[thread],[level],[logger],[message],[exception]) VALUES (@log_date, @thread, @log_ Level, @logger, @message, @exception) " /> <parameter> <parameternamevalue= "@log_date" /> <DbTypevalue= "DateTime" /> <Layouttype= "log4net." Layout.rawtimestamplayout " /> </parameter> <parameter> <parameternamevalue= "@thread" /> <DbTypevalue= "String" /> <sizevalue= "255" /> <Layouttype= "log4net." Layout.patternlayout "> <Conversionpatternvalue= "%thread" /> </Layout> </parameter> <parameter> <parameternamevalue= "@log_level" /> <DbTypevalue= "String" /> <sizevalue= " the" /> <Layouttype= "log4net." Layout.patternlayout "> <Conversionpatternvalue= "%level" /> </Layout> </parameter> <parameter> <parameternamevalue= "@logger" /> <DbTypevalue= "String" /> <sizevalue= "255" /> <Layouttype= "log4net." Layout.patternlayout "> <Conversionpatternvalue= "%logger" /> </Layout> </parameter> <parameter> <parameternamevalue= "@message" /> <DbTypevalue= "String" /> <sizevalue= "4000" /> <Layouttype= "log4net." Layout.patternlayout "> <Conversionpatternvalue= "%message" /> </Layout> </parameter> <parameter> <parameternamevalue= "@exception" /> <DbTypevalue= "String" /> <sizevalue= "$" /> <Layouttype= "log4net." Layout.exceptionlayout " /> </parameter> </Appender> <Root> < Levelvalue= "All" /> <Appender-refref= "Adonetappender" /> </Root></log4net>
2. Create a syslogs table in the database
3.webConfig Configuration
< configsections > < name= "log4net" type= "Log4net". Config.log4netconfigurationsectionhandler, log4net "/> </ configsections> <configSource= " Log4net.config "/>
4. Setting Configuration items at application startup Global.asax
protected void Application_Start () { // When application starts, Auto load config log4net xmlconfigurator.configure (); }
5. Log Write Example
Public Static class Loghelp { publicstaticvoid Writeerror (Exception ex) { = log4net. Logmanager.getlogger ("Log"); Log. Error (ex. Message, ex); } }
log4net writing logs to SQL Server database