StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Creating Read-Only BO on View

Creating Read-Only BO on View

Kevin Lingofelter — Sat, 15 Apr 2006 15:48:51 GMT

I have a complex view that joins 6 different tables in an Access database. I'd like to create a read-only BO to access the view results.

Is this possible?

Thanks!

RE: Creating Read-Only BO on View

Trent L. Taylor — Sat, 15 Apr 2006 15:48:51 GMT

I can relate on the sleep front :) ... I think this is the norm for a software developer.

You could use the Database Deployment Toolkit to create the structure that you want to use. Map your business object to that structure, then in your fill methods, simply refer to the view. This way the business object will be strong-typed to the view structure. I know this is more work, but it is an interim solution. Let me know if this will work for you.

RE: Creating Read-Only BO on View

Kevin Lingofelter — Sat, 15 Apr 2006 11:22:03 GMT

hehe...sleep is a long distant friend...:D

Until you get the mapper worked out, is there a work around for this? I am nearly finished here and would like to wrap this project up today if possible.

Thanks!

RE: Creating Read-Only BO on View

Trent L. Taylor — Fri, 14 Apr 2006 23:41:48 GMT

OK. I will take a look at it ;). Thanks. Just out of curiosity...do you ever sleep :)? You are a hard working man!

RE: Creating Read-Only BO on View

Kevin Lingofelter — Fri, 14 Apr 2006 23:25:31 GMT

Yeah...when using Access views are not displayed in the object mapper...(at least not here)

RE: Creating Read-Only BO on View

Trent L. Taylor — Fri, 14 Apr 2006 21:39:37 GMT

Yes, it is possible. A business object mapper has the ability to map to a view. We have done this a number of times in SQL Server. Does the Access view not show up in the BO Mapper for assignment to a business object? I will look at this also and see if I can reproduce the scenario.

It should be as simple as mapping a BO to a view instead of a table. If the view is not available for selection then let me know and we can go from there.