Rob,

Doing simple database operations does not have to be this hard. Check out
LLBLGen, a great OR Mapping tool. It supports several databases, including
PostGRESQL. We are using it in a large project and we are very happy. It costs a
little money, but is well worth the expense.

http://www.llblgen.com/defaultgeneric.aspx

Prasad



From: CSharpNET@yahoogroups.com [mailto:CSharpNET@yahoogroups.com] On Behalf Of
Rob Richardson
Sent: Tuesday, January 06, 2009 2:12 PM
To: CSharpNET@yahoogroups.com
Subject: UDPATE: RE: [C#.NET] ADO.Net: How do I do a simple update?


I seem to be getting someplace, however slowly.

My first mistake was using a piece-of-@!$#%# provider to talk to my
PostGRESQL database. I believe I'm using the PgOleDb providr from
PGFoundry (http://www.pgfoundry.org), but its last state is noted to be
"beta", and that version was released in 2006. I tried using ODBC
instead (OdbcConnection and related classes), and things started
happening.

Not all good: my attempt to update using the update command generated
behind the scenes by the OdbcCommandBuilder object failed, throwing an
exception that said that I was trying to access
"great_lakes_10_09.public.base_type", and cross-database queries are not
supported (despite the fact that that is the proper fully-qualifed name
of the table I'm working with). But when I tried with an explicitly
generated update command, it worked.

I am developing a Windows Forms application (not ASP.Net) using Visual
Studio 2008 and trying to talk to a PostGRESQL 8.1 database.

RobR



[Non-text portions of this message have been removed]