I am modeling my app based on your methodology where we have the 3 layers.
Say that I have a Visit table, a dal visit, a bo visit, and a bll visit class.
My table looks like:
Visit (visitid, visitdate, visittime, visitStatusCode, visitCategoryCode, etc)
My bo.Visit has the same properties as the visit table above.
The dilemma is this: on the ui, i need to display a grid showing all the visits but, instead of showing the internal codes for visits status and visit category. I want to display the descriptions: visit status description and category description.
In the past, i added cached datasets and an item template using a function to translate the code to the description on the row bound event.
This seems expensive and also breaks all the n-tier philosophy.
I could also create a FAT object with all the properties I would consume on the UI by getting all the properties in the dal into my business object. My concern is that for each visit that I load, I will have to make 2 more calls to get the visit status and category descriptions.
Or, use a view or proc with all the properties i need and on the dal.getAll() populate the FAT object?
happy new year