private void Button_Click_1(object sender, RoutedEventArgs e) { var db = new AdventureWorksEntities(); var query = from p in db.Products select p.ProductCategory; var results = query.ToList(); dg.ItemsSource = results; }
private void Button_Click_2(object sender, RoutedEventArgs e) { var db = new AdventureWorksEntities(); var query = from p in db.Products orderby p.ListPrice descending select p; var results = query.Take(20).ToList(); dg.ItemsSource = results; }
private void Button_Click_4(object sender, RoutedEventArgs e) { var db = new AdventureWorksEntities(); var nieuwe = new ProductCategory(); nieuwe.Name = "The game"; nieuwe.ModifiedDate = DateTime.Now; nieuwe.rowguid = Guid.NewGuid(); db.ProductCategories.Add(nieuwe); //stuur de wijsingingen naar de DB toe db.SaveChanges(); }
private void Button_Click_3(object sender, RoutedEventArgs e) { dg.ItemsSource = null; var db = new AdventureWorksEntities(); var query = from p in db.Products select new { p.ProductID, p.Name, p.Color, p.ListPrice, CategoryName = p.ProductCategory.Name }; MessageBox.Show(query.ToString()); var results = query.ToList(); dg.ItemsSource = results; }