General usability

• Direct access to server data
• Real RAD for database applications
• Fully compliant with ADO.NET
• 100% managed code
• Highly usable design time support
• Easy to deploy

Network and connectivity

• Doesn't require PostgreSQL client library and uses PostgreSQL protocol directly
• Both connected and disconnected data access models
• Unicode connections
• SSL connection to PostgreSQL server

Compatibility

• Full support of the latest versions of PostgreSQL, including version 17
• Support for both x64 and x86 architecture
• Windows, Linux, MacOS support
• .NET 5.0-9.0 support
• .NET Core 3.x, 2.x, and 1.x support
• .NET Standard 2.1, 2.0 1.6, 1.5, 1.4, and 1.3 support
• .NET Frameworks 4.8, 4.7, 4.6, 4.5, 4.0, 3.5, 2.0 support
• .NET Compact Framework support
• Mono Framework support
• Microsoft Visual Studio 2022, 2019, 2017, 2015, 2013, 2012, 2010, and 2008 support
• CodeGear Delphi 2007 support
• Embarcadero Delphi Prism support
• SQL Server 2008 - 2023 Business Intelligence Solutions support

PostgreSQL technology support

• All PostgreSQL data types support, including Composite types
• Stored procedures support
• Returning result sets from stored procedures
• PgSqlDump component to store a database or its parts as a script and then restore it
• PgSqlLoader component for fast loading data
• PgSqlAlerter component to manage PostgreSQL notifications with LISTEN and NOTIFY commands
• Fill DataSet with multiple query
• Large objects support
• PostgreSQL ARRAY data type support with the PgSqlArray class
• Support for PostgreSQL TimeStamp types with the PgSqlTimeStamp class

Performance

• High overall performance
• Intelligent fetch block size control
• Advanced connection pooling
• High performance batch processing

ADO.NET technology support

• Entity Framework 1, 4.0, 4.5, 5, and 6.4.4 support
• Entity Framework Core 1.1, 2.2, 3.1, 5.0, 6.0, 7.0, and 9.0 support
• Server enumeration
• Batch update support
• Extended metadata information retrieval
• Advanced CommandBuilder component with automatic refresh SQL
• Enhanced pooling control through connection string
• Connection string builder
• Provider factory for generating key data access classes
• Asynchronous command execution
• Provider-specific types support
• Password change API
• Database Change Notification Support
• Possibility to retrieve OID values

ADO.NET Entity Framework

• Full support for ADO.NET Entity Framework v1 - v6
• Entity Framework Core 1.1, 2.2, 3.1, and 5.0 support
• Conceptual approach to enterprise development
• High performance
• Wide support for LINQ to Entities capabilities
• Wide support for EntitySQL
• Full CRUD (Create, Retrieve, Update, Delete) support
• Wide support for server data types
• Change tracking support
• Object data caching
• Inheritance mapping support (TPH, TPT, and TPCT models)
• Capability to use stored procedures when manipulating data
• Stored procedure import support
• Ability to build database-independent applications
• Visual Studio EDM Wizard support
• Reverse engineering of database objects to entity model
• Visual model creation and code generation with Entity Developer
• Illustrated tutorial to get started with Entity Framework in 5 minutes

LinqConnect (formerly known as LINQ to PostgreSQL)

• Easy to use
• High performance
• Interchangeable with Microsoft LINQ to SQL
• Plain CLR classes used (no need to use a common base class)
• Full CRUD (Create, Retrieve, Update, Delete) support
• Complex type support [New]
• Support for different configurable algorithms for primary key generation [New]
• Automatic configurable compiled query caching [New]
• Change tracking support
• Object data caching
• Data binding support
• Wide support for LINQ capabilities
• Wide support for server data types
• Load on demand (lazy load)
• Database transactions support
• Inheritance mapping support (table per hierarchy model)
• Server-independent interface
• Visual model creation and code generation with Entity Developer
• Illustrated tutorial to get started with LinqConnect in 5 minutes

Workflow Foundation Support

• PostgreSQL Workflow Instance Store support [New]
• PgSqlTrackingParticipant class to store tracking records in a PostgreSQL database [New]

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