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); }