How to Update a data into database in ASP.NET Core Web API

  

 In this article, I will tell you how to update a record in the SQL Database table. For updating a record in 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 updating a single record in 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;
        }
          [HttpPut]
        public ActionResult<Profile> UpdateProfile([FromForm]Profile profile)
        {
            DbContext.SaveChanges();
            return profile;
        }
    }
}

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 PUT​/api​/Profile​/UpdateProfile Then this page will open:

Click on the "Try It Out" button. After filling up these details "Execute" button will show then click on that button. 

Step-6: 

The result of your API will show. i.e. the data will update in the SQL server and the output will show like below.

 

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