About dotConnect for PostgreSQL

Full-featured ADO.NET provider for direct access to PostgreSQL servers.

dotConnect for PostgreSQL Data Provider supports .NET Framework with ADO.NET features. To reach high performance the provider uses a native message-based protocol for communication with the PostgreSQL server. It uses 100% managed code and doesn't require any client software. It provides extra functionality, monitoring abilities and offers advanced design-time extensions.

Overview

dotConnect for PostgreSQL is data provider to direct access to PostgreSQL database for the Microsoft .NET Framework. It completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology.

ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data.

dotConnect for PostgreSQL data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider.

dotConnect for PostgreSQL uses native message-based protocol for communication with PostgreSQL server. It allows to create lightweight and fast applications working with PostgreSQL

Key features:

  • Direct access to PostgreSQL server
  • Doesn't require PostgreSQL client library and uses PostgreSQL protocol directly
  • 100% managed code
  • High performance
  • Easy to deploy
  • Supports the latest versions of PostgreSQL server
  • All PostgreSQL data types support
  • Composite types supported
  • Compact Framework support
  • Mono Framework support
  • Connection pooling feature
  • Fill DataSet with multiple query
  • PgSqlScript component to execute scripts
  • PgSqlLoader component for fast loading data
  • Paginal access to query result
  • Named parameters support
  • Ability of monitoring query execution by DBMonitor
  • Advanced design-time editors
  • Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard
  • Help integrated into Visual Studio .NET
  • Free support for registered users
  • Licensed per a developer without royalty fees

dotConnect for PostgreSQL comes in three editions: Professional, Standard and Mobile. Standard edition includes ADO.NET core classes and classes for native data types only. Professional edition includes additional classes, design-time extensions and wizards. Mobile edition is the same as Standard but works with .NET Compact Framework.