private static void AddDateTimeParameterToAppender(this AdoNetAppender appender, string paramName)
{
AdoNetAppenderParameter param = new AdoNetAppenderParameter();
param.ParameterName = paramName;
param.DbType = System.Data.DbType.DateTime;
param.Layout = new RawUtcTimeStampLayout();
appender.AddParameter(param);
}
private static void AddStringParameterToAppender(this AdoNetAppender appender, string paramName, int size, string conversionPattern)
{
AdoNetAppenderParameter param = new AdoNetAppenderParameter();
param.ParameterName = paramName;
param.DbType = System.Data.DbType.String;
param.Size = size;
param.Layout = new Layout2RawLayoutAdapter(new PatternLayout(conversionPattern));
appender.AddParameter(param);
}
private static void AddErrorParameterToAppender(this AdoNetAppender appender, string paramName, int size)
{
AdoNetAppenderParameter param = new AdoNetAppenderParameter();
param.ParameterName = paramName;
param.DbType = System.Data.DbType.String;
param.Size = size;
param.Layout = new Layout2RawLayoutAdapter(new ExceptionLayout());
appender.AddParameter(param);
}
public static IAppender CreateAdoNetAppender(string connectionString)
{
AdoNetAppender appender = new AdoNetAppender()
{
Name = "AdoNetAppender",
BufferSize = 1,
ConnectionType = "System.Data.SqlClient.SqlConnection, System.Data, Version = 1.0.3300.0, Culture = neutral, PublicKeyToken = b77a5c561934e089",
ConnectionString = connectionString,
CommandText = "INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)"
};
AddDateTimeParameterToAppender(appender, "@log_date");
AddStringParameterToAppender(appender, "@thread", 255, "%thread");
AddStringParameterToAppender(appender, "@log_level", 50, "%level");
AddStringParameterToAppender(appender, "@logger", 255, "%logger");
AddStringParameterToAppender(appender, "@message", 4000, "%message");
AddErrorParameterToAppender(appender, "@exception", 2000);
appender.ActivateOptions();
return(appender);
}