CODEWITHSUNDEEP
databasevisual-studio-2008postgresql
Astaar
Astaar

Reputation: 6598

PostgreSQL Data Connection/Server Explorer in Visual Studio 2008

I'm trying to find a way to browse a PostgreSQL database from the Visual Studio 2008 "Server Explorer" panel. I downloaded Npgsql but as I understand that's only a library for the code itself, not the Server Explorer.

Upvotes: 4

Views: 18904

Answers (2)

user2189331
user2189331

Reputation:

Npgsql is a .NET provider for PostgreSQL. Whether or not a given provider integrates with Server Explorer depends on whether it supports DDEX, which Npgsl as of now does not, but this support is planned for future versions.

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

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

Also, I should mention that Npgsql DOES have some design-time integration with Visual Studio - for example you can use NpgsqlConnection objects from the toolbar and so forth.

Upvotes: 8

HakonB
HakonB

Reputation: 7075

I looked for this earlier this year and found someone that on some mailing list wrote that they were working on that for Npgsql but it not yet available.

We actually discarded Npsql and now uses dotConnect for PostgreSQL instead. It is a commercial product with a free option but you have to pay to the get the Visual Studio integration.

Upvotes: 1

Related Questions