internal static void CleanLoggingDB(string databaseConnectionString)
{
using (var db = new TracingDataContext(databaseConnectionString))
{
db.Traces.DeleteAllOnSubmit(db.Traces);
db.SubmitChanges();
}
}
internal static Trace GetFirstLog(string databaseConnectionString)
{
using (var db = new TracingDataContext(databaseConnectionString))
{
return db.Traces.FirstOrDefault();
}
}
internal static string GetFirstLogFormattedMessage(string databaseConnectionString)
{
using (var db = new TracingDataContext(databaseConnectionString))
{
var log = db.Traces.Where(e => e.FormattedMessage.Contains("Extended Properties: value - testing title")).SingleOrDefault();
if (log == null)
return null;
return log.FormattedMessage;
}
}
internal static List<Trace> GetAllLogEntries(string databaseConnectionString)
{
using (var db = new TracingDataContext(databaseConnectionString))
{
return db.Traces.ToList();
}
}
internal static List<Trace> GetExceptionsFromDB(string databaseConnectionString)
{
using (var db = new TracingDataContext(databaseConnectionString))
{
return db.Traces.Where(e => e.Level == 2).ToList();
}
}