TOMMYHU

项目有在ASP .NET MVC下作日志并写到数据库里面的的需求，于是在网上搜寻资料，发现解决方法五花八门，把别人的东西放到自己的机器上，发现问题不能解决，搞了将近两天，终于解决了这个问题，在此记录下来 。
在asp.net-mvc下如何做日志 asp.net-mvc如何做系统日志 asp.netc# asp.net-mvc ELMAH
一，首先先解决写到一般文件里的问题：
解决步骤：
1.首先下载个log4net.dll.并放到你的reference中
2.在AssemblyInfo.cs最下面加入一行
   [assembly: log4net.Config.XmlConfigurator(ConfigFile = "log4net.config", Watch = true)]，这里log4net.config是你将要
   放置一些配置的地方。这个文件放在项目的根目录下。内容为：
<?xml version="1.0"?>   <configuration>     <configSections>       <section name="log4net" type="System.Configuration.IgnoreHandlerSection"/>     </configSections>     <log4net>       <appender name="console" type="log4net.Appender.ConsoleAppender"></appender>       <root>         <level value="WARN" />         <appender-ref ref="LogFileAppender" />       </root>       <logger name="Test">         <level value="DEBUG"/>       </logger>       <appender name="LogFileAppender" type="log4net.Appender.FileAppender" >         <param name="File" value="D:\Documents and Settings\E518731\log.txt" />         <param name="AppendToFile" value="true" />         <layout type="log4net.Layout.PatternLayout">           <param name="Header" value="[Header]\r\n"/>           <param name="Footer" value="[Footer]\r\n"/>           <param name="ConversionPattern" value="%d [%t] %-5p %c [%x]  - %m%n"/>         </layout>       </appender>     </log4net>     </configuration>
3.Controller中的代码如此写:
    public class HomeController : Controller           {               log4net.ILog log = log4net.LogManager.GetLogger("Test");                              public ActionResult Index()               {                   log.Error("haha");                   return View();               }           }  
这样你就可以写log到某个file里面了.

二,解决写自定义log到数据库里面的问题
1.首先下载个log4net.dll.并放到你的reference中

2.在Global.asax的Application_Start方法中加入如下一行
log4net.Config.XmlConfigurator.Configure();
3.建立一个自定义的log对象
    public class LogContent       {           public string contents;           public int userId;       }  
4.在Web.config的configSections中加入如下一节
    <section name="log4net"       type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />  
5.在configSections节外面加入如下
    <log4net>           <appender name="ADONetAppender" type="log4net.Appender.ADONetAppender">                 <bufferSize value="0" />                 <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />                 <connectionString value="server=ch71dtbfxt12x\SQLEXPRESS; uid=sa; pwd=password; database=ATMS" />                 <commandText value="INSERT INTO Logs ([createdAt],[contents],[userId],[severity]) VALUES                  (@log_date,  @contents,@userId,@level)" />                                  <parameter>                   <parameterName value="@log_date" />                   <dbType value="DateTime" />                   <layout type="log4net.Layout.RawTimeStampLayout" />                 </parameter>                                              <parameter>                   <parameterName value="@contents" />                   <dbType value="String" />                   <size value="256" />                   <layout type="ATMS.ATMSWeb.Log4Net.MyLayout">                     <conversionPattern value="%Contents" />                   </layout>                 </parameter>                                  <parameter>                   <parameterName value="@userId"/>                   <dbType value="Int32"/>                   <layout type="ATMS.ATMSWeb.Log4Net.MyLayout">                     <conversionPattern value="%UserId" />                   </layout>                 </parameter>                 <parameter>                   <parameterName value="@level" />                   <dbType value="String" />                   <size value="256" />                   <layout type="log4net.Layout.PatternLayout" value="%level" />                 </parameter>             </appender>           <root>             <level value="DEBUG" />             <appender-ref ref="ADONetAppender" />           </root>         </log4net>  
6.新建一个文件,包含如下:
    namespace ATMS.ATMSWeb.Log4Net       {           public class MyLayout : PatternLayout             {                 public MyLayout()                 {                   this.AddConverter("Contents", typeof(ContentsPatternConverter));                   this.AddConverter("UserId", typeof(UserIdPatternConverter));                 }             }           public class ContentsPatternConverter : PatternLayoutConverter             {               override protected void Convert(TextWriter writer, LoggingEvent loggingEvent)               {                   LogContent logMessage = loggingEvent.MessageObject as LogContent;                   if (logMessage != null)                       writer.Write(logMessage.contents);               }           }           public class UserIdPatternConverter : PatternLayoutConverter           {               override protected void Convert(TextWriter writer, LoggingEvent loggingEvent)               {                   LogContent logMessage = loggingEvent.MessageObject as LogContent;                   if (logMessage != null)                       writer.Write(logMessage.userId);               }           }       }  
7.记日志的时候,如下写法:
    private static readonly ILog log = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);       log.Error(new LogContent {contents="ss",userId=4 });  
这下子你就可以把日至写到数据库表中了.

具体的有些配置可能因人而异，比如数据库连接串的配置。有什么不明白的，欢迎留言!
原文出处：http://blog.csdn.net/xutao_ustc/archive/2010/12/05/6055899.aspx，感谢作者的分享！

---

看到这里，再向大家推荐一款工具
      ELMAH（下载地址：http://code.google.com/p/elmah/）
　　ELMAH是一款优秀的MVC应用程序日志记录工具，如果你还没有用过它，强烈建议你试一试，虽然需要一翻设置，但其功能的确很强大，这里列一个快速清单以供参考：
    记录几乎所有未处理的异常；
    通过网页远程查看全部日志；
    通过网页远程查看任何单条日志的详细信息；
    即使customErrors模式关闭，大多数时候，你可以查看ASP.NET因异常产生的原始黄色死机屏幕；
    发生错误时会自动发送一封电子邮件通知；
    RSS种子提供最后15个错误日志的信息。

ELMAH使用方法
ELMAH(Error Logging Modules and Handlers for ASP.NET )是一款ASP.NET下的系统错误记录管理工具，它可以非常方便的把“黄屏”错误记录到XML，MS SQLServer，SQLite，MySql等文件中，甚至它还可以发送邮件。

这里我就记一下使用它的方法。本文以记录到MS SQL Server 2005为例：

1. 下载ELMAH
   ELMAH官方地址：http://code.google.com/p/elmah/
         版本：ELMAH-1.0-BETA2-bin.zip

2.把dll文件复制到项目的bin目录下。
   DLL文件：Elmah.dll
         版本：1.0.9414.1441
         大小：114688 bytes ( 112.000 KB,  0.109 MB )

3.设置Web.config
  xml version="1.0" encoding="utf-8"?> <configuration>   <configSections>     <错误日志管理系统 >     <sectionGroup name="elmah">       <section name="security"  type="Elmah.SecuritySectionHandler, Elmah"/>       <section name="errorLog" type="Elmah.ErrorLogSectionHandler, Elmah"/>       <section name="errorMail" type="Elmah.ErrorMailSectionHandler, Elmah"/>       <section name="errorFilter"  type="Elmah.ErrorFilterSectionHandler, Elmah"/>     <sectionGroup>   <configSections>   <elmah>     <security allowRemoteAccess="0" />     <errorLog type="Elmah.SqlErrorLog, Elmah"             connectionStringName="ConnectionString" />   <elmah>   < elmah只允许管理员访问>   <location path="elmah.axd">     <system.web>       <authorization>         <deny users="?"/>         <allow users="Admin"/>       <authorization>     <system.web>   <location>       <appSettings /> <  连接字符串>   <connectionStrings>     <add name="ConnectionString" connectionString="Data Source=qq\SQLEXPRESS;Initial Catalog=xx;User ID=xx;Password=xx" providerName="System.Data.SqlClient" />   <connectionStrings>     <system.web>       <httpHandlers>         <add verb="POST,GET,HEAD" path="elmah.axd" type="Elmah.ErrorLogPageFactory, Elmah"/>       <httpHandlers>       <httpModules>         <add name="ErrorLog" type="Elmah.ErrorLogModule, Elmah"/>       <httpModules>    <compilation debug="true" />       <authentication mode="Forms">         <forms loginUrl="login.aspx" name=".ASPXAUTH"><forms>       <authentication>       <authorization>         <deny users="*"/>        <authorization>     <system.web> <configuration>
4.向数据添加表
/* 错误管理工具 SQL代码             */ CREATE TABLE dbo.ELMAH_Error (     ErrorId     UNIQUEIDENTIFIER NOT NULL,     Application NVARCHAR(60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,     Host        NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,     Type        NVARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,     Source      NVARCHAR(60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,     Message     NVARCHAR(500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,     [User]      NVARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,     StatusCode  INT NOT NULL,     TimeUtc     DATETIME NOT NULL,     Sequence    INT IDENTITY (1, 1) NOT NULL,     AllXml      NTEXT COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE dbo.ELMAH_Error WITH NOCHECK ADD     CONSTRAINT PK_ELMAH_Error PRIMARY KEY NONCLUSTERED     (         ErrorId     )  ON [PRIMARY] GO ALTER TABLE dbo.ELMAH_Error ADD     CONSTRAINT DF_ELMAH_Error_ErrorId DEFAULT (newid()) FOR [ErrorId] GO CREATE NONCLUSTERED INDEX IX_ELMAH_Error_App_Time_Seq ON dbo.ELMAH_Error (     [Application] ASC,     [TimeUtc] DESC,     [Sequence] DESC ) ON [PRIMARY] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE dbo.ELMAH_GetErrorXml (     @Application NVARCHAR(60),     @ErrorId UNIQUEIDENTIFIER ) AS SET NOCOUNT ON SELECT     AllXml FROM     ELMAH_Error WHERE     ErrorId = @ErrorId AND     Application = @Application GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE dbo.ELMAH_GetErrorsXml (     @Application NVARCHAR(60),     @PageIndex INT = 0,     @PageSize INT = 15,     @TotalCount INT OUTPUT ) AS SET NOCOUNT ON DECLARE @FirstTimeUTC DateTime DECLARE @FirstSequence int DECLARE @StartRow int DECLARE @StartRowIndex int -- Get the ID of the first error for the requested page SET @StartRowIndex = @PageIndex * @PageSize + 1 SET ROWCOUNT @StartRowIndex SELECT       @FirstTimeUTC = TimeUTC,     @FirstSequence = Sequence FROM     ELMAH_Error WHERE       Application = @Application ORDER BY     TimeUTC DESC,     Sequence DESC -- Now set the row count to the requested page size and get -- all records below it for the pertaining application. SET ROWCOUNT @PageSize SELECT     @TotalCount = COUNT(1) FROM     ELMAH_Error WHERE     Application = @Application SELECT     errorId,     application,     host,     type,     source,     message,     [user],     statusCode,     CONVERT(VARCHAR(50), TimeUtc, 126) + 'Z' time FROM     ELMAH_Error error WHERE     Application = @Application AND     TimeUTC <= @FirstTimeUTC AND     Sequence <= @FirstSequence ORDER BY     TimeUTC DESC,     Sequence DESC FOR     XML AUTO GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE dbo.ELMAH_LogError (     @ErrorId UNIQUEIDENTIFIER,     @Application NVARCHAR(60),     @Host NVARCHAR(30),     @Type NVARCHAR(100),     @Source NVARCHAR(60),     @Message NVARCHAR(500),     @User NVARCHAR(50),     @AllXml NTEXT,     @StatusCode INT,     @TimeUtc DATETIME ) AS SET NOCOUNT ON INSERT INTO     ELMAH_Error     (         ErrorId,         Application,         Host,         Type,         Source,         Message,         [User],         AllXml,         StatusCode,         TimeUtc     ) VALUES     (         @ErrorId,         @Application,         @Host,         @Type,         @Source,         @Message,         @User,         @AllXml,         @StatusCode,         @TimeUtc     ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
5 预览
http://localhost/youresiteName/elmah.axd
可能需要先登录login.aspx.如果不需要登录,可以在web.config里删掉相应代码.
更多查看本博ELMAH专属日志http://tommyhu.cn/ELMAH/
最后编辑： tommyhu 编辑于2011/04/20 23:43