Key Features of dotConnect for PostgreSQL

Compatibility

  • Support for PostgreSQL server versions 8-17
  • Support for EnterpriseDB, EnterpriseDB Advanced Server, Postgres Plus Advanced Server, EDB Postgres Advanced Server, Pervasive Postgres SQL servers, Heroku Postgres
  • x64 and x86 architecture
  • Windows, Linux, macOS

Platforms

  • .NET 5.0-9.0
  • .NET Core 1.x-3.0
  • .NET Standard 1.3-2.1
  • .NET Frameworks 2.0–4.8
  • ASP.NET Core
  • Blazor
  • .NET MAUI (previously Xamarin)
  • .NET Compact Framework
  • Mono Framework
  • Sync Framework

.NET languages

  • C#
  • VB.NET
  • F#

ORM support

  • Entity Framework Core 1.x-9.0
  • Entity Framework v1-v6
  • Dapper 1.x, 2.x
  • NHibernate 1.x-5.x
  • LINQ to Entities

Entity Framework features

  • Spatials support
  • Change tracking and object data caching support
  • Inheritance mapping support (TPH, TPT, TPCT models)
  • Stored procedures and functions support
  • Ability to build database-independent applications
  • Full-text search support

With Entity Developer

  • Visual model creation and code generation
  • Model update from the database
  • Database update with mapping synchronization
  • Reverse engineering of database objects to an entity model
  • Storage schema editing of Entity Framework
  • Standalone usage or Visual Studio integration

Security standards

  • SSL/TLS, SSH connections
  • Connection through proxy servers and HTTP tunnels
  • Connected and disconnected data access models
  • Support for the compression protocol
  • Unicode connections
  • Failover support
  • Load balancing support
  • Encryption algorithms: RC4, RC4-56, RC4-128, RC4-256, DES-40, DES-56, DES-112, DES-168, AES-128, AES-192, AES-256
  • Checksum algorithms: MD5, SHA1, SHA256, SHA384, SHA512
  • Operation in the FIPS 140-2 mode in Windows
  • Passing credentials via PostgreSqlCredential class, based on SecureString

Certification

  • DigiCert Trusted G4 Code Signing RSA4096 SHA384
    2021 CA1

Performance

  • Intelligent fetch block size control
  • Advanced connection pooling
  • High-performance batch processing
  • Support for the prepared statements in the protocol for maximum performance

IDE integration

Visual Studio

Microsoft Visual Studio 2008-2022

  • 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
  • Syntax highlighting and SQL code completion in design-time editors
  • TableMappings editor
  • Convenient instant data preview and management at design time

Without design-time integration

  • Visual Studio Code
  • JetBrains ReSharper and Rider
  • CodeGear Delphi 2007
  • Embarcadero Delphi Prism
  • Support for the Enterprise Library Data Access Application Block (DAAB)

ADO.NET architecture

  • Server enumeration
  • Batch update support
  • Extended metadata information retrieval
  • Advanced CommandBuilder component with automatic refresh SQL
  • Enhanced pooling control through the 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

NuGet availability

Devart.Data.PostgreSql 
dotnet add package Devart.Data.PostgreSql
Devart.Data.PostgreSql.EFCore 
dotnet add package Devart.Data.PostgreSql.EFCore
Devart.Data.PostgreSql.EFCore.Design 
dotnet add package Devart.Data.PostgreSql.EFCore.Design
Devart.Data.PostgreSql.EF6 
dotnet add package Devart.Data.PostgreSql.EF6

Script execution

  • Advanced script execution features with the 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 the dbMonitor utility for advanced tracing analysis and control
  • Per-component SQL tracing
  • Optional log output to the IDE

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 queries
  • Large objects support
  • PostgreSQL ARRAY data type support with the PgSqlArray class
  • Full support for PostgreSQL range types

WinForms-specific features

  • Flexible data binding with the DataLink component
  • InterForm technology for cross-form components cooperation
  • Global position synchronization within a data source

Extended DataTable and DataSet functionality

  • Powerful PgSqlDataTable component for manipulating individual tables or query results
  • NonBlocking mode allows fetching data asynchronously in the background
  • On-demand data fetch for data-bound controls
  • Paginal access to query results
  • Server side master-detail relation based on queries
  • Ability to refresh individual records in the 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 result set
  • Named parameters support