I’m trying to create a batch update endpoint in my ASP.NET Core application. The method should take a collection of PatchObject items and apply the changes to the respective entities. However, I’m encountering a type conversion problem when setting the values to the properties.

Here is my code:

[HttpPost("PatchBatch")]
public virtual async Task<IActionResult> PatchBatch([FromBody] ICollection<PatchObject> patchRequests)
{
    if (patchRequests == null || !patchRequests.Any())
    {
        return StatusCode(500, "Cannot complete operation, collection parameter is null or empty");
    }

    var errors = new List<string>();

    foreach (var patchRequest in patchRequests)
    {
        try
        {
            var currentEntity = await _service.GetByIdAsync(patchRequest.Id).SingleOrDefaultAsync();
            
            if (currentEntity == null)
            {
                errors.Add($"Entity with id {patchRequest.Id} not found.");
                continue;
            }

            var patch = new Delta<T>();
            foreach (var change in patchRequest.Changes)
            {
                try
                {
                    if (!patch.TrySetPropertyValue(change.Key, change.Value))
                    {
                        errors.Add($"The value {change.Value} cannot be set to property {change.Key}");
                        continue;
                    }
                }
                catch (ArgumentException)
                {
                    errors.Add($"Property {change.Key} does not exist on the entity.");
                    continue;
                }
            }

            patch.Patch(currentEntity);
            await _service.UpdateAsync(currentEntity);
        }
        catch (Exception ex)
        {
            errors.add($"An error occurred while updating the entity with id: {patchRequest.Id}. Exception: {ex.Message}");
        }
    }

    if (errors.Any())
    {
        return BadRequest(string.Join("n", errors));
    }

    return Ok("Batch update successful.");
}

public class PatchObject
{
    public int Id { get; set; }
    public Dictionary<string, object> Changes { get; set; }
}

The issue arises when patch.TrySetPropertyValue(change.Key, change.Value) attempts to set the property value. It fails due to type conversion problems, resulting in errors being added to the error list. Here are the types of errors I’m encountering:

The value cannot be set to the property

**Questions:

How can I handle type conversion properly in this scenario?
What is the best way to ensure that the properties exist on the entity and are correctly typed?
Are there more efficient methods for performing batch updates that avoid these issues?**

i tried converting like this, but i am facing conversion errors.

PropertyInfo propertyInfo = typeof(T).GetProperty(change.Key.ToString());
        if (propertyInfo == null)
        {
            errors.Add($"Property {change.Key} does not exist on T.");
            continue;
        }

        Type propertyType = propertyInfo.PropertyType;
        object convertedValue = ConvertToType(change.Value, propertyType);

        if (!patch.TrySetPropertyValue(change.Key, convertedValue))
        {
            errors.Add($"The value {change.Value} cannot be converted to {propertyType}");
            continue;
        }