示例#1
0
        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            var db    = new AdventureWorksEntities();
            var query = from c in db.ProductCategories
                        select c;

            var results = query.ToList();

            dg.ItemsSource = results;
        }
示例#2
0
        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.ToList();

            dg.ItemsSource = results;
        }
示例#3
0
        private void Button_Click_4(object sender, RoutedEventArgs e)
        {
            var db = new AdventureWorksEntities();

            var nieuwe = new ProductCategory();

            nieuwe.Name         = "This is where the fun begins";
            nieuwe.ModifiedDate = new DateTime(1889, 4, 20);
            nieuwe.rowguid      = Guid.NewGuid();

            db.ProductCategories.Add(nieuwe);

            db.SaveChanges();
        }
示例#4
0
        private void Button_Click_3(object sender, RoutedEventArgs e)
        {
            var db    = new AdventureWorksEntities();
            var query = from p in db.Products
                        //   where p.Color.Contains("R")
                        select new
            {
                p.ProductID,
                p.Name,
                p.Color,
                p.ListPrice
            };
            //  MessageBox.Show(query.ToString());
            var results = query.ToList();

            dg.ItemsSource = results;
        }