Devart Forums

Dear Community,

edit: Using Vs2008 SP1, latest dotConnect for Postgresql, latest Postgresql DB (8.4.4) running on Win7

I have got serious issues with dotconnect for Postgresql. I tried a simple example, generating an EF Model from a database with a single table:

CREATE TABLE manufacturers
(
manufacturerid smallint NOT NULL,
manufacturername character varying(125) NOT NULL,
CONSTRAINT manufacturers_pkey PRIMARY KEY (manufacturerid)
)
WITH (
OIDS=FALSE
);


The resulting code in the model (model1.edmx) is:


SELECT
manufacturers.manufacturerid AS manufacturerid,
manufacturers.manufacturername AS manufacturername
FROM public.manufacturers AS manufacturers


Further I find the following error:
warning 6002: The table/view 'mydb.public.manufacturers' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.


Seems that the EF generator is unable to find my primary key and therefore generates a view rather then a table. Any inserts or updates using the EF objects subsequently failes.

Any ideas whats wrong?
Thanks!

The problem seems to be associated with the server version. We are investigating it.
Is the problem reproducible using Entity Developer (try to add Devart Entity model to your project)?

Hi!

Thank you for your answer, I will try to reproduce the issue with your Entity Designer instead of the VS2008 one.

However, which PostgreSQL server Version do you recommend to use?

Thanks, Tom

Hi!

The Devart ED did his job quite nice, some FKs werent recognized correctly (due to some datatype issues on the DB).

But, whats the issue with VS2008 ED?

Yours, Tom

I have requested some information with the help of e-mail that you have provided in your forum profile.