StrataFrame Forum / StrataFrame Application Framework / Business Objects and Data Access (How do I?) / Business Object Mapper / Latest Posts

RE: Business Object Mapper

Farouk Yew Abdullah — Mon, 17 Jul 2006 19:31:39 GMT

SQL Server views show up in the BO Mapper. I will look into the VFP views and see why they do not appear. As for the other, refer to my last post and watch the video on the business objects that use XML as a data source. This is probably not the solution you are looking for, but it will give you some ideas on how you might go after this problem.

Hi Trent,

I have watched the video and 1 question I am not clear how does the XML tie the backend database? Does it auto save intot backend whether it is SQLServer of VFP backend?

Is there going be a release this July and on schedule?

Regards

RE: Business Object Mapper

Trent L. Taylor — Mon, 17 Jul 2006 13:24:05 GMT

RE: Business Object Mapper

Farouk Yew Abdullah — Mon, 17 Jul 2006 13:21:38 GMT

Hi Trent,

To add on to my previous reply, can u give an example how u would do the following:

"then you will need to either use a view of some sort or create two business objects. You could manually create custom properties that pull from the proper structure depending upon the data source."

Regards

RE: Business Object Mapper

Trent L. Taylor — Mon, 17 Jul 2006 13:20:49 GMT

In these scenarios we use the Database Deployment Toolkit to create our structures, map to the DDT item, but never actually deploy the structure. It is strictly for mapping the BOs. I will look at the BO Mapper and see if there is something we can do to access the views, but in the mean time you may want to look at the video and sample about mapping to XML structures. This may give you an idea or two.

http://forum.strataframe.net/Topic771-17-1.aspx

RE: Business Object Mapper

Farouk Yew Abdullah — Mon, 17 Jul 2006 13:17:35 GMT

Hi Trent,

Are u suggesting to use custom fields? We have tried using OLE Provider but the object mapper does not show/allow views to be selected.

May I know how does the object mapper map the biz objects+fields to the table+fields? Is it stored in table or XML?

Regards

RE: Business Object Mapper

Trent L. Taylor — Mon, 17 Jul 2006 13:10:29 GMT

If your structures are going to be physically different, then you will need to either use a view of some sort or create two business objects. You could manually create custom properties that pull from the proper structure depending upon the data source. But this would require much more work.

Business Object Mapper

Farouk Yew Abdullah — Mon, 17 Jul 2006 12:47:29 GMT

Hi,

I have a following situation. I need to create a set of business objects which is mapped to either a VFP tables or SQL tables. However both set may have slightly different naming in the fields but content wise are the same. Can I achieve this?

Regards.