StrataFrame Forum / StrataFrame Application Framework / Business Objects and Data Access (How do I?) / Can business object support more than one table? / Latest Posts

RE: Can business object support more than one table?

Ben Chase — Sat, 08 Jul 2006 23:28:27 GMT

As long as the view is an indexed view on SQL Server, allowing you to INSERT, UPDATE, and DELETE records from it, then what you have done is fine. You might even be able to define a primary key index on the view within SQL Server, allowing you to avoid having to change that code each some you rebuild the partial class within SQL Server.

RE: Can business object support more than one table?

Wang Tong Yin — Sat, 08 Jul 2006 12:23:16 GMT

I created a business object and mapped it to a view. When I tried to add record, an error occured. The error message as below

BusinessLayerException
An error occurred while saving an the data to the server.
DataLayerSavingException
Cannot create INSERT command because the updating DataTable does not contain columns for all PrimaryKeyFields.
DataLayerException
Cannot create INSERT command because the updating DataTable does not contain columns for all PrimaryKeyFields.

Source : MicroFour StrataFrame Business

Stack Trace:
at MicroFour.StrataFrame.Data.DataLayer.BuildInsertInfo(DataTable UpdatingTable, Boolean Transactional, String TransactionKey)

I manually assigned one of the fields from the view to be the primary key. I changed the code in Business Object, Private Shared _PrimaryKeyFields As String() = New String() {""} to Private Shared _PrimaryKeyFields As String() = New String() {"customerId"}.

After that I can add and update the records using that business object. Is this the correct way to do it? Will it cause any problem?

RE: Can business object support more than one table?

Ben Chase — Fri, 07 Jul 2006 09:11:05 GMT

The business objects will not prevent a user from being able to add new records, remove records or modify records if it is mapped to a view. The best way to prevent the user modifying the business object would be to handle either the BeforeDelete and BeforeAddNew events and set e.Cancel = True. Or you could handle the CheckSecurity event and deny the action.

RE: Can business object support more than one table?

Wang Tong Yin — Fri, 07 Jul 2006 04:59:46 GMT

After I create a view within the database that selects its fields from the separate tables, I will create a business object that will map to the columns of the view. Some fields of the view are table's primary key, index key or candidate key. Will the business object automatically trap the error when user try to add, edit or delete record? If the business object can trap the error, where can I know the error occur? Is the Business Object return any message or raise any event?

RE: Can business object support more than one table?

Ben Chase — Thu, 06 Jul 2006 08:51:58 GMT

I mean to create a view within the database that selects its fields from the separate tables. You can then create a business object that will map to the columns of the view. In answer to question #2, you cannot create a business object that can select fields from multiple business objects. You would need to create a wrapper by hand that held the separate business objects.

RE: Can business object support more than one table?

Wang Tong Yin — Thu, 06 Jul 2006 08:09:02 GMT

Do you mean:

1. create a view that selects the appropriate fields from the separate business objects, or

2. create a view that selects the appropriate fields from the separate tables?

Is it possible to create a view that selects the appropriate fields from the separate business objects?

RE: Can business object support more than one table?

Ben Chase — Wed, 05 Jul 2006 09:18:56 GMT

If you create a view that selects the appropriate fields from the separate business objects, you can map a business object to that view.

Can business object support more than one table?

Wang Tong Yin — Tue, 04 Jul 2006 07:35:06 GMT

I tried to use Business Object Mapper to map the table to a business object. I found that I only can select one table. Is it possible that business object can work with more than one tables? For example, a business object can select the fields from three tables.