Hi,
I am using dynamic list and data reader to fetch the data from multiple tables (using self servicing). I am using this in all my BL methods to get the custom business object filled from the data reader (loops throuh this and assign field values) manually.
When I read about the usage of projection to datareader to custom class, I tried in one of my simple methods with 5 fields. But the performance is worst than manullay adding to the collection objects.
The below line takes very long time to execute:
dao.GetAsProjection(valueProjectors, projector, Nothing, fields, filter, Nothing, 0, sort, True)
I have just one filter in the filter collection. Is there optimization available in the latest version?