AFAIK the NpgSQL .Net data provier does not support IDE integration but ODBC should. So it is more difficult to
establisha strong typed database access. But indeed some third party .Net data providers support IDE integration. They
maybe 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,
EngineeringIf the world pushes look it in the eye and GRR. Then push back harder. - Salamander
--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
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