No Primary Key Set Using ADO.NET

No Primary Key Set Using ADO.NET

Postby 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: 30
Joined: Sat 10 Nov 2007 20:36

Postby 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.
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Return to dotConnect for PostgreSQL