Problem: Manyatimes, we need to return data from different tables in the database to the UI (for example, search results) whose schema wouldnt match with any of the domain objects.
In this case, one option is to transfer the data using the datasets/datatables feature provided by .Net.
The other option I could think of is to create business (DTO?) objects to just pass on the data from the DB to the UI.
I prefer the second approach. However, I need suggestions on how do I implement it? Will this DTO contain a reference of all the domain objects involved or Can I just include only the desired columns?
Previous Topic
