There are 187 columns comprising:
- Guid: 1
- bool: 11
- decimal: 77
- DateOnly: 32
- int: 5
- string: 61
Previously, I did some testing by commenting out properties of different types in the ResponseDto (e.g. all DateOnly), but I saw no significant performance differences amongst the types.
Simply, reducing the number of properties improved the AutoQuery “mapping” of the database data to the C# data.