public void GetSeries()
 {
     ObservableCollection<MySerie> a = new ObservableCollection<MySerie>();
     using(MySerieDataContext SeriesDB=new MySerieDataContext(MySerieDataContext.DBConnectionString))
     {
         var query = from c in SeriesDB.MySeries select c;
         MySeries = new ObservableCollection<MySerie>(query);
     }
 }
 private void btnOk_Click(object sender, RoutedEventArgs e)
 {
     using(MySerieDataContext context=new MySerieDataContext(MySerieDataContext.DBConnectionString))
     {
         MySerie serie = new MySerie();
         serie.title = txtTitle.Text;
         context.MySeries.InsertOnSubmit(serie);
         context.SubmitChanges();
     }
     NavigationService.Navigate(new Uri("/PivotPage1.xaml",UriKind.Relative));
 }
 public void Delete(MySerie s)
 {
     MySeries.Remove(s);
     using (MySerieDataContext SeriesDB = new MySerieDataContext(MySerieDataContext.DBConnectionString))
     {
         IQueryable<MySerie> seriequery = from c in SeriesDB.MySeries where c.title == s.title select c;
         MySerie ds = seriequery.FirstOrDefault();
         SeriesDB.MySeries.DeleteOnSubmit(ds);
         SeriesDB.SubmitChanges();
     }
 }
        /// <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.
                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;
            }

            // Create the database if it does not exist.
            using (MySerieDataContext db = new MySerieDataContext(MySerieDataContext.DBConnectionString))
            {
                if (db.DatabaseExists() == false)
                {
                    //Create the database
                    db.CreateDatabase();
                }
            }
        }