In my project I have BizObA which consists of fields from TableA. I would also like it to include a field from TableB as it's related via an FK
If I were writing the SQL it would be something like:
SELECT A.Field, A.AnotherField, B.SomeField FROM TableA A INNER JOIN TableB B ON A.FK = B.PK
...but I'm not sure how this is achieved using the BO Mapper so that BizObA truly represents my business object and not just reflects a table structure
I guess I could have a separate BizObB to point at TableB and stitch them together but this seems like a bad idea
Once I have my BizObB I want to bind it to a grid using the BBS...