public void DatabaseErrorLog()
{
JobLogger.LogToDatabase();
JobLogger.EnableMessageLog();
var message = "Test error";
var statement = "[" + LogType.Error.ToString() + "] : " + message;
JobLogger.LogMessage(message, LogType.Error);
SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
connection.Open();
SqlCommand command = new SqlCommand("SELECT LogDescription FROM dbo.Log ORDER BY Id DESC LIMIT 1;");
var lastRecord = "";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
lastRecord = reader[0].ToString();
}
}
Assert.AreEqual(statement, lastRecord);
}