I have a database table in SQL Server and I need to configure a .NET application to use some of the data in this table, this data is used in a SOAP API call.

For example, the table has these columns

> 
> 
> > 
> > FirstName | LastName | EmailAddress
> > 
> > 
> > 
> 
> 
> 

The values in these columns need to map to certain fields in the API call. This configuration must be flexible, so I cannot just assign FirstName to apiobject.firstname, for example.

Is there a way to derive a string to a property of an object?

For example, for FirstName, would it be possible to resolve it to object.Firstname = value but not doing it like this

```
if(column == "FirstName")
{
    ApiObject.FirstName = columnValue
}

```

Rather I would want to do something like

```
ApiObject.[somehow-resolve-which-field] = columnValue

```

Does anyone know what I am on about?