How to use Dynamic Set Property

Question

Hello I wish to update a particular field in DB by passing the field name and value. How can I make below work ? await _context. .Where(s=>s.Id == request.reportfield.Id).ExecuteUpdateAsync(b =>b.SetProperty( request.reportfield.Name request.reportfield.Value));

Mayooran Navamany · Answer

Here's how you can achieve this using reflection: Retrieve the Entity : Retrieve the entity you want to update from the database. Use Reflection to Set the Property : Use reflection to dynamically set the property value. Save Changes : Save the changes back to the database. Below is an example of how you can implement this: public async Task UpdateFieldAsync(string entityName int entityId string propertyName object propertyValue) { // Retrieve the entity var entity = await _context.Set(entityName).FindAsync(entityId); if (entity == null) { throw new Exception(Entity not found); } // Use reflection to set the property value var propertyInfo = entity.GetType().GetProperty(propertyName); if (propertyInfo == null) { throw new Exception(Property not found); } // Set the property value propertyInfo.SetValue(entity Convert.ChangeType(propertyValue propertyInfo.PropertyType) null); // Save the changes await _context.SaveChangesAsync(); } Here’s how you can call this method: await UpdateFieldAsync(YourEntityName request.reportfield.Id request.reportfield.Name request.reportfield.Value); Explanation Retrieve the Entity : var entity = await _context.Set(entityName).FindAsync(entityId); This line retrieves the entity from the database using its ID. Use Reflection to Set the Property : var propertyInfo = entity.GetType().GetProperty(propertyName); if (propertyInfo == null) { throw new Exception(Property not found); } propertyInfo.SetValue(entity Convert.ChangeType(propertyValue propertyInfo.PropertyType) null); This code uses reflection to find the property by name and set its value. The Convert.ChangeType method is used to ensure the value is of the correct type Save Changes : await _context.SaveChangesAsync(); This line saves the changes back to the database. Note Make sure the entity name matches the DbSet name in your DbContext. Handle exceptions and potential issues such as type mismatches null values and entity not found scenarios appropriately. This example assumes you are using ASP.NET Core with Entity Framework Core. If you are using a different version of Entity Framework the approach may vary slightly.