dotConnect for PostgreSQL is a complete solution for providing data access to PostgreSQL based database applications. It includes ORM support and comes packed with various developments tools, to help increase your efficiency.
It is based on ADO.NET and provides fast connectivity to PostgreSQL databases. In addition, it also supports direct TCP/IP connectivity, without database client being installed on your machine.
It can simplify and enhance your database connectivity, while offering a number of functionalities native to PostgreSQL, such as PostgreSQL notifications, GEOMETRY, ARRAY types, bulk data loading and SSL connectivity, amongst others.
It comes with built-in visual components for managing and simplifying different aspects of connectivity, including various managers, wizards and editors. Besides the ability to be integrated into Microsoft Visual Studio, It can be integrated into many other development tools as well.
Various ORM solutions are supported, such as ADO.NET Entity Framework, NHibernate and LinqConnect (adds additional features to LINQ to SQL), and it also comes with its own solution for creating ORM models visually.
There are various ASP 2.0 providers supported, while database events can be traced via a freely available external monitoring application, called dbMonitor. And, for importing and exporting of data to and from PostgreSQL, there is also added support for Integration Services.
Reviewed by Tony Hill (editor rating 4 out of 5 stars)