Hi

I'm trying to familiarise myself with N-Tier architecture.

I understand how business objects can be modelled on the tables in your db and that they can then be passed to the ui, in order to shield your ui from any data access that is required

However what do you do when you need to select data based on a sql query that only selects a few fields from a table.

Do you need to create a Business object for each query that you may generate or is there a better way?

many thanks

Mark Foster

Vb6 sp4
Sql server 7
win 2k