public void TestSolutiaLogToDatabaseTableSucceeds()
{
var dbSink = new DatabaseLogSink()
{
ConnectionString = "Data Source=LAPTOP-6EA15661\\SQLEXPRESS;Initial Catalog=Logging;Integrated Security=True",
CommandText = @"
INSERT INTO[dbo].[Log]
([SeverityLevel]
,
[Message]
,
[Source], DateCreated, ApplicationName)
VALUES
(@SeverityLevel
,@Message
,@Source, GETDATE(), @ApplicationName);",
CommandType = CommandType.Table,
Name = "TestLogger",
Parameters = new List <DbLogSinkCommandParameter>()
{
new DbLogSinkCommandParameter()
{
Name = "SeverityLevel",
LogEntryComponent = LogEntryComponent.LogLevel
},
new DbLogSinkCommandParameter()
{
Name = "Message",
LogEntryComponent = LogEntryComponent.Message
},
new DbLogSinkCommandParameter()
{
Name = "Source",
LogEntryComponent = LogEntryComponent.MachineName
},
new DbLogSinkCommandParameter()
{
Name = "ApplicationName",
LogEntryComponent = LogEntryComponent.ApplicationName
}
}
};
new Solutia.Logging.Nlog.Implementation.LogWriter("d")
.Configure(new List <DatabaseLogSink>()
{
dbSink
})
.Log(new LogMessage("Hello from Solutia Database Table Logger", EventLevel.Debug))
.Log(new ApplicationLogMessage("ThisApp", "This Message", EventLevel.Debug));
}
public void TestSolutiaLogToDatabaseSucceeds()
{
var dbSink = new DatabaseLogSink()
{
ConnectionString = "Data Source=LAPTOP-6EA15661\\SQLEXPRESS;Initial Catalog=Logging;Integrated Security=True",
CommandText = "WriteLog",
Name = "TestLogger",
CommandType = CommandType.StoredProcedure,
Parameters = new List <DbLogSinkCommandParameter>()
{
new DbLogSinkCommandParameter()
{
Name = "SeverityLevel",
LogEntryComponent = LogEntryComponent.LogLevel
},
new DbLogSinkCommandParameter()
{
Name = "Source",
LogEntryComponent = LogEntryComponent.MachineName
},
new DbLogSinkCommandParameter()
{
Name = "Message",
LogEntryComponent = LogEntryComponent.Message
},
new DbLogSinkCommandParameter()
{
Name = "LogId",
LogEntryComponent = LogEntryComponent.LogId
}
}
};
new Solutia.Logging.Nlog.Implementation.LogWriter("d")
.Configure(new List <DatabaseLogSink>()
{
dbSink
})
.Log(new LogMessage("Hello from Solutia Sproc Logger", EventLevel.Debug));
}
public void TestSolutiaLogToDatabaseFileAndEventLogSucceeds()
{
var entryConfig = new List <LogEntryComponent>()
{
LogEntryComponent.Date,
LogEntryComponent.MachineName,
LogEntryComponent.Message,
LogEntryComponent.LogLevel,
LogEntryComponent.ApplicationName
};
var fileSink = new FileLogSink()
{
Name = "TestLogger",
MinimumEventLevel = EventLevel.Trace,
FileName = "c:\\solutiatest\\testlog.txt",
LogEntryConfiguration = entryConfig
};
var elSink = new EventLogSink()
{
Name = "TestLogger",
Source = "TestLogger",
Log = "TestLogger",
MinimumEventLevel = EventLevel.Trace,
LogEntryConfiguration = entryConfig
};
var dbSink = new DatabaseLogSink()
{
ConnectionString = "Data Source=LAPTOP-6EA15661\\SQLEXPRESS;Initial Catalog=Logging;Integrated Security=True",
CommandText = "WriteLog",
Name = "TestLogger",
CommandType = CommandType.StoredProcedure,
Parameters = new List <DbLogSinkCommandParameter>()
{
new DbLogSinkCommandParameter()
{
Name = "SeverityLevel",
LogEntryComponent = LogEntryComponent.LogLevel
},
new DbLogSinkCommandParameter()
{
Name = "Source",
LogEntryComponent = LogEntryComponent.MachineName
},
new DbLogSinkCommandParameter()
{
Name = "Message",
LogEntryComponent = LogEntryComponent.Message
},
new DbLogSinkCommandParameter()
{
Name = "LogId",
LogEntryComponent = LogEntryComponent.LogId
},
new DbLogSinkCommandParameter()
{
Name = "ApplicationName",
LogEntryComponent = LogEntryComponent.ApplicationName
}
}
};
ILogWriter writer = new LogWriter("d")
.Configure(new List <ILogSink>()
{
fileSink, elSink, dbSink
})
.Log(new LogMessage("Hello from Solutia File Logger", EventLevel.Debug));
writer.Log(new ExceptionLogMessage(new NullReferenceException("This is an exceptional exception.")));
writer.Log(new ApplicationLogMessage("ThisApp", "This Message", EventLevel.Debug));
}
