Page 1 of 1

No Primary Key Set Using ADO.NET

Posted: Sun 11 Nov 2007 17:02
by leeottaway
Hi

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?

Thanks

Posted: Mon 12 Nov 2007 15:50
by Alexey
Please describe the problem in detail. Where do you expect primary key to appear? Provide your database table definition.