//Faz o select do Horoscopo e carrega na lista void CarregarHoroscopo() { using (var db = new HoroscopoContext()) { var resultado = (from Horoscopo in db.signos select Horoscopo).ToList(); listaHoroscopo.ItemsSource = resultado; } }
private void WebClient_OpenReadCompleted(object sender, OpenReadCompletedEventArgs e) { try{ XDocument doc = XDocument.Load(e.Result); using (var db = new HoroscopoContext()) { if (db.signos.Count() == 0) { foreach (var item in doc.Descendants("signo")) { Horoscopo horoscopo = new Horoscopo(); horoscopo.Nome = (string)item.Element("nome"); horoscopo.Data = (string)item.Element("periodo"); horoscopo.Mensagem = (string)item.Element("msg"); horoscopo.Icone = (string)item.Element("icone"); db.signos.InsertOnSubmit(horoscopo); db.SubmitChanges(); } } else { db.SubmitChanges(); } } CarregarHoroscopo(); } catch{ MessageBox.Show("Para utilizar a aplicação pela primeira vez você precisa esta conectado a internet!"); } }
// Code to execute when the application is launching (eg, from Start) // This code will not execute when the application is reactivated private void Application_Launching(object sender, LaunchingEventArgs e) { using (var bd = new HoroscopoContext()) { if (!bd.DatabaseExists()) { bd.CreateDatabase(); } } }