dotConnect for PostgreSQL Overview
dotConnect for PostgreSQL, formerly known as PostgreSQLDirect .NET, is an enhanced ORM enabled data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and leverages database applications.
Fast and Advanced ADO.NET Provider
dotConnect for PostgreSQL offers both high performance connectivity to the PostgreSQL database and a number of innovative development tools and technologies. It support a wide range of PostgreSQL-specific features, such as secure SSL connections, PostgreSQL notifications, PostgreSQL bulk data loading, GEOMETRY, PostgreSQL ARRAY types, and others.
dotConnect for PostgreSQL provides a vast number of GUI tools that increase your productivity. It integrates into Visual Studio Server Explorer and other tools, and provides advanced visual component editors to simplify component tweaking. DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.
dotConnect for PostgreSQL offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. dotConnect for PostgreSQL supports ADO.NET Entity Framework, NHibernate, and LinqConnect (formerly known as LINQ to PostgreSQL) - our own ORM solution, closely compatible to Microsoft LINQ to SQL, while extending its functionality with its own features.
Allows your application to work with PostgreSQL directly via TCP/IP without involving PostgreSQL Client software.
Implements Role, Session State, Membership, Profile, Site Map, and other ASP 2.0 providers.
Can be used in conjunction with Microsoft Enterprise Library Data Access Application Block.
Enables Integration Services to export and import data to/from PostgreSQL servers.
Allows per-component tracing of database events with a free dbMonitor application.