protected void Page_Load(object sender, EventArgs e)
 {
     NorthwindEntities context = new NorthwindEntities();
     var product = from p in context.Products
                   orderby p.ProductID descending
                   select p;
     this.ControlProdcutList.DataSource = product.ToList();
     this.ControlProdcutList.DataBind();
 }
        protected void Page_Load(object sender, EventArgs e)
        {
            using (var entities = new NorthwindEntities())
            {
                //var q = from r in entities..SalesByCategory1("Beverages", "1999")
                //        select r;

            }
        }