How to handle concurrent updates in C# dotnet webapi without Entity Framework?

Question

Aryan Kumar · Answer

There are a several ways to handle concurrent updates in C# .NET Web API without Entity Framework. Here are some of the most common methods:

Use optimistic concurrency: This method uses the version number to track changes to the record. When the user updates the record, the version number is incremented. When another user tries to update the same record, the server checks the version number. If the version number has changed, the second user's update will be rejected.

Use pessimistic concurrency: This method locks the record while it is being updated. This prevents other users from updating the record at the same time.

Use a database transaction: This method includes all of the updates to a record in a database transaction. If any of the update fails, the entire transaction will be rolled back.

Use a distributed lock: This method uses a third-party service to obtain profile key. This prevents other users from updating the record until the lock is released.

The best method to use will depend on your specific application requirements.

Here is an example of using optimistic concurrency in a C# .NET Web API without Entity Framework:

C#

public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Version { get; set; }
}

public class PersonController
{
    public async Task<IActionResult> UpdatePerson(int id, Person person)
    {
        // Get the person from the database.
        var existingPerson = await _context.People.FindAsync(id);

        // Check the version number.
        if (existingPerson.Version != person.Version)
        {
            // The record has been updated by another user.
            throw new BadRequestException("The record has been updated by another user.");
        }

        // Update the record in the database.
        _context.People.Update(person);
        await _context.SaveChangesAsync();

        // Return the updated person.
        return Ok(person);
    }
}

In this example, we first get a person from the database using the FindAsync() method. Then, we check the version number of the directory. If the version number has changed, we will raise an exception. Otherwise, we update the record in the database and return the person who updated.

forum

How to handle concurrent updates in C# dotnet webapi without Entity Framework?

Can you answer this question?

1 Answers