EnterpriseLibrary6.0 log2database

1、引用EnterpriseLibrary6.0相关dll

2、安装Microsoft.Practices.EnterpriseLibrary.ConfigConsoleV6.vsix

　　主要为了方便编辑config文件，不是必须安装，安装后需要更改解决方案属性，将Enterprise Library v6 binaries path 指向企业库6.0的bin目录

3、执行sql脚本创建记录日志的数据库、存储过程、表

　　下载的包中提供了脚本，目录：Enterprise Library 6devguidesamplesLoggingScriptsLoggingDatabase.sql

4、配置config文件

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <!--微软企业库6.0 配置Begin-->
  <configSections>
    <section name="loggingConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings, Microsoft.Practices.EnterpriseLibrary.Logging, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="true" />
    <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="true" />
  </configSections>


  <loggingConfiguration name="" tracingEnabled="true" defaultCategory="General">
    <listeners>
      <add name="Event Log Listener" type="Microsoft.Practices.EnterpriseLibrary.Logging.TraceListeners.FormattedEventLogTraceListener, Microsoft.Practices.EnterpriseLibrary.Logging, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.FormattedEventLogTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        source="Enterprise Library Logging" formatter="Text Formatter"
        log="" machineName="." traceOutputOptions="None" />
      <add name="Database Trace Listener" type="Microsoft.Practices.EnterpriseLibrary.Logging.Database.FormattedDatabaseTraceListener, Microsoft.Practices.EnterpriseLibrary.Logging.Database, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Database.Configuration.FormattedDatabaseTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging.Database, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        databaseInstanceName="LoggingCore" writeLogStoredProcName="WriteLog"
        addCategoryStoredProcName="AddCategory" />
    </listeners>
    <formatters>
      <add type="Microsoft.Practices.EnterpriseLibrary.Logging.Formatters.TextFormatter, Microsoft.Practices.EnterpriseLibrary.Logging, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        template="Timestamp: {timestamp}{newline}&#xA;Message: {message}{newline}&#xA;Category: {category}{newline}&#xA;Priority: {priority}{newline}&#xA;EventId: {eventid}{newline}&#xA;Severity: {severity}{newline}&#xA;Title:{title}{newline}&#xA;Machine: {localMachine}{newline}&#xA;App Domain: {localAppDomain}{newline}&#xA;ProcessId: {localProcessId}{newline}&#xA;Process Name: {localProcessName}{newline}&#xA;Thread Name: {threadName}{newline}&#xA;Win32 ThreadId:{win32ThreadId}{newline}&#xA;Extended Properties: {dictionary({key} - {value}{newline})}"
        name="Text Formatter" />
    </formatters>
    <categorySources>
      <add switchValue="All" name="General">
        <listeners>
          <add name="Event Log Listener" />
          <add name="Database Trace Listener" />
        </listeners>
      </add>
    </categorySources>
    <specialSources>
      <allEvents switchValue="All" name="All Events">
        <listeners>
          <add name="Database Trace Listener" />
          <add name="Event Log Listener" />
        </listeners>
      </allEvents>
      <notProcessed switchValue="All" name="Unprocessed Category">
        <listeners>
          <add name="Database Trace Listener" />
          <add name="Event Log Listener" />
        </listeners>
      </notProcessed>
      <errors switchValue="All" name="Logging Errors &amp; Warnings">
        <listeners>
          <add name="Event Log Listener" />
          <add name="Database Trace Listener" />
        </listeners>
      </errors>
    </specialSources>
  </loggingConfiguration>
  <!--微软企业库6.0 配置End-->

  <!--指定默认数据库 必须配置-->
  <dataConfiguration defaultDatabase="myDataBase" />
  <connectionStrings>
    <add name="myDataBase" connectionString="Initial Catalog=EricTest;Data Source=127.0.0.1;UID=sa;Password=Az.123456;"
      providerName="System.Data.SqlClient" />
    <add name="LoggingCore" connectionString="Initial Catalog=Logging;Data Source=127.0.0.1;UID=sa;Password=Az.123456;"
      providerName="System.Data.SqlClient" />
  </connectionStrings>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
  </startup>
</configuration>

5、实例代码

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Common.Configuration;
using System.Data.Common;
using System.Data;
using Microsoft.Practices.EnterpriseLibrary.Logging;

namespace EntLib6Test
{
    class Program
    {

        static void Main(string[] args)
        {

            IConfigurationSource configurationSource = ConfigurationSourceFactory.Create();
            DatabaseFactory.SetDatabaseProviderFactory(new DatabaseProviderFactory(configurationSource), false);
            LogWriterFactory logWriterFactory = new LogWriterFactory(configurationSource);
            Logger.SetLogWriter(logWriterFactory.Create(), false);


            string sql = @"SELECT Name from T_UserBase";

            DatabaseProviderFactory factory = new DatabaseProviderFactory();
            Database db = factory.CreateDefault();

            using (DbCommand sqlCmd = db.GetSqlStringCommand(sql))
            {
                DataSet userList = db.ExecuteDataSet(sqlCmd);

                if (userList != null && userList.Tables.Count > 0 && userList.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < userList.Tables[0].Rows.Count; i++)
                    {
                        Console.WriteLine(userList.Tables[0].Rows[i]["Name"].ToString());
                    }
                }
            }



            try
            {
                int a = 1;
                int b = 0;
                int c = a / b;
            }
            catch (Exception ex)
            {
                LogEntry logEntry = new LogEntry();
                logEntry.EventId = 1;
                logEntry.Priority = 1;
                logEntry.Severity = System.Diagnostics.TraceEventType.Error;
                logEntry.Title = "标题";
                logEntry.Message = "错误信息"+ex.Message;
                logEntry.Categories.Add("EntLib6");

                Logger.Writer.Write(logEntry, "General");
                Console.WriteLine("日志写入完成!");    

            }

            Console.ReadKey();
        }
    }
}

6、注意事项

　　记录日志到数据库代码中需要加入以下代码，否则会报错

            IConfigurationSource configurationSource = ConfigurationSourceFactory.Create();
            DatabaseFactory.SetDatabaseProviderFactory(new DatabaseProviderFactory(configurationSource), false);
            LogWriterFactory logWriterFactory = new LogWriterFactory(configurationSource);
            Logger.SetLogWriter(logWriterFactory.Create(), false);

　　调试中异常信息并不能写入数据库，编译后以管理员身份运行会才能写入数据库，解决方法待确认

　　事件查看器发布后可以写入日志需要对Event Log Listener中的source做以下操作

　　<!-- source 值为 Enterprise Library Logging
　　就需要在注册表
　　HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesEventLogApplication
　　上右键加一个项名称也叫 Enterprise Library Logging 否则发布后日志不会成功记录
　　-->