Advantage Knowledgebase Item
Tuesday, May 15, 2012
Advantage .NET Data Provider
Using the .Net Entity Framework with Database First does not Retrieve the RI Rule Associations
When using the .Net Entity Framework with the Database First approach, the generated model does not contain any information regarding the Referential Integrity (RI) rule associations.
The Entity Framework uses information returned from system tables when building the Entity Model. Depending on the user authenticating, the data returned by the system tables may differ.
Ensure the user used to connect to Advantage in order to generate the model has permissions to alter the table. Once the model is generated, the user can be changed to a user with less permissions.
As an alternative the associations can be manually added to the Entity Model. They will not be removed when the model is refreshed in the future.
Was This Item Helpful?