private DatabaseHandler() { db = new DataContextBuilder(ConnectionString); }
/// <summary> /// Constructor for the Application object. /// </summary> public App() { // Global handler for uncaught exceptions. UnhandledException += Application_UnhandledException; // Standard XAML initialization InitializeComponent(); // Phone-specific initialization InitializePhoneApplication(); // Language display initialization InitializeLanguage(); // Show graphics profiling information while debugging. if (Debugger.IsAttached) { // Display the current frame rate counters 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; // Prevent the screen from turning off while under the debugger by disabling // the application's idle detection. // 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; } using (DataContextBuilder db = new DataContextBuilder(DataContextBuilder.DBConnectionString)) { if (db.DatabaseExists() == false) { db.CreateDatabase(); } } DatabaseHandler dbHandler = DatabaseHandler.DbHandler; DataContextBuilder dbTest = new DataContextBuilder("DataSource=isostore:/RUISviewDB.sdf"); Photos photo = new Photos() { p_Location = "pLocation", p_PhotoName = "testPhoto", p_ShowTime = 0, p_TimesShown = 10 }; dbHandler.Interact(0, null, photo); Maps map = new Maps(); map.m_MapLocation = "Testlocation"; map.m_MapName = "Testname"; Photos p2 = new Photos() { p_Location = "pLocation2", p_PhotoName = "testPhoto2", p_ShowTime = 2, p_TimesShown = 20 }; dbHandler.Interact(0, map, null); Maps m = dbTest.Maps.First(); string s = m.m_MapName; photo.m_MapId = m.m_MapId; dbHandler.Interact(0, null, p2); }