Geek Answers Handbook

PostgreSQL Data Connection / Server Explorer in Visual Studio 2008

I am trying to find a way to view the PostgreSQL database from the Explorer panel of Visual Studio 2008. I downloaded Npgsql, but as I understand it, this is only a library for the code itself, and not for Server Explorer.

+4
source share
2 answers

Npgsql is the .NET provider for PostgreSQL. Regardless of whether this provider integrates with Server Explorer, whether it supports DDEX , which Npgsl does not currently have, but this support is planned for future versions .

However, if all you want to do is to be able to view the PostgreSQL database in Server Explorer, you can do this by installing psqlODBC , the PostgreSQL ODBC driver, and connecting through . NET Framework Data Provider for ODBC .

alt text http://www.codingthewheel.com/image.axd?picture=postgre_sql_server_explorer.png

In addition, I should mention that Npgsql DOES has development-time integration with Visual Studio - for example, you can use NpgsqlConnection objects from the toolbar, etc.

+7
source

I searched this earlier this year and found someone on some mailing list saying that they are working on it for Npgsql, but it is not yet available.

We actually dropped Npsql and now instead dotConnect for PostgreSQL . This is a commercial product with a free option, but you need to pay for the integration of Visual Studio.

0
source

More articles:


All Articles