<?xmlversion="1.0"encoding="utf-8"?><log4net><!--<appendername="RollingFileAppender"type="log4net.Appender.RollingFileAppender">--><!--指定输入到文本--><appendername="RollingFileAppender"type="log4net.Appender.ADONetAppender"><!--指定输入到数据库--><!--定义数据库配置--><bufferSizevalue="1"/><!--bufferSize表示是记录10条到缓冲区,满10条后再写入SQLserver,测试时将其改为1,生产环境建议100--><connectionTypevalue="System.Data.SqlClient.SqlConnection,System.Data,Version=1.0.5000.0,Culture=neutral,PublicKeyToken=b77a5c561934e089"/><connectionStringvalue="DATABASE=SimpleTaskSystemDb;SERVER=.;UID=sa;PWD=123456;ConnectTimeout=15;"/><commandTextvalue="INSERTINTOErrorLog([dtDate],[sThread],[sLevel],[sLogger],[sMessage],[sException])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="100"/><layouttype="log4net.Layout.PatternLayout"><conversionPatternvalue="%t"/></layout></parameter><parameter><parameterNamevalue="@log_level"/><dbTypevalue="String"/><sizevalue="200"/><layouttype="log4net.Layout.PatternLayout"><conversionPatternvalue="%p"/></layout></parameter><parameter><parameterNamevalue="@logger"/><dbTypevalue="String"/><sizevalue="500"/><layouttype="log4net.Layout.PatternLayout"><conversionPatternvalue="%logger"/></layout></parameter><parameter><parameterNamevalue="@message"/><dbTypevalue="String"/><sizevalue="3000"/><layouttype="log4net.Layout.PatternLayout"><conversionPatternvalue="%m"/></layout></parameter><parameter><parameterNamevalue="@exception"/><dbTypevalue="String"/><sizevalue="4000"/><layouttype="log4net.Layout.ExceptionLayout"/></parameter><!--定义文件存放位置--><filevalue="Logs/Logs.txt"/><appendToFilevalue="true"/><rollingStylevalue="Size"/><maxSizeRollBackupsvalue="10"/><maximumFileSizevalue="10000KB"/><staticLogFileNamevalue="true"/><layouttype="log4net.Layout.PatternLayout"><conversionPatternvalue="%-5level%date[%-5.5thread]%-40.40logger-%message%newline"/></layout></appender><root><appender-refref="RollingFileAppender"/><levelvalue="DEBUG"/></root><loggername="NHibernate"><levelvalue="WARN"/></logger></log4net>