We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

Http Status Code 500 thrown when calling a controller action RSS

4 replies

Last post Apr 15, 2015 09:42 PM by Krunal Parekh

‹ Previous Thread|Next Thread ›

Shortcuts

Related Links

mapussah

Member

14 Points

18 Posts

Http Status Code 500 thrown when calling a controller action

Apr 07, 2015 03:24 PM|mapussah|LINK

Hi guys,

I am fairly new at MVC. Currently, I am trying to figure out how ASP.Net Web API 2 works. I have created 2 model classes and implemented the controllers using EF. I have also hosted the API on Azure. The problem when I test the API locally using IIS Express, I have no issues; everything works as expected, but when I hosted it and try to call action method from the controllers, I get an HTTP 500 error. Below is the code for my models and the controllers.

Student model

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace ApiDemo.Models
{
    public class Student
    {
        [Key, DatabaseGenerated(DatabaseGeneratedOption.None)]
        public string Id { get; set; }

        public string FirstName { get; set; }

        public string LastName { get; set; }

        public string Major { get; set; }

        public string Minor { get; set; }
    }
}

Enrollment model

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace ApiDemo.Models
{
    public class Enrollment
    {
        [Key]
        public int Id { get; set; }

        public string Course { get; set; }

        public string Section { get; set; }

        public string Professor { get; set; }

        [ForeignKey("Student")]
        public string StudentId { get; set; }

        public virtual Student Student { get; set; }
    }
}

StudentsController

using ApiDemo.Models;
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
using System.Linq;
using System.Net;
using System.Web.Http;
using System.Web.Http.Description;

namespace ApiDemo.Controllers
{
    public class StudentsController : ApiController
    {
        private StudentDbContext db = new StudentDbContext();

        // GET: api/Students
        public IQueryable<Student> GetStudents()
        {
            return db.Students;
        }

        // GET: api/Students/5
        [ResponseType(typeof(Student))]
        public IHttpActionResult GetStudent(string id)
        {
            Student student = db.Students.Find(id);
            if (student == null)
            {
                return NotFound();
            }

            return Ok(student);
        }

        // PUT: api/Students/5
        [ResponseType(typeof(void))]
        public IHttpActionResult PutStudent(string id, Student student)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            if (id != student.Id)
            {
                return BadRequest();
            }

            db.Entry(student).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!StudentExists(id))
                {
                    return NotFound();
                }
                else
                {
                    throw;
                }
            }

            return StatusCode(HttpStatusCode.NoContent);
        }

        // POST: api/Students
        [ResponseType(typeof(Student))]
        public IHttpActionResult PostStudent(Student student)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            db.Students.Add(student);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (StudentExists(student.Id))
                {
                    return Conflict();
                }
                else
                {
                    throw;
                }
            }

            return CreatedAtRoute("DefaultApi", new { id = student.Id }, student);
        }

        // DELETE: api/Students/5
        [ResponseType(typeof(Student))]
        public IHttpActionResult DeleteStudent(string id)
        {
            Student student = db.Students.Find(id);
            if (student == null)
            {
                return NotFound();
            }

            db.Students.Remove(student);
            db.SaveChanges();

            return Ok(student);
        }

        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                db.Dispose();
            }
            base.Dispose(disposing);
        }

        private bool StudentExists(string id)
        {
            return db.Students.Count(e => e.Id == id) > 0;
        }
    }
}

EnrollmentsController

using ApiDemo.Models;
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
using System.Linq;
using System.Net;
using System.Web.Http;
using System.Web.Http.Description;

namespace ApiDemo.Controllers
{
    public class EnrollmentsController : ApiController
    {
        private StudentDbContext db = new StudentDbContext();

        // GET: api/Enrollments
        public IQueryable<Enrollment> GetEnrollments()
        {
            return db.Enrollments;
        }

        //public IQueryable<Enrollment> GetEnrollments(string studentId)
        //{
        //    return db.Enrollments.Where(e => e.StudentId == studentId);
        //}

        // GET: api/Enrollments/5
        [ResponseType(typeof(Enrollment))]
        public IHttpActionResult GetEnrollment(int id)
        {
            Enrollment enrollment = db.Enrollments.Find(id);
            if (enrollment == null)
            {
                return NotFound();
            }

            return Ok(enrollment);
        }

        // PUT: api/Enrollments/5
        [ResponseType(typeof(void))]
        public IHttpActionResult PutEnrollment(int id, Enrollment enrollment)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            if (id != enrollment.Id)
            {
                return BadRequest();
            }

            db.Entry(enrollment).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!EnrollmentExists(id))
                {
                    return NotFound();
                }
                else
                {
                    throw;
                }
            }

            return StatusCode(HttpStatusCode.NoContent);
        }

        // POST: api/Enrollments
        [ResponseType(typeof(Enrollment))]
        public IHttpActionResult PostEnrollment(Enrollment enrollment)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            db.Enrollments.Add(enrollment);
            db.SaveChanges();

            return CreatedAtRoute("DefaultApi", new { id = enrollment.Id }, enrollment);
        }

        // DELETE: api/Enrollments/5
        [ResponseType(typeof(Enrollment))]
        public IHttpActionResult DeleteEnrollment(int id)
        {
            Enrollment enrollment = db.Enrollments.Find(id);
            if (enrollment == null)
            {
                return NotFound();
            }

            db.Enrollments.Remove(enrollment);
            db.SaveChanges();

            return Ok(enrollment);
        }

        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                db.Dispose();
            }
            base.Dispose(disposing);
        }

        private bool EnrollmentExists(int id)
        {
            return db.Enrollments.Count(e => e.Id == id) > 0;
        }
    }
}

DbContext

using System.Data.Entity;

namespace ApiDemo.Models
{
    public class StudentDbContext : DbContext
    {
        public DbSet<Student> Students { get; set; }
        public DbSet<Enrollment> Enrollments { get; set; }
    }
}

Locally, when I execute .api/Students, I get the expected result (this is assuming that locahost can be anything. But my model is hosted at http://apidemo.azurewebsites.net. So when I execute something like http://apidemo.azurewebsites.net/api/Enrollments, I get a 500 error. Can anyone please help me out?

Thanks, you are the best!

- Reply
damienBod
Contributor

2487 Points

687 Posts

MVP

Re: Http Status Code 500 thrown when calling a controller action

Apr 12, 2015 05:17 AM|damienBod|LINK

Could you post the 500 Error message?

Maybe you just need to configure your web.config to allow PUT, DELETE etc.

greetings Damien

http://damienbod.com
- Reply
Krunal Parek...
All-Star

15252 Points

2074 Posts

Re: Http Status Code 500 thrown when calling a controller action

Apr 14, 2015 03:24 AM|Krunal Parekh|LINK

Hello mapussah,

Can you please provide more info on what kind of error you are getting from the server?

With Regards,

Krunal Parekh

Krunal

MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.
- Reply
mapussah
Member

14 Points

18 Posts

Re: Http Status Code 500 thrown when calling a controller action

Apr 15, 2015 07:38 AM|mapussah|LINK

The server error that comes back says "Internal Server Error" with status 500.
- Reply
Krunal Parek...
All-Star

15252 Points

2074 Posts

Re: Http Status Code 500 thrown when calling a controller action

Apr 15, 2015 09:42 PM|Krunal Parekh|LINK

Hello mapussah,

1. Could the issue be with some configuration setting on Azure? Does the same thing happen when you publish to local IIS or does it work fine? Can you please Identify this.

2. If this really is issue related with Azure you could try posting your question on azure forum. you are likely to get more response from there.

http://azure.microsoft.com/en-us/support/forums/

With Regards,

Krunal Parekh

Krunal

MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.

‹ Previous Thread|Next Thread ›

Http Status Code 500 thrown when calling a controller action RSS

4 replies

Shortcuts

Related Links

Http Status Code 500 thrown when calling a controller action

Re: Http Status Code 500 thrown when calling a controller action

Re: Http Status Code 500 thrown when calling a controller action

Re: Http Status Code 500 thrown when calling a controller action

Re: Http Status Code 500 thrown when calling a controller action