Extended data access technologies and functionality
Powerful PgSqlDataTable component for manipulating individual tables or query result
NonBlocking mode allows fetching data asynchronously in the background
On-demand data fetch for data-bound controls
Paginal access to query result
Server side master-detail relation based on queries
Ability to refresh individual records in PgSqlDataTable component
Support for Enterprise Library Data Access Application Block (DAAB)
Object-oriented building of SELECT statements
Extended warning and error information retrieval
Extended interface for processing execution exceptions
PgSqlDataAdapter.Fill method with sequential fetch support
Ability to defer fetching of some columns in a resultset
Named parameters support
WinForms-specific features
Flexible data binding with DataLink component
InterForm technology for cross-form components cooperation
Global position synchronization within a data source
ASP.NET-specific features
ASP.NET data providers: Membership, Role, Session State, Profile, Personalization, Site Map, Web Event
PgSqlDataSource web component
PgSqlCacheDependency component to control Cache item dependencies in ASP.NET applications
Script execution
Advanced script execution features with PgSqlScript component
Support for executing individual statements in scripts
Support for executing huge scripts stored in files with dynamic loading
SQL execution monitoring
Extended SQL tracing capabilities with PgSqlMonitor component
Support for dbMonitor utility for advanced tracing analysis and control
Per-component SQL tracing
Optional log output to IDE toolwindows
Design-time enhancements
Automatic component registration in toolbox
Advanced integration with Visual Studio 2008, 2010, 2012, 2013, 2015, 2017, 2019, and 2022 including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component PgSqlDataSource
DataSet Wizard to create and edit typed PostgreSQL-oriented datasets
DataSet Manager to list and bind datasets in the project
DataSet Editor to edit dataset contents
Advanced design-time component and property editors
IntelliSense descriptions for dotConnect for PostgreSQL classes
Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard
TableMappings editor
Convenient instant data preview and management in design time
Product clarity
Complete documentation sets integrated into Visual Studio and CodeGear Delphi
Integration with Visual Studio and MSDN help collections
Documentation available as a standalone chm file
A large amount of helpful demos in C# and VB
Licensing and support
Included annual dotConnect for PostgreSQL Subscription with Priority Support
Licensed royalty-free per developer, per team, or per site