>Hi,
>
>this is MM.NET 3.6, but maybe is more general than that.
>
>I have an Agents table with an Agent Business Object. I need to display a dropdown list of Agents for the user to select. The Agents' names must be formatted "Surname, Firstname Middlename".
>
>Do I:
>
>1. Add in a formatted/calculated field to the table and then add this field to the BO?
>
>2. Add in a field called FullName to the stored procedures that the BO calls to get the data? Or
>
>3. Add in a calculated property on the BO?
Each of these methods should work. For me first two will be simpler to implement, but from the purist point of view I think you should go with #3 as formatting should not be done in the database.
If it's not broken, fix it until it is.
My Blog