/// <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; } // Create the database if it does not exist. using (EasyListDataContext db = new EasyListDataContext(EasyListDataContext.DBConnectionString)) { if (!db.DatabaseExists()) { // Create the database db.CreateDatabase(); var updater = db.CreateDatabaseSchemaUpdater(); updater.DatabaseSchemaVersion = 1; updater.Execute(); // Save categories to the database. db.SubmitChanges(); } else { //var updater = db.CreateDatabaseSchemaUpdater(); //if (updater.DatabaseSchemaVersion < 2) //{ // // make some updates // updater.AddTable<Settings>(); // updater.AddColumn<>("CreatedDate"); // updater.DatabaseSchemaVersion = 2; // updater.Execute(); //} } } }
// Constructor public MainPage() { this.InitializeComponent(); // Set event listener for XAML Control with Name="Panorama". this.Panorama.SelectionChanged += this.Panorama_SelectionChanged; // Connect to the database and instantiate data context. this.easyListDb = new EasyListDataContext(EasyListDataContext.DBConnectionString); // Data context and observable collection are children of the main page. this.DataContext = this; this.Loaded += new RoutedEventHandler(MainPage_Loaded); }
/// <summary> /// Creates and adds a few ItemViewModel objects into the Items collection. /// </summary> public void LoadData(EasyListDataContext db) { this.Settings = new ObservableCollection<SettingsTable>(from SettingsTable st in db.Settings select st); this.Lists = new ObservableCollection<ListsTable>(from ListsTable lt in db.Lists select lt); this.ListItems = new ObservableCollection<ListItemsTable>(from ListItemsTable lit in db.ListItems select lit); // Sample data; replace with real data //this.Items.Add(new ItemViewModel() { LineOne = "runtime one", LineTwo = "Maecenas praesent accumsan bibendum", LineThree = "Facilisi faucibus habitant inceptos interdum lobortis nascetur pharetra placerat pulvinar sagittis senectus sociosqu" }); //this.Items.Add(new ItemViewModel() { LineOne = "runtime two", LineTwo = "Dictumst eleifend facilisi faucibus", LineThree = "Suscipit torquent ultrices vehicula volutpat maecenas praesent accumsan bibendum dictumst eleifend facilisi faucibus" }); this.IsDataLoaded = true; }