internal static void CleanLoggingDB(string databaseConnectionString)
{
using (var db = new LoggingDataContext(databaseConnectionString))
{
db.CategoryLogs.DeleteAllOnSubmit(db.CategoryLogs);
db.Logs.DeleteAllOnSubmit(db.Logs);
db.SubmitChanges();
}
}
internal static string GetFirstErrorFormattedMessage(string databaseConnectionString)
{
using (var db = new LoggingDataContext(databaseConnectionString))
{
var log = db.Logs.Where(e => e.Severity == "error").SingleOrDefault();
if (log == null)
return null;
return log.FormattedMessage;
}
}
internal static string GetFirstLogFormattedMessage(string databaseConnectionString)
{
using (var db = new LoggingDataContext(databaseConnectionString))
{
var log = db.Logs.Where(e => e.FormattedMessage.Contains("Extended Properties: value - testing title")).SingleOrDefault();
if (log == null)
return null;
return log.FormattedMessage;
}
}
