（二）使用log4net写入数据库自定义日志_.NET_编程开发_程序员俱乐部

1、配置项目环境

1.1 本文只显示需要修改配置的操作，初次引入log4net环境的请参考上文。

1.2 安装mysql-connector-net.msi环境，下载地址。并手动生成数据库日志信息表。

2、配置log4net.config

2.1 修改log4net.config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <log4net>
    <!-- Mysql日志类 -->
    <logger name="logdb">
      <level value="ALL" />
      <appender-ref ref="AdoNetAppender_Mysql" />
    </logger>
    
    <!-- Mysql日志附加介质 -->
    <appender name="AdoNetAppender_Mysql" type="log4net.Appender.AdoNetAppender">
      <!-- 日志信息缓冲区大小，测试时为0，实际部署可适当改为100 -->
      <bufferSize value="0" />
      <!-- mysql-connector-net版本为6.8.3以上，不需更改数据源 -->
      <ConnectionType value="MySql.Data.MySqlClient.MySqlConnection, MySql.Data, Version=6.8.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/>
      <!-- 数据库连接字符串 -->
      <ConnectionString value="server=localhost;user id=root;password=root;persist security info=True;character set=utf8;database=test;pooling=true;"/>
      <!-- 数据库日志插入命令 -->
      <commandText value="INSERT INTO loginfo (DateTime,Message,UserId) VALUES (@log_date, @message, @user_id)" />
      <parameter>
        <parameterName value="@log_date" />
        <dbType value="DateTime" />
        <layout type="log4net.Layout.RawTimeStampLayout" />
      </parameter>
      <parameter>
        <parameterName value="@message" />
        <dbType value="String" />
        <size value="255" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%message" />
        </layout>
      </parameter>
      <!-- 格式带property为自定义信息 -->
      <parameter>
        <parameterName value="@user_id" />
        <dbType value="String" />
        <size value="255" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%property{UserId}" />
        </layout>
      </parameter>
    </appender>
  </log4net>
</configuration>

3、代码使用示例

3.1 修改工具类LogHelper

namespace July.Demo.Win
{
    public class LogHelper
    {
        static readonly log4net.ILog logdb = log4net.LogManager.GetLogger("logdb");

        public static void WriteLog(string info)
        {
            if (logdb.IsInfoEnabled)
            {
　　　　　　 　　　//使用线程相关属性设定自定义信息
                log4net.ThreadContext.Properties["UserId"] = "U-1001";
                logdb.Info(info);
            }
        }
    }
}

4、运行效果

4.1 效果图如下

QQO6/fHkVi5zVJW5ZxzRLI00E764h0RICbYSDYE9SDE8MxmwC+OYiiKOr0i8ebTAn4UR/z+mO4Wq3G64elXK1f49cdpa/+juicPb09ipLQx0pW+MQRJ5SZ+bw5iMQKtCoJnHXknOjviNy80Q/ErFV8Yg1zriazCqAclG68YEr0wQxBMQct1BlD91p9nkwfn0bQ3hxG0eFlXFDWB9uvkWcFm83mN59uaQJPo8end/uy75jM0+gy2XUR0cG7x6fR41N/O/XYf6PQJocQRdnRWslrgibJpyOKyXd6eCDyUDwKdSygAE8MxgoCCK6UfrxgSug+ZrNIvTp1xtC9VsfPk5+Pv1Zis9n8483nFRJYW/I+2OoD2OuI7X597deg1fHkx8+nldhsNvvw8dMKCawteR9sRQF8/S8lz/77ssa+3Gt1NH7+/uNxJTadzd5/uFkhgbUl74M1PoCsVV8saPI+WOMD6F6rQwaDUQPq+D3wKjGZTFZLoAqCJu8Dmh1Afo8hgxEGsrxq+Mc40+lsIm0ynUymz5Pp+Hkyfp6Mx5PR+Hk0fh4Oh9Pp9NWq/605g9FUWGl1NJ7IHyXGP6F4fBrF3/n8+PkUP/iyVhmMWsFaZTDCAGuVsRYQQtgcMrhZOqhuls6WWIJWy78txRks39uSqx9001+hpHW4xtiaM1RhMujqXlGCnemBGHrH3thZviIK0ch8wUGScykaKkQRVE+yDFozO1T0t2qzTq3K6+WtVhHD7HVEaQnXLGVcyluV0qI9E/rVX9hZPxDcV6YkFEYyaIkPFqDmHkdyLkUjD1ItuBJo6cVatbwvVAHn1Xw9LtIHDa25RzJPbZlcn7Tb3a7uFWh2eVXb14J4vRp2Vlzg6fTL2TScS9GgYCnOQoGVSs74oxOwVnP16vWPy7imqDXnSJKULZNBV3QH+olspVV9X8R7FClnWScbTwvK+1OzZiFnLPliGgaYk2GhZ6lFstmtClirC8+1en3SFmAxbmJCzPI8KmkVvmfX4JxoknpcVTy6AxPnUjQwbBaloFyoXrPs5em6NF4F66jVZHMit53kqValUEluBv5qXtMNFtdIZ1NCQxmNcCYerenRqRG21ypJA8O87iV9gNIMbZr7Yq2WRf76aqeNp8+rqlD1NNVP+ffz02+rrv68igKJnI0aA+0MTJxL0UAQ1LPogtIqlhaWtyE54xMLNf8CNFur6NsYmohywGofuKA5Z9QLt1v1TCqugXFfxL60gRix0M18lSwOn0AL94FNNBCAqEgdmpfEZJu6vgoLFdFwrWq2MgB8/H5V/RZScrdnUlWrxjiU+hZUUWZ+pY3aITePS9EAUNVSKEhDziTbJOvluXVkV/7dEqOxEBbrW6FZyprbNNcb8nYVsFYZjYXQQ/UBp9g3ArKooQU3w2GtMhhBgLXKYIQB1iqDEQZYqwxGGGCtMhhhgLXKYIQBK63OZvPY5vP5LLaZtNl0NpvOZqxVBqNWZFr9keJ7ioeHh4eHh2/fvn39+58vd1+/3H29/XL3+fbu8+3dzafbjzefP958/vDx0/sPN+8/3AyHw8lkwlplMGqC+3eO3v+cr9AWi8VqCawteR+s2QF0/7zKV2s9yftgzQ4ga9UjC5q8D9bsALJWPbKgyftgagALf8cLPM0tA39LT7dWr1ZP0/+KXWyfL/9q3f883xK7p9qPdD3mrBmFrjVX5CsxOd0WG/tXVC/YmR6IofetXrHzxX4rrkA0zrcyvbT2Ll1yBlq91ysH15dSIHl64U2hotWo1Yv9VnrlrvY2iQtch5XU6tXeZhzPtP7yeGPz+CI51Nq7pGrwWTWQJ6Jnz+TyeIMQCXbWDwT31dsVSQ0KIxm0xOd8Ky9I7T2uOmdqYVJKKmZhm6Vof1N4sS1pDXyx39LcMh1b1bza21XTyFaPqilozRV5FD1bJld7m62tbV3A7XKUtq+5cqfQO2fqRacrh+7dctZo1T7XVdFb2Hk1fyX8zKuwXr2nxGVcU9SaK/IwerZMerti+1x/c7Sa9/q+1JxpcJZ6lo2nhcvjjXQSZ81CzoUXroRWLYMvNGtmkDx1OmxIXr3YbwniVlqLNU+rMnp2TJJyTVqNn0LBbZd2TjQJFsDqWlrewd1wxgF8wQKYPGVd8uoyhYquFq3VZCMk257xV6tq9GyYyHpZMAwW10hnU15FqyTCmXi0JgxEuA6t2uvHRqtNzqtLFiq6WvmJQj8p5S+8T8+rMHrFTOS+C1pkkoM1DMT0vIpEhZyNUgftnDvjbP2lF9aPWXVrkFd7u853Sgttgb72yOaZMqW0U8FqH9g0XZyRx9Erw6RqjkJ9mXb1TZvGRBJO24FbxM7zqs5erFVLHTrUZ67Z+rSafeemvV+6N3S1lFSjzfA+fr9KRs+eSfV5b4gDbtkiaGiljdpxu7dkyHJAS2bp3ue1qnMDLetOqWL8uyWPLGjyPtgL8qpNbrTJq4a7gCu5slY9sqDJ+2DmAOoEZvDXFQz1hWn8xcZa9ciCJu+DNTuArFWPLGjyPlizA8ha9ciCJu+DNTuArFWPLGjyPlizA8ha9ciCJu+DNTuArFWPLGjyPlizA+j+naN8tdaTvA/W7ADyO0cZjDDg/p2jS6POYKwV+P/IYDDCAGuVwQgDrFVGYyGEKKxRK8FPeXUnko1YHq2CerU66CbD7g5q4m/GoJvrGXyk6yVnWYdrjK05QxUmg65on1xrWgXO9EAMvWNv7Hx90o4rEI3MFxwkOeNONUEgoBMhkKLqhittPuq6wJqvgjq1msW+9mmtQaFW5YxSpljCOS3hGnxWDbg+aafNp0V7JtcnbUIk2Fk/ENyX4WqSQUt8sAA1k4HkjDslgkDDIDxZAxRlFrNZijpNBqLVDAVhrQ3l8you0gcNrblHEj5bJtcn7Xa3q4u4XV7V9rUgriZ2Vlzg6fRcMHNe5G4ZWmI5SIEtjHnVRkuWPiHnVQklRywXpbWqTqS4jGuKWnOOJHy2TAZd0R3o745WWtX3RVxNylnWycaVxJhO4qxZyJm6P8CbQEEGsBSkLqmCetXZkHvJ9nVdl0XtWo0vTSjPqx5q9fqkLcBi3MQEJzaASlolrybtnGiSelxVPLqDYs5qp/ZaXVg8r6p/F/pl8zrl1ZUlVlqryeZEbjvJU61KoZLcDPzVvKYbLK6RzkZJwKtJONs9VYIIG7VXuLiAwGIj/+IUasiZDc+rMVb0wJrvVkvC0+dVVah6muonZX0pyKRG0i77vIoCiZwtFXV90m6fDCw4K+2UeV4V+UUsmUsXnFcX5E7m0gG/jaFJKAes9oELmnNGvXC7Vc+k4hoY92W6mqZNYyIJK1kcPggDznab4cUwS8hJXgXdWdEqiSV9v7qSXeDFYqHZygDw8ftV9VtIyd2eSVWtGuNg+BZUHzS00kbtkHtL2Nn++9WFcfW7ULSnOssyrgcixHouPKUK+HdLjGYCiw3/BUcBgIONDylmV3JlrTKaDywhUoq6UwrzKk7IqphZqwzGeoG1ymCEAdYqgxEGWKsMRhhgrTIYYYC1ymCEAffvHF0adQZjrcDvHGUwwoD7d47y25zXk7wP1uwA8v+R4ZEFTd4Ha3YAWaseWdDkfbBmB5C16pEFTd4Hsw+gEKLUIbXScG7h0Sq2DK2ebouN/atVXK3zLbF7qv1I159upz+73j7X1Rhbc0W+EhN9zLEzPRBD71u9YueL/VZcgWicb2W/bG/tXRZwxp1qggADKPsAZXnUXA9aBjWkgw6upkf9Wr083iAuWF1WUqtXe5txPNP6y+ONzeOL5FBr75KqwWfVQP5iv5XOxau9TbHVK8OEjjl21g8E99XbFUkNCiMZtMTnfCsvSO09juSMOyWCQAdQVZ3N33t98gTCJqWo02RAWr3a22xtbbd81Sqq7+2qaWSrR9UUtOaKfGYX+62N/StrJuaY2+VVbV9zQiTYOVMUOl05VGaeKLcMLbFKWjXkUhu9hZ9Xe7ti+zyZak6ntc4qalWlGpdxTVFrrshLS/KqLZOCmFtpVd+XmjMNzlLPsnElMaaTOGsWcqZSt9g9NRN7kVZB/iQTJiiTOgw9ryYRZ62+iPxcdhqvA+2YFMa8klbjp1CQzWjnRJNwmaosa9O1fRFntdNSWjUkOlKr8sTCGmxh51UZSt+0mmxOZDsT/mpVCpXkZuAvC4bB4hrpbJSE1Bi80FnZ+FQJTrSbJ4WLCxhAy7x6n9etLrXKQiPzqty3SLAcueane36i0E9Kc2+fV1Wh0twgE5uYV39eRSJBzmZF5ds5t5wnRQ/tMIBltQpONNdgCzuvai9tnbZAX3tkl1O5zHlTJqvVPrB+ijsk39sldnetmVRcA+O+iH1pAzFioZsRS9uBW8SYs91mOB3AF2hVJ2CbvKqaQ33mmm22VnOphk6qcLJ68v1q1qmSbeyZVNWqMQ6Gb0H1QUMrbdQOubeEne2/XyX/gqNAqJYF/JGUPT6livHvljyyoMn7YC/QqvoRlMmCLq/iLnSVLzbWqkcWNHkfDAQQpE1cxioCCpSVoGCox2JmrVpdrbAsaPI+WLMDyFr1yIIm74M1O4CsVY8saPI+WLMDyFr1yIIm74M1O4CsVY8saPI+WLMDyFr1yIIm74M1O4D/B+qZXssu+g+vAAAAAElFTkSuQmCC" alt="" />