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
- Support for both x64 and x86 architecture
- Windows, Linux, MacOS support
- .NET 6 support
- .NET 5 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 - 2016 Business Intelligence Solutions support
- Sync Framework 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
- Full support for PostgreSQL range types
Performance
- High overall performance
- Intelligent fetch block size control
- Advanced connection pooling
- High performance batch processing
ADO.NET technology support
- Full support for ADO.NET Entity Framework v1 - v6
- Entity Framework Core 1.x, 2.x, 3.1, 5.0, 6.0, and 7.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
- Conceptual approach to enterprise development
- High performance
- Wide support for LINQ to Entities
- Entity Framework Code First support
- Entity Framework Code First Migrations support
- Wide support for EntitySQL
- Full CRUD (Create, Retrieve, Update, Delete) support
- Wide support for server data types
- Entity Framework Spatials support
- Entity Framework Core Spatials support
- 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
- Full-text search support
- Visual Studio EDM Wizard support
- Reverse engineering of database objects to entity model
- Support for most Entity Framework Canonical Functions
-
Visual model creation and code generation with
Entity Developer
- Update Model From Database functionality for Entity Developer
- Update To Database with Mapping Synchronization functionality for 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
- Ability to execute DML statements in batches on SubmitChanges
- Fluent Mapping support
- Complex type support
- PLINQ support (connection manager redesigned for thread safety)
- Support for different configurable algorithms for primary key generation
- Inheritance mapping support (Table Per Hierarchy and Table Per Type
- Support of Visual Studio Debugger Visualizer for the DataQuery objects
- ASP.NET Dynamic Data support with ASP.NET Dynamic Data project templates
- Automatic configurable compiled query caching
- 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
- Server-independent interface
-
Visual model creation and code generation with
Entity Developer
- Update Model From Database functionality for Entity Developer
- Update To Database with Mapping Synchronization functionality for Entity Developer
- Illustrated tutorial to get started with LinqConnect in 5 minutes
Workflow Foundation Support
- PostgreSQL Workflow Instance Store support
- PgSqlTrackingParticipant class to store tracking records in a PostgreSQL database
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
Business Intelligence Solutions Support
- SQL Server Integration Services (SSIS) 2019, 2017, 2016, 2014, 2012, and 2008 support
- SSIS DataFlow Source and Destination components
- Analysis Services support
- Reporting Services 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 Identity 1 and 2 support
- ASP.NET data providers: Membership, Role, Session State, Profile, Personalization, Site Map, Web Event
- ASP.NET SimpleMembership providers support
- 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#, VB, C++, and Delphi
Licensing and support
- Included annual dotConnect for PostgreSQL Subscription with Priority Support
- Licensed royalty-free per developer, per team, or per site