Community

Can we create read only business entities from a view?

We have a view setup to combine tables with foreign keys, etc.  The views show up in the schema explorer, but there is no place to add them to the business entities.

I imagined this should be possible via the "extensibility model" that CodeBreeze is built on...the idea being to create a custom provider that allows for the retrieval of views from the database.  But I have not been able to figure this route out yet...which leads me to another question...when will the CodeBreeze Modules Developer's Guide be published?!?

As of right now, CodeBreeze doesn't support Views I'm afraid.  For CodeBreeze licensed customers, you have available for download the source code for our SQL Provider, which you can enhance to support views if you'd like or use as a model to write another provider.

Miguel A. Castro
CodeBreeze Chief Architect - SteelBlue Solutions

I was able to modify my Schema.Navigator to include Views with the tables.  The problem I have now is that Views do not have primary keys associated with them.  If you add a table without primary keys (ID Fields), generating templates will crash the program.

I can manually go into the XML of the business entities and set the <IsID>false</IsID> to true, but then I have to add the entity again in the <IDFields> section and add the entire entity again.  It is a little too cumbersome. 

Would it be possible to only require that the IsID be set to true?

Or even better, would it be possible to change the maintain fields section so you can override the database properties for IsID or IsNull, etc.?

The isID can be changed using the property browser.   Let me see if I can add the IsID property to the "maintain fields" for the upcoming 1.1.  Note however, that this will still require you to go into that screen for each entity.  Using the property browser is easier I think.

Does this help?

That would be fantastic.

Do you need anyone to Beta test 1.1?

what do you like better?  Using the property browser (as you can now), or having that field in the maintenance screen?  Remember, the field-maintenance is on a per-entity so you would still need to enter that screen for each entity.

by the way, something else that might help you is that I just added two new extensibility points and one of them is at entity field creation time.  You can now write a CodeBreeze Module and tap into the point where a new entity field gets created from info from the database column.  You can intercept this now and "massage" whatever you need, before continuing the process.

miguel