Table Adapters

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
T.Winkler
Posts: 16
Joined: Fri 03 Feb 2006 19:50

Table Adapters

Post by T.Winkler » Thu 19 Oct 2006 08:52

Hello.

I use PGSQL DLL Version 2.50.21.0 pro for DotNet 2.0 and have some trouble with the table adapters. So, if I use the PGSQL dataset wizard it looks like everything is ok, but the update insert and delete command contains the name of the database like:
Delete from database.schema.table…….
It works but if I change the connection string to an other database it generates an error like Cross reference are not supported.
Now, I can change the command text without the wizard ( edit the text only in the box of the properties) and the update and insert command will be work. But the delete command generates wrong parameter.
If I change the command text with the wizard he generates for all commands to much and also wrong parameters.
So it is not possible to change some commands.

Do you see some help for this problem?

Regards

Thomas

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

Post by Alexey » Fri 20 Oct 2006 06:34

If you change database you have to regenerate all update, delete, insert commands.

Post Reply