// GET api/<controller>/5
        public Course Get(int id)
        {
            //connect
            using (DefaultConnectionEF db = new DefaultConnectionEF())
            {
                db.Configuration.ProxyCreationEnabled = false;

                Course objC = (from c in db.Courses
                          where c.CourseID == id
                          select c).FirstOrDefault();

                return objC;

            }

            //return "value";
        }
        // GET api/<controller>
        public IEnumerable<Course> Get()
        {
            //connect
            using (DefaultConnectionEF db = new DefaultConnectionEF())
            {
                //make sure json parsing works with the ef object
                db.Configuration.ProxyCreationEnabled = false;

                //query
                var objC = from c in db.Courses
                           orderby c.Title
                           select c;

                return objC.ToList();
            }

            //return new string[] { "value1", "value2" };
        }