I have the BO, the view in the mdb, but if I call the BO Mapper tool, only tables are displayed.
Is it possible?
Thanks,
Alex B.
Yes, you can. Each business object wraps a DataTable, and that DataTable can have all sorts of extra columns containing data. By the same token, you can also fill a business object with fewer fields than are mapped to the business object... just don't try to retrieve the data through one of the properties or you'll get an exception
Once you have the extra columns in the table, there are a few ways to retrieve the values. You can use the indexer property of the business object:
myBo["columnName"]
or you can use the current row:
myBo.CurrentRow["columnName"]
or you can create a property on the business object that wraps the current row's indexer. Simply copy one of the properties created by the BOMapper and change the names to protect the innocent.