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