public void LoadDataSource() { EntityConnectionStringBuilder entityBuilder; if (!CreateConnection(out entityBuilder)) { return; } if (ItemsList != null) { ItemsList.Clear(); } using (LoggerEntities context = new LoggerEntities(entityBuilder.ConnectionString)) { try { ItemsList = new ObservableCollection <LogEntry>(context.LogEntries.OrderByDescending(l => l.id).ToList()); } catch (Exception e) { logger.ErrorException("LoadDataSource", e); MessageBox.Show(e.Message); } } }
/// <summary> /// Clears log at once /// </summary> public void ClearLog() { EntityConnectionStringBuilder entityBuilder; if (!CreateConnection(out entityBuilder)) { return; } using (LoggerEntities context = new LoggerEntities(entityBuilder.ConnectionString)) { try { var list = new ObservableCollection <LogEntry>(context.LogEntries.ToList()); foreach (var logEntry in list) { context.DeleteObject(logEntry); } context.SaveChanges(); LoadDataSource(); } catch (Exception e) { logger.ErrorException("LoadDataSource", e); MessageBox.Show(e.Message); } } }