我在寻找工作的，它使用C＃.NET（坐在窗户框）作为主要语言和PostgreSQL作为后台数据库（后端坐在Linux中）的一个项目。我听说ODBC.NET可以很容易地整合这两个组件。

I'm looking at working on a project which uses C#.NET (sitting on a windows box) as the primary language and PostgreSQL as the backend database (backend is sitting on a linux box). I've heard that ODBC.NET allows for easy integration of these two components.

有没有人有经验，在实际设置C＃和PostgreSQL高达协同工作？如果是这样，你对如何去做任何建议，你已经找到，等。？问题

Has anyone had experience actually setting C# and PostgreSQL up to work together? If so, do you have any suggestions about how to go about it, issues you've found, etc.?

推荐答案

我用C＃和Postgres的使用 Npgsql2 组件的工作，他们工作速度快，我建议你。

I'm working with C# and Postgres using Npgsql2 component, and they work fast, I recommend you.

您可以从 http://pgfoundry.org/projects/npgsql

注意：如果你想与任何数据库运行的应用程序，你可以使用 DbProviderFactory 类和使用让您的查询的的IDbConnection ，< B> IDbCommand的，的IDataReader 和/或 IDbTransaction 接口。

Note: If you want an application that works with any database you can use the DbProviderFactory class and make your queries using IDbConnection, IDbCommand, IDataReader and/or IDbTransaction interfaces.