public SelectList Categories()
        {
            SalesOrdersDatabase2Entities db = new SalesOrdersDatabase2Entities();

            var categories = from c in db.Categories
                             orderby c.CategoryDescription
                             select new
            {
                c.CategoryID,
                c.CategoryDescription
            };

            return(new SelectList(categories, "CategoryID", "CategoryDescription"));
        }