Log4net使用自定义附加程序将自定义对象写入sql数据库? [英] Log4net writing custom object to sql database using custom appender?
问题描述
在我的表格中使用SQL Server 2012:
Using SQL Server 2012 here is my table:
CREATE TABLE [dbo].[Test]
(
[One] [VARCHAR](50) NOT NULL,
[Two] [VARCHAR](50) NOT NULL
) ON [PRIMARY]
这是我的appender:
Here is my appender:
<appender name="TestAppender" type="log4net.Appender.AdoNetAppender">
<bufferSize value="1" />
<connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<connectionString value="data source=localhost;initial catalog=ApplicationLog;integrated security=false;persist security info=True;User ID=someUser;Password=somePassword" />
<commandText value="INSERT INTO [dbo].[Test] ([One],[Two]) VALUES (@one, @two)" />
<parameter>
<parameterName value="@one"/>
<dbType value="String"/>
<size value="50"/>
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%one"/>
</layout>
</parameter>
<parameter>
<parameterName value="@two"/>
<dbType value="String"/>
<size value="50"/>
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%two"/>
</layout>
</parameter>
</appender>
这是我如何在代码中获取记录器实例并尝试对其进行写入的方法:
Here is how I get the instance of the logger in code and try to write to it:
private static readonly ILog TestLogger = LogManager.GetLogger("TestAppender");
TestLogger.Info(new Test {One = "someOne", Two = "someTwo"});
这是我的考试班:
public class Test
{
public string One { get; set; }
public string Two { get; set; }
}
完成此操作后,我的表中有一条记录,列的内容如下:
After stepping through this, I have a record in my table and the contents of the columns are this:
One: "one" Two: "12wo"
"12wo"到底是什么?我知道我在这里错过了一些东西.我认为我的转换模式是错误的.我已经尝试过了:
What the heck is "12wo"? I know I'm missing something here. I think my conversion patterns are wrong. I've tried this instead:
<conversionPattern value="%property{one}"/>
..但是那也不起作用.我是否必须编写自定义图案布局或其他内容?谢谢.
..but that doesn't work either. Do I have to write a custom pattern layout or something? Thanks.
推荐答案
此网站为我指明了正确的方向.
This site pointed me in the right direction.
我必须创建一个自定义LayoutPattern和PatternConverter才能成功将我的对象写入日志.原来我在数据库中得到的奇怪的"12wo"文本是因为转换模式使用了printf c样式语法.无论如何,这是一些代码.
I had to create a custom LayoutPattern and PatternConverter in order to write my object to the log successfully. Turns out the weird "12wo" text I was getting in the database was because the conversion pattern uses printf c style syntax. Anyhow, here's some code.
public class TestLayoutPattern : PatternLayout
{
public TestLayoutPattern()
{
AddConverter(new ConverterInfo
{
Name = "test",
Type = typeof (TestConverter)
});
}
}
public class TestConverter : PatternConverter
{
protected override void Convert(System.IO.TextWriter writer, object state)
{
if (state == null)
{
writer.Write(SystemInfo.NullText);
return;
}
var loggingEvent = state as LoggingEvent;
if (loggingEvent == null)
throw new NullReferenceException("loggingEvent");
var test = loggingEvent.MessageObject as Test;
if (test == null)
{
writer.Write(SystemInfo.NullText);
}
else
{
switch (Option.ToLower())
{
case "one":
writer.Write(test.One);
break;
case "two":
writer.Write(test.Two);
break;
default:
writer.Write(SystemInfo.NullText);
break;
}
}
}
}
以下是通过名称获取记录器实例的方法:
Here is how to get an instance of the logger by name:
private static readonly ILog TestLogger = LogManager.GetLogger("TestLogger");
这是将Test对象写入日志的方法.
Here is how to write a Test object to the log.
TestLogger.Info(new Test {One = "field one", Two = "field two"});
这是应该在web.config中定义参数的方式.
Here is how a parameter should be defined in the web.config.
<parameter>
<parameterName value="@one" />
<dbType value="String" />
<size value="50" />
<layout type="MyApp.TestLayoutPattern">
<conversionPattern value="%test{one}" />
</layout>
</parameter>
要注意的另一件事是web.config的root和logger部分.在根部分中,定义了默认记录器及其级别集.我可以在记录器部分中定义我的自定义TestLogger,该记录器部分将引用该附加器,如下所示.这样,我就可以按上面的名称访问TestLogger.
Another thing to note is the root and logger sections of the web.config. In the root section is where the default logger is defined with its level set. I can define my custom TestLogger in a logger section which will reference the appender as shown below. This allows me to access the TestLogger by name as shown above.
<root>
<level value="ALL"/>
<appender-ref ref="ADONetAppender"/>
</root>
<logger additivity="false" name="TestLogger">
<level value="ALL"/>
<appender-ref ref="TestAppender" />
</logger>
我还发现,如果您只想向默认的ADONetAppender添加一些属性(并向表中添加一些字段),则可以改用log4net.ThreadContext来设置这些属性,如下所示:
I also found if you wanted to just add a few properties to the default ADONetAppender (and add a few fields to the table), you could instead use the log4net.ThreadContext to set those properties like so:
log4net.ThreadContext.Properties["MyCustomPrperty"] = value;
然后在web.config中的参数部分下,您可以像这样访问该属性:
Then in the web.config under the parameter section you can access that property like this:
<parameter>
<parameterName value="@myCustomProperty"/>
<dbType value="String"/>
<layout type="log4net.Layout.RawPropertyLayout">
<key value="MyCustomProperty" />
</layout>
</parameter>
这篇关于Log4net使用自定义附加程序将自定义对象写入sql数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!