How to Remove a data from database in ASP.NET Core Web API

In this article, I will tell you how to remove a record from the SQL Database table. For removing a record from the SQL table we will use the code-first entity framework. In my previous article, I already described how to do settings for writing ASP.NET Core Web API.  Follow the steps:

Step-1:

I already discuss the table structure in my previous article. Please follow that article for creating a table structure using the Code-first entity framework. Also, I discuss the migration of models and updating your database in the SQL server. 

Step-2:

In your ASP.NET Core application, Create a Controller Page "ProfileController" inside the Controller folder. Then write API for removing a single record from the "Profile" table.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using ProfileWebApi.Model;
using Microsoft.EntityFrameworkCore;

namespace ProfileWebApi.Controllers
{
    [Route("api/[controller]/[action]")]
    [ApiController]
    public class ProfileController : ControllerBase
    {
       public ApplicationDbContext DbContext;
        public ProfileController(ApplicationDbContext applicationDbContext)
        {
            DbContext = applicationDbContext;
        }
         [HttpDelete]
        public ActionResult<bool> RemoveProfileById(long id)
        {
            var res = DbContext.profiles.Where(a => a.ID == id).FirstOrDefault();
            DbContext.profiles.Remove(res);
            DbContext.SaveChanges();
            return true;
        }
    }
}

Step-3:

Then Build your project. After build successfully completed then click on start debugging. then edit your URL. Run your localhost URL with "/swagger/index.html ". For example:

http://localhost:24201/swagger/index.html

Step-4:

Then this page will open.

Step-5:

Click on "GET:​/api/Profile/RemoveProfileById". Then this page will open:

Click on the "Try It Out" button. Another button "Execute" will show then click on that button. 

Step-6: 

The result of your API will show. i.e. the data will remove and the output will show "true".

 

That's it. I hope you have found this article helpful. Do let me know via comments and likes.

CRUD Operation Reference Link:

1. Create

2. Retrieve All

3. Retrieve Single Data

4. Update

5. Delete