How to implement DELETE Method in WEB API

How to implement DELETE Method in WEB API

In this article, I am going to discuss how to implement DELETE Method in WEB API with an example. Please Read our last article where we discussed how to implement PUT Method in ASP.NET WEB API before proceeding to this article as we are going to use the same example.

Implementing the DELETE method in Web API:

Delete allows us to delete an item. 

We want to delete a specified employee from the Employees database table. To achieve this Include the following Delete method in EmployeesController.

public class EmployeesController : ApiController
{
    public void Delete(int id)
    {
        using (EmployeeDBContext dbContext = new EmployeeDBContext())
        {
            dbContext.Employees.Remove(dbContext.Employees.FirstOrDefault(e => e.ID == id));
            dbContext.SaveChanges();
        }
    }
}

At this point build the solution, run the application and fire up the Fiddler and issue a Delete request.

  1. Set the HTTP verb to DELETE
  2. Content-Type: application/json. This tells that we are sending JSON formatted data to the server
  3. Finally, click on the execute button as shown below

DELETE Method in WEB API

When we click on the Execute Button, it will give us the below response

DELETE Method in WEB API

This works fine and deletes the employee record from the database as expected. The problem here is that since the return type of the Delete method is void, we get status code 204 No Content. When the Deletion is successful, we want to return status code 200 OK indicating that the deletion is successful.

Also when we try to delete an employee whose Id does not exist we get back HTTP status code 500 Internal Server Error. We get status code 500, because of a NULL reference exception. If an item is not found, then we need to return status code 404 Not Found.

To fix both of these issues modify the code in the Delete method as shown below.

public class EmployeesController : ApiController
{
    public HttpResponseMessage Delete(int id)
    {
        try
        {
            using (EmployeeDBContext dbContext = new EmployeeDBContext())
            {
                var entity = dbContext.Employees.FirstOrDefault(e => e.ID == id);
                if (entity == null)
                {
                    return Request.CreateErrorResponse(HttpStatusCode.NotFound,
                        "Employee with Id = " + id.ToString() + " not found to delete");
                }
                else
                {
                    dbContext.Employees.Remove(entity);
                    dbContext.SaveChanges();
                    return Request.CreateResponse(HttpStatusCode.OK);
                }
            }
        }
        catch (Exception ex)
        {
            return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex);
        }
    }
}

At this point, issue another DELETE request from the Fiddler. Notice in the response header we have status code 200 OK. Also, when we try to delete an employee whose id does not exist, we get status code 404 Not Found instead of 500 Internal Server Error 

In the next article, I will discuss Custom Method Names in ASP.NET WEB API.

SUMMARY

In this article, I try to explain Implementing the DELETE Method in WEB API step by step with a simple example. I hope this article will help you with your need. I would like to have your feedback. Please post your feedback, question, or comments about this article.

No HTML was returned.

 

Leave a Reply

Your email address will not be published. Required fields are marked *