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