private void deleteFromDB(LogEvent logevent) { using (LogEventDataContext logDb = new LogEventDataContext(LogEventDataContext.ConnectionString)) { if (!logDb.DatabaseExists()) { System.Diagnostics.Debug.WriteLine(this.GetType().Name + ": DB does not exist"); return; } logDb.DeleteLogEvent(logevent.EventId); } }
private void SendMessages() { System.Diagnostics.Debug.WriteLine(this.GetType().Name + ".SendMessages"); using (LogEventDataContext logDb = new LogEventDataContext(LogEventDataContext.ConnectionString)) { if (!logDb.DatabaseExists()) { System.Diagnostics.Debug.WriteLine(this.GetType().Name + ": DB does not exist"); return; } List<LogEvent> events = logDb.GetLogEvents(); foreach (LogEvent e in events) { SendMessage(e); } } System.Diagnostics.Debug.WriteLine(this.GetType().Name + ".AsyncSendMessages event handler finished"); }
/// <summary> /// Creates and adds a few ItemViewModel objects into the Items collection. /// </summary> public void GetLogData() { const string ConnectionString = @"Data Source = 'isostore:/LogEventDB.sdf';"; using (LogEventDataContext logDBContext = new LogEventDataContext(ConnectionString)) { if (!logDBContext.DatabaseExists()) { // create database if it does not exist try { logDBContext.CreateDatabase(); } catch (InvalidOperationException ioe) { System.Diagnostics.Debug.WriteLine("InvalidOperationException while creating database..." + ioe); } } GetLogEvents(logDBContext); } }