Hi,
If you want a direct driver, you can get at
http://crlab.com/pgsqlnet/index.html.
ODBC is the next option.
Any how all the providers provide similar object library as all are the implimentions of ineterfaces provided by .NET framework. Thus If you can connect and manipulate any one RDBMS from .net, you will not have much problem for another one.