Greetings!
I am trying to learn how to use ADO.Net to access a PostGRESQL database
through C#, using MS Visual Studio 2008 on a Windows XP Pro box. At
first, I was using the PgOldDb provider for .Net, but it seems that that
provider is not complete. It did not work for me. I switched to ODBC
and was able to perform the update operations I spent more than a day
struggling with. I would still like to use OLE DB instead of ODBC, as I
understand that it is faster and more compatible with the .Net
architecture. So I tried the Npgsql provider. I was dismayed to see
that there are no installation instructions on the PGFoundry download
page, but a Google search turned up a user's manual. According to that,
all I had to do was to put the npgsql.dll file into a known location,
and if I wanted IntelliSense to work, I had to put into the GAC as well.
So I did. But when I tried to run an application using it, an exception
was thrown complaining that it could not find file or assembly
Mono.Security.
Do I have the wrong file? I loaded the .Net 2.0 version (or so I
thought). Do I need another file? Should I use a different provider
entirely?
Thank you very much.
RobR