blocks|key|1556970|text|目前大多数语言/平台(Java、.NET、PHP、Perl等)几乎可以使用任何数据库管理系统(SQL+Server、Firebird、MySQL、Oracle、PostgresSQL等)所以我一点也不会担心。当然，可能会有小故障和小问题，但不会让人望而却步。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1556971|正如jalcom建议的那样，您应该针对一组接口或至少一组基类(DbConnection、DbCommand等)进行编程，以获得易于适应的应用程序。|1556972|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Today most languages/platforms (Java, .NET, PHP, Perl etc.) can work with almost any DBMS (SQL Server, Firebird, MySQL, Oracle, PostgresSQL etc.) so I wouldn't worry for one second. Sure there might be glitches and small problems but no showstopper.

As jalcom suggested you should program against a set of interfaces or at least a set of base classes (DbConnection, DbCommand and so on) to have an easily adaptable application.

blocks|key|1556985|text|你应该不会有太多问题。正如其他人所提到的，有许多.Net+PostgreSQL数据提供程序可用。您可能需要注意的一件事是，像Linq这样的功能可能无法使用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1556986|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You shouldn't have too many problems. As others have mentioned, there's many .Net PostgreSQL data providers available. One thing you may want to look out for is that features like Linq will probably not be able to be used.

blocks|key|1772193|text|在https://www.nuget.org/packages/linq2db.PostgreSQL/上有一个用于PostgreSQL的Linq提供程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1772194|entityMap|0|LINK|mutability|MUTABLE|url|https://www.nuget.org/packages/linq2db.PostgreSQL/^0|1|1E|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

There is a Linq provider for PostgreSQL at <a href="https://www.nuget.org/packages/linq2db.PostgreSQL/" rel="nofollow noreferrer">https://www.nuget.org/packages/linq2db.PostgreSQL/</a>.

blocks|key|1772270|text|我们已经使用visual+studio+2005和devart+ado.net+data+provider+for+PostgreSql+(http://www.devart.com/pgsqlnet/)开发了几个应用程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1772271|此提供程序的优势之一是它提供了完整的Visual+Studio支持。最新版本包括所有新的框架功能，如linq。|1772272|entityMap|0|LINK|mutability|MUTABLE|url|http://www.devart.com/pgsqlnet/^0|1Y|V|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

We have developed several applications using visual studio 2005 with the devart ado.net data provider for PostgreSql (<a href="http://www.devart.com/pgsqlnet/" rel="nofollow noreferrer">http://www.devart.com/pgsqlnet/</a>).

One of the advantages of this provider is that it provides full Visual Studio support. The latest versions include all the new framework features like linq.

blocks|key|1557142|text|不要因为缺乏Linq支持而阻止你。我使用的一种模式是总是将数据返回到列表中，然后再返回linq。当我发现MySQL中相同的(诚然令人费解的)+Linq表达式没有带回与Sql+Server中相同的数据时，我开始认真地做这件事。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1557143|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Dont let a lack of Linq support stop you. A pattern I use is to always return my data into lists, and then linq away. I started doing this religiously when I found that the same (admittedly obscure) Linq expression in MySQL didnt bring back the same data as it did in Sql Server.

blocks|key|1772452|text|Npgsql是一个优秀的驱动程序，但到目前为止，我发现的唯一问题是数值不适合System.Decimal，因此每个查询或DB模式只有一个选项是正确的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1772453|https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/438#issuecomment-486586272|offset|length|1772454|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2P|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

Npgsql is excellent driver, but only issue Ive found so far is that Numeric value does not fit in a System.Decimal, so only option is correct each query or DB schema 

<a href="https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/438#issuecomment-486586272" rel="nofollow noreferrer">https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/438#issuecomment-486586272</a>

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. 

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# .NET + PostgreSQL

数据库管理系统

数据库管理

Visual Studio

SQL Server

PostgreSQL

数据库

MySQL

Java

Perl

我正在考虑一个项目，它使用C#.NET (坐在windows机器上)作为主要语言，PostgreSQL作为后端数据库(后端坐在linux机器上)。我听说ODBC.NET可以很容易地集成这两个组件。有没有人有实际设置C#和PostgreSQL协同工作的经验？如果是这样的话，你对如何去做，你发现的问题等有什么建议吗？

问C# .NET + PostgreSQL
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C# .NET + PostgreSQLEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C# .NET + PostgreSQL
EN