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
