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 = false; // 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; } // Specify the local database connection string. string DBConnectionString = "Data Source=isostore:/ViewNote.sdf"; // Create the database if it does not exist. using ( VNoteDataContext db = new VNoteDataContext(DBConnectionString) ) { if ( db.DatabaseExists() == false ) { // Create the local database. db.CreateDatabase(); System.Diagnostics.Debug.WriteLine("After creating db: " + DBConnectionString); // Prepopulate the categories. db.Categories.InsertOnSubmit(new VNoteCategory { Name = "Memo" }); db.Categories.InsertOnSubmit(new VNoteCategory { Name = "Travel" }); db.Categories.InsertOnSubmit(new VNoteCategory { Name = "Fun" }); // Save categories to the database. db.SubmitChanges(); } } // Create the ViewModel object. viewModel = new ViewNoteViewModel(DBConnectionString); // Query the local database and load observable collections. viewModel.LoadCollectionsFromDatabase(); }
// Class constructor creating the data context object. public ViewNoteViewModel(string viewNoteDBConnectionString) { viewNoteDB = new VNoteDataContext(viewNoteDBConnectionString); }