I am working on an ASP.NET Core Web API project and need to update multiple columns for multiple rows within a single HTTP PATCH request. I am familiar with using JsonPatchDocument to update a single object, but I am unsure how to extend this to handle updating multiple objects in the same table at once.

Here is what I am trying to achieve:

I have a table with multiple rows that need to be updated.
Each row can have multiple columns that need to be changed.
I want to send a single PATCH request to update these rows and columns.

public class MyEntity
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Code { get; set; }
    public DateTime CountDate { get; set; }
}

[
  {
    "id": 4,
    "changes": {
        "Name": "Test",
        "Code": "ICO3",
        "CountDate": "2024-06-25T11:00:00"
    }
  },
  {
    "id": 6,
    "changes": {
        "Name": "Test",
        "Code": "ICO9",
        "CountDate": "2024-06-25T11:00:00"
    }
  }
]

[HttpPatch("{id}")]
public IActionResult PatchEntity(int id, [FromBody] JsonPatchDocument<MyEntity> patchDoc)
{
    if (patchDoc == null)
    {
        return BadRequest();
    }

    var entity = _context.MyEntities.Find(id);
    if (entity == null)
    {
        return NotFound();
    }

    patchDoc.ApplyTo(entity, ModelState);

    if (!ModelState.IsValid)
    {
        return BadRequest(ModelState);
    }

    _context.SaveChanges();

    return NoContent();
}

Question:

How can I extend this approach to handle a single PATCH request that updates multiple rows and multiple columns in the same table? Ideally, I would like to ensure that all updates are applied in a single transaction.

Any advice or examples on how to achieve this would be greatly appreciated!