/// <summary> /// Constructor for the Application object. /// </summary> public App() { // Create the database if it does not exist. using (IrishSlangCtx db = new IrishSlangCtx(IrishSlangCtx.DBConnectionString)) { if (db.DatabaseExists() == false) { //Create the database db.CreateDatabase(); } } // 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. 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; // 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; } }
//private List<User> usersList = new List<User>(); public MainPage() { InitializeComponent(); // Connect to the database and instantiate data context. db = new IrishSlangCtx(IrishSlangCtx.DBConnectionString); // Data context and observable collection are children of the main page. this.DataContext = this; User u = new User(); u.name = "Paddy"; u.points = 0; UserTbl tdi = new UserTbl(); tdi.UserName = u.name; tdi.Points = u.points; db.UserTable.InsertOnSubmit(tdi); db.SubmitChanges(); }