dotConnect Express for PostgreSQL 5.50.228

dotConnect Express for PostgreSQL 5.50.228 is launched to be a helpful and smart data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications.

As part of the Devart database application development framework, dotConnect for PostgreSQL offers both high performance native connectivity to the PostgreSQL database and a number of innovative development tools and technologies.

dotConnect for PostgreSQL introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation.

Major Features:

1. .NET Framework support
2. ADO.NET core classes
3. Native data types classes and structure
4. Advanced Visual Studio 2005/2008/2010 integration

Enhancements:

• The bug with licensing WinForms projects in Delphi Prism is fixed
• The bug with workability of command timeout for prepared commands is fixed
• The bug with assigning the UnpreparedExecute option from connection string to the command is fixed
• LinqConnect (formerly known as LINQ to PostgreSQL)
• • The bug with ordering queries with eager loading options is fixed
  • The bug with caching queries performed via the ExecuteQuery method is fixed
  • The bug with .Equals(null) conditions in LINQ queries is fixed
• Entity Developer
• • Disabling facets that are not applicable to the current field type is implemented (LinqConnect models)
  • Default behaviour changed: now the Update To Database Wizard does not drop foreign keys of a table if the 'master' one is not represented in the LinqConnect model
  • The bug with saving a new solution provided that the Visual Studio option for 'Projects and Solutions -> Save new projects when created' is unchecked is fixed
  • The bug with pluralization algorithm is fixed when Naming rules are defined
  • The 'The given key was not present in the dictionary' error in the Entity Developer version integrated into Visual Studio 2010 is fixed
  • The bug with default mapping for PostgreSQL UUID columns in LinqConnect models is fixed
  • The bug with incorrect determining of association multiplicity (redundant 'many-to-many') in LinqConnect models is fixed
  • The bug with setting Extended Properties for RelationProperty is fixed
• Entity Framework support
• • The bug with executing Function Imports with enabled BatchUpdates is fixed
  • The bug with Entity Data Model Wizard when creating a model is fixed
  • The bug when PgSqlEntityProviderWorkaroundConfig.IgnoreSchemaName does not affect stored procedures is fixed

Requirements:

• PostgreSQL Compatibility
• • dotConnect for PostgreSQL supports PostgreSQL server since 7.1 version to 9.0, EnterpriseDB, Pervasive Postgres SQL servers.
• Framework Compatibility
• • The provider works with:
  • • Microsoft .NET Framework 2.0, 3.0, 3.5, 4.0
    • Microsoft .NET Compact Framework 2.0 and above
    • Mono version 2.0 and above
  • dotConnect for PostgreSQL is compatible with ADO.NET Entity Framework v1 and v4 (PostgreSQL server 8.0 or higher is required for Entity Framework).
• IDE compatibility
• • dotConnect for PostgreSQL and can be used with the following development environments:
  • • Microsoft Visual Studio 2010
    • Microsoft Visual Studio 2008
    • Microsoft Visual Studio 2005
    • Embarcadero Delphi Prism
    • CodeGear RAD Studio 2007
  • There are some limitations in Express Editions of Visual Studio. The following features are not available: provider add-in, automatic toolbox components registration and DDEX integration. As an exclusion, Visual Web Developer supports DDEX features.
  • RAD Studio 2007 is supported in run time only as these environments have no WinForms designers.
• Devart data providers compatibility
• • Since Devart data providers use a common assembly (Devart.Data.dll), it is necessary to make sure that all installed data providers are compatible.
  • dotConnect for PostgreSQL can be used together with dotConnect Universal that provides universal access to different databases within a single code.