public void LoadData() { this.Items.Clear(); JourneyRepository journeyRepository = new JourneyRepository(); IEnumerable<Journey> journeys = journeyRepository.GetAll().Reverse(); foreach (Journey journey in journeys) { ItemViewModel item = new ItemViewModel() { Id = journey.Id, LineOne = string.Format( "{0:#,0} {1}", journey.Miles, App.Settings.UnitType.ToString().ToLower()), LineTwo = journey.Date.ToString("dd/MM/yyyy") }; this.Items.Add(item); } this.IsDataLoaded = true; }
/// <summary> /// Constructor for the Application object. /// </summary> public App() { // Global handler for uncaught exceptions. UnhandledException += Application_UnhandledException; // Standard Silverlight initialization InitializeComponent(); // Phone-specific initialization InitializePhoneApplication(); // Show graphics profiling information while debugging. if (System.Diagnostics.Debugger.IsAttached) { // Display the current frame rate counters Application.Current.Host.Settings.EnableFrameRateCounter = true; // Show the areas of the app that are being redrawn in each frame. //Application.Current.Host.Settings.EnableRedrawRegions = true; // Enable non-production analysis visualization mode, // which shows areas of a page that are handed off to GPU with a colored overlay. //Application.Current.Host.Settings.EnableCacheVisualization = true; // Disable the application idle detection by setting the UserIdleDetectionMode property of the // application's PhoneApplicationService object to Disabled. // Caution:- Use this under debug mode only. Application that disables user idle detection will continue to run // and consume battery power when the user is not using the phone. PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled; } string connectionString = "Data Source=isostore:/MileageTracker.sdf"; using (LinqDataContext dataContext = new LinqDataContext(connectionString)) { if (!dataContext.DatabaseExists()) { dataContext.CreateDatabase(); } } JourneyRepository repo = new JourneyRepository(); var readJourneys = repo.GetAll(); }