dotConnect for PostgreSQL, is an enhanced 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.
dotConnect for PostgreSQL Express will allow users to build fast and lightweight applications working with PostgreSQL.
Here are some key features of "dotConnect for PostgreSQL Express":
· Direct access to PostgreSQL server
· 100% managed code
· High performance
· Easy to deploy
· Supports the latest versions of PostgreSQL server
· All PostgreSQL data types support
· .NET Compact Framework support
· Entity Framework support
· LINQ to PostgreSQL support
· ASP.NET Provider Model support
· Operates in both connected and disconnected models
· Powerful PgSqlDataTable component as all-in-one table data access solution
· Auxiliary components for SQL scripts and bulk data transfer
· Extra data binding capabilities
· Cross-form components cooperation
· Ability of monitoring query execution
Requirements:
· NET Framework 2.0, 3.0, 3.5, and 4.0
What's New in This Release: [ read full changelog ]
· The IPv6 protocol is supported
· The PgSqlConnection.ClearAllPools(bool force) method is added
· The behaviour is changed: the Money PostgreSQL data type is mapped to System.Decimal now
· The behaviour is changed: the PgSqlDataReader.GetDateTime method returns DateTime with DateTimeKind.Local now
· The behaviour is changed: the exception message when connecting to a non-existing database is "database ... does not exist" now
· The bug with decimal array as a parameter value of PgSqlType.Numeric is fixed
· The bug with multiple execution of stored procedures returning REF CURSORs is fixed
· The bug with generating the "Stream already closed!!!" error when retrieving invalid connection from the pool is fixed
Entity Developer:
· The multiline popup editor for the Documentation.Summary property is implemented
· The bug with metadata processing in Visual Studio 11 Beta is fixed (Entity Framework models)