Problem with C# TableAdapter

[Klaus Ummenhofer]

Hello community,

I try to access a PostgreSql database with C# and have some problems creating a TableAdapter.

The problem is that a new TableAdapter does only create the SELECT command but not the commands for UPDATE, INSERT and DELETE. I am using the ODBC driver PSQLODBC30A.DLL 8.04.01.00, PostgreSql 8.4 and VS2005.

I found some information affecting my problem which are related to primary keys. So far I am aware of needing a primary key in order to generate these commands. Please could someone inspect the CREATE scripts below which are not working properly and let me know, how I should change them.

What else could I do in order to use the database via a TableAdapter object?

Thank you.

Klaus

CREATE TABLE films (
code char(5) CONSTRAINT firstkey PRIMARY KEY,
title varchar(40) NOT NULL,
did integer NOT NULL,
date_prod date,
kind varchar(10),
len interval hour to minute
);


CREATE TABLE script
(
id serial NOT NULL,
"name" character varying(10) NOT NULL,
script_data text,
CONSTRAINT script_pk PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE script OWNER TO postgres;

--
Sent via pgsql-odbc mailing list (pgsql-odbc@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

[Joshua D. Drake]

On Sat, 2009-10-10 at 16:33 +0200, Klaus Ummenhofer wrote:
> Hello community,
>
> I try to access a PostgreSql database with C# and have some problems creating a TableAdapter.

This doesn't answer your question, but why are you not using the .Net
driver?

Joshua D. Drake

>
> The problem is that a new TableAdapter does only create the SELECT command but not the commands for UPDATE, INSERT and DELETE. I am using the ODBC driver PSQLODBC30A.DLL 8.04.01.00, PostgreSql 8.4 and VS2005.
>
> I found some information affecting my problem which are related to primary keys. So far I am aware of needing a primary key in order to generate these commands. Please could someone inspect the CREATE scripts below which are not working properly and let me know, how I should change them.
>
> What else could I do in order to use the database via a TableAdapter object?
>
> Thank you.
>
> Klaus
>
> CREATE TABLE films (
> code char(5) CONSTRAINT firstkey PRIMARY KEY,
> title varchar(40) NOT NULL,
> did integer NOT NULL,
> date_prod date,
> kind varchar(10),
> len interval hour to minute
> );
>
>
> CREATE TABLE script
> (
> id serial NOT NULL,
> "name" character varying(10) NOT NULL,
> script_data text,
> CONSTRAINT script_pk PRIMARY KEY (id)
> )
> WITH (
> OIDS=FALSE
> );
> ALTER TABLE script OWNER TO postgres;
>

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander


--
Sent via pgsql-odbc mailing list (pgsql-odbc@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

[Klaus Ummenhofer]

AFAIK the NpgSQL .Net data provier does not support IDE integration but ODBC should. So it is more difficult to establish a strong typed database access. But indeed some third party .Net data providers support IDE integration. They may be an option for me. Please correct me if I am wrong with the things I wrote above.

Klaus

On Sat, 2009-10-10 at 16:33 +0200, Klaus Ummenhofer wrote:
> Hello community,
>
> I try to access a PostgreSql database with C# and have some problems
> creating a TableAdapter.

This doesn't answer your question, but why are you not using the .Net driver?

Joshua D. Drake

>
> The problem is that a new TableAdapter does only create the SELECT
> command but not the commands for UPDATE, INSERT and DELETE. I am using
> the ODBC driver PSQLODBC30A.DLL 8.04.01.00, PostgreSql 8.4 and VS2005.
>
> I found some information affecting my problem which are related to
> primary keys. So far I am aware of needing a primary key in order to
> generate these commands. Please could someone inspect the CREATE
> scripts below which are not working properly and let me know, how I
> should change them.
>
> What else could I do in order to use the database via a TableAdapter
> object?
>
> Thank you.
>
> Klaus
>
> CREATE TABLE films (
> code char(5) CONSTRAINT firstkey PRIMARY KEY,
> title varchar(40) NOT NULL,
> did integer NOT NULL,
> date_prod date,
> kind varchar(10),
> len interval hour to minute
> );
>
>
> CREATE TABLE script
> (
> id serial NOT NULL,
> "name" character varying(10) NOT NULL,
> script_data text,
> CONSTRAINT script_pk PRIMARY KEY (id)
> )
> WITH (
> OIDS=FALSE
> );
> ALTER TABLE script OWNER TO postgres;
>

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering If the world pushes look it in the eye and GRR. Then push back harder. - Salamander


--
Sent via pgsql-odbc mailing list (pgsql-odbc@...)
To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-odbc
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.421 / Virus Database: 270.14.9/2427 - Release Date: 10/10/09 06:39:00



--
Sent via pgsql-odbc mailing list (pgsql-odbc@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc