No Primary Key Set Using ADO.NET

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 30
Joined: Sat 10 Nov 2007 20:36

No Primary Key Set Using ADO.NET

Post by leeottaway » Sun 11 Nov 2007 17:02


I've come from using an Access database and have always simply used the .Fill method on the datatable using an oledbdataadapter that has the MissingSchemaAction set to AddWithKey. This always gets the primary key of the table, however using your provider with pgSQL, I notice it never gets the primary key using .Fill and I have to set it manually even when the MissingSchemaAction is defined as AddWithKey.

Any ideas why this might be?


Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 12 Nov 2007 15:50

Please describe the problem in detail. Where do you expect primary key to appear? Provide your database table definition.

Post Reply