This project has moved. For the latest updates, please go here.

Foregin Key

May 5, 2011 at 11:22 PM
Edited May 5, 2011 at 11:22 PM

Is it possible to define a foregin key in cslagen fork if it has not been defined in the database? I want to create a business object that contains fields from more than one table and I think I need to select a foregin key when adding the property.

May 6, 2011 at 6:24 AM

Hi raffertydp,

1) No. This is a planned feature and is intended to solve the "views" problem. Since views have no FKs, there will be some way to add them just for CGF reference. There is no estimated date or release for this feature.

2) Foreign keys matter only for SProc generation. I suggest you let CGF generate the SProc the first time it runs. Then correct the SProc and disable SProc generation for that object. That way CGF won't overwrite your corrections.