Navigation properties not generated from Postgresql db

[etienne.desgagne]

Hi,
When generating model from my postgresql database, all tables are generated but not the navigation properties. Also, all not nullable fields are generated as entity keys.

Is it a bug or a bad configuration?

Thanks

Etienne

[etienne.desgagne]

It seems that some privileges are missing in database... It strange that no error are raised or that tables can be read from database but not the relations...

[MariiaI]

We have reproduced the issues with missing navigation properties and setting up the not nullable fields as entity keys. It is indeed associated with user privileges in PostgreSQL. We will investigate it and inform you about the results as soon as possible.

As for the issue with missing tables in the wizard when creating ADO.NET Entity Data Model (you wrote about it via the mail), obtaining the metadata in ADO.NET Entity Data Model Wizard is implemented mainly through the 'information_schema', while in Entity Developer it is implemented with 'pg_catalog'. Thus, there can be differences in their behavior.
However, this issue also seems to be related to user privileges. We will investigate this behavior and inform you about the results as soon as possible.

[etienne.desgagne]

After some investigation it seems that the database user I was using to access dabatase from Entity Framework was missing the INHERIT attribute. Without this attribute the user was not inheriting from his group privileges that give him access to database objects...

Everything is working well now.

Thanks for your support

Etienne

[MariiaI]

The bug with incorrect model creating and wrong generation of the associations and entity keys when working for users with limited privileges is fixed. The fix is available in the new build of dotConnect for PostgreSQL 6.2.114. It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information please refer to http://forums.devart.com/viewtopic.php?f=3&t=25196

[Shalex]

The bug with retrieving metadata information about primary keys in ADO.NET Entity Data Model/LightSwitch when using database user with limited privileges is fixed in the current (6.2.122) build of dotConnect for PostgreSQL. Please try it and notify us about the results.