Dynamic SQL generation for SelectCommand fails

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 64
Joined: Wed 20 Jul 2016 04:21

Dynamic SQL generation for SelectCommand fails

Post by chris901 » Sun 09 Oct 2016 16:57

PostgreSQL 9.5 and latest dotConnect Version installed.

When I try to generate Insert, Update and Delete Commands for the PgSqlDataTable using the Command Generator I get the following error:

Roughly translated: "Dynamic SQL generation is not supported for SelectCommand because it doesn't return base table informations"


When I searched for this error I found that this can be caused by not having a primary key in the table. However I do have a PK and it is also part of the query I am using in the SelectCommand.

I am using this database:
http://www.postgresqltutorial.com/postg ... -database/

I installed the database like this:
http://www.postgresqltutorial.com/load- ... -database/

The query SelectCommand:

Code: Select all

select * from actor;

Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Dynamic SQL generation for SelectCommand fails

Post by Pinturiccio » Tue 11 Oct 2016 13:22

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Post Reply