>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?
I would not use option 1, option 2 and 3 are both OK. If this list will just be a list of names for the dropdown list then I would just use option 2 and return a dataset to bind to the combo. I do a similar thing where I display the names in a grid and I return from the stored procedure the lastName, FirstName as Fullname.
You could also add a property on the Entity that puts the two together and bind to that property rather than the others. Just don't let the property attempt to update since you may use that entity object elsewhere.
Tim
Timothy Bryan