private void btnGuardar_Click(object sender, RoutedEventArgs e) { //Insertar BoyacaDataContext contexto = new BoyacaDataContext("isostore:/boyaca.mdb"); Items nuevo = new Items(); nuevo.Nombre = txtDescripcion.Text; nuevo.Precio = Convert.ToInt32(this.txtPrecio.Text); contexto.Items.InsertOnSubmit(nuevo); contexto.SubmitChanges(); //Consultar todos List<Items> todos = (from i in contexto.Items select i).ToList(); //Consultar uno y actualizar Items uno = (from i in contexto.Items where i.Id == 1 select i).SingleOrDefault(); uno.Nombre = this.txtDescripcion.Text; uno.Precio = Convert.ToInt32(this.txtPrecio.Text); contexto.SubmitChanges(); //Borrar Items otro = (from i in contexto.Items where i.Id == 1 select i).SingleOrDefault(); contexto.Items.DeleteOnSubmit(otro); contexto.SubmitChanges(); }
partial void UpdateItems(Items instance);
partial void DeleteItems(Items instance);
partial void InsertItems(Items instance);