public Sport Get(int id)
 {
     using (SportContextDBEntities entities = new SportContextDBEntities())
     {
         return(entities.Sports.FirstOrDefault(e => e.SportID == id));
     }
 }
        public HttpResponseMessage Put(int id, Sport sport)
        {
            try
            {
                using (SportContextDBEntities entities = new SportContextDBEntities())
                {
                    var entity = entities.Sports.FirstOrDefault(e => e.SportID == id);
                    if (entity == null)
                    {
                        return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
                                                           "Sport with Id " + id.ToString() + " not found to update"));
                    }
                    else
                    {
                        entity.Description = sport.Description;

                        entities.SaveChanges();

                        return(Request.CreateResponse(HttpStatusCode.OK, entity));
                    }
                }
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
            }
        }
 public IEnumerable <Sport> Get()
 {
     using (SportContextDBEntities entities = new SportContextDBEntities())
     {
         return(entities.Sports.ToList());
     }
 }