public static CustomerModel Get(string name)
        {
            var db = new NorthwindEntities();
            var customer = db.Customers.Where(c => c.CompanyName == name).Select(c => new CustomerModel
            {
                Name = c.CompanyName,
                ContactName = c.ContactName,
                ContactTitle = c.ContactTitle,
                Address = c.Address,
                City = c.City,
                Country = c.Country,
                Phone = c.Phone,
                Fax = c.Fax
            })
            .FirstOrDefault();

            return customer;
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            var db = new NorthwindEntities();
            customers = db.Customers.Select(c => new CustomerModel
            {
                Name = c.CompanyName,
                ContactName = c.ContactName,
                ContactTitle = c.ContactTitle,
                Address = c.Address,
                City = c.City,
                Country = c.Country,
                Phone = c.Phone,
                Fax = c.Fax
            })
            .ToList();

            this.GridViewCustomers.DataSource = customers;
            this.DataBind();
        }