Visual Studio 2008 中的 PostgreSQL 数据连接/服务器资源管理器
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/867879/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
PostgreSQL Data Connection/Server Explorer in Visual Studio 2008
提问by Astaar
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.
我正在尝试找到一种从 Visual Studio 2008“服务器资源管理器”面板浏览 PostgreSQL 数据库的方法。我下载了 Npgsql，但据我所知，这只是代码本身的库，而不是服务器资源管理器。
回答by
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.
Npgsql 是 PostgreSQL 的 .NET 提供程序。给定的提供程序是否与 Server Explorer 集成取决于它是否支持DDEX，而 Npgsl 目前不支持，但计划在未来版本中提供这种支持。
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.
但是，如果您只想在服务器资源管理器中浏览 PostgreSQL 数据库，您可以通过安装psqlODBC、PostgreSQL ODBC 驱动程序并通过.NET Framework Data Provider for ODBC 进行连接来实现。
alt text http://www.codingthewheel.com/image.axd?picture=postgre_sql_server_explorer.png
替代文字 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.
另外，我应该提到 Npgsql 确实与 Visual Studio有一些设计时集成- 例如，您可以使用工具栏上的 NpgsqlConnection 对象等等。
回答by HakonB
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.
我在今年早些时候寻找过这个，发现有人在一些邮件列表上写道，他们正在为 Npgsql 研究这个，但还没有。
We actually discarded Npsql and now uses dotConnect for PostgreSQLinstead. It is a commercial product with a free option but you have to pay to the get the Visual Studio integration.
我们实际上放弃了 Npsql，现在使用dotConnect for PostgreSQL代替。它是具有免费选项的商业产品，但您必须付费才能获得 Visual Studio 集成。
