Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

dotConnect for PostgreSQL by Devart (formerly Core Lab)

URLs: dotconnect-for-postgresql, dotconnect for postgresql, dotconnectforpostgresql, devart

Full-featured ADO.NET provider for direct access to PostgreSQL servers for Microsoft .NET Framework and .NET Compact Framework. dotConnect for PostgreSQL Data Provider supports .NET Framework with ADO.NET features. To reach high performance the provider uses a native message-based protocol for communication with the PostgreSQL server. It uses 100% managed code and doesn't require any client software. It provides extra functionality, monitoring abilities and offers advanced design-time extensions.

Overview

dotConnect for PostgreSQL is data provider to direct access to PostgreSQL database for the Microsoft .NET Framework and .NET Compact Framework. It completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology.

ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data.

dotConnect for PostgreSQL data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider.

dotConnect for PostgreSQL uses native message-based protocol for communication with PostgreSQL server. It allows to create lightweight and fast applications working with PostgreSQL

Key features:

Direct access to PostgreSQL server

Doesn't require PostgreSQL client library and uses PostgreSQL protocol directly

100% managed code

High performance

Easy to deploy

Supports the latest versions of PostgreSQL server

All PostgreSQL data types support

Composite types supported

Compact Framework support

Mono Framework support

Connection pooling feature

Fill DataSet with multiple query

PgSqlScript component to execute scripts

PgSqlLoader component for fast loading data

Paginal access to query result

Named parameters support

Ability of monitoring query execution by DBMonitor

Advanced design-time editors

Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard

Help integrated into Visual Studio .NET

Free support for registered users

Licensed per a developer without royalty fees

dotConnect for PostgreSQL supports PostgreSQL server from V7.1 to V8.0. The provider works with .NET Framework and .NET Compact Framework.

dotConnect for PostgreSQL comes in three editions: Professional, Standard and Mobile. Standard edition includes ADO.NET core classes and classes for native data types only. Professional edition includes additional classes, design-time extensions and wizards. Mobile edition is the same as Standard but works with .NET Compact Framework.

What’s new dotConnect for PostgreSQL V5.80?

Visual Studio 11 Beta support

What’s new dotConnect for PostgreSQL V5.50?

Fluent Mapping support added

The bug inserting a TPT 'child' entity in case its primary key column names differ from the 'parent' entity ones is fixed

The bug deleting dependent entities when other changes were made is fixed

The bug entity materialization for queries with multiple eager loading options is fixed

The bug saving (inserting or updating) System.Data.Linq.Binary objects is fixed

The bug creating foreign keys in SQLite databases on DataContext.CreateDatabase is fixed

Support for enumerated types ("enums") in LinqConnect and Entity Framework June 2011 CTP models is implemented

New skins to improve the apllication appearance implemented

Selection driven highlighting implemented

Capability for changing the shape color for entities, complex types and enums mplemented

Capability for selecting the diagram skin type implemented

Changed behaviour: when the FirstLetterUpperCase / FirstLetterLowerCase option is enabled in Naming rules, each letter after underscore will be capital/lower

The bug saving custom attribute properties with default values in .edml files is fixed

The bug changing property names ("Index was outside the bounds of the array") is fixed

The bug incorrect generation of the private variables names in Entity Framework models is fixed

What’s new dotConnect for PostgreSQL V5.30?

A DbTransactionBase class added

TransactionStateChanging and TransactionStateChanged events added to the DbConnectionBase class

Policy file for the Devart.Data.PostgreSql.Entity assembly added

License Information Wizard improved: it now generates licenses for projects that have Entity Framework models or refer to Devart.Data.PostgreSql.Web, but have no direct references to Devart.Data.PostgreSql.dll

"Use schema name" and "Use catalog name" checkboxes added to the DataSet Wizard

Bug fix: FormatExceptions when fetching data of the 'serial' data type

Bug fix: Membership provider compatibility between .NET Framework 2.0 and 4.0

Bug fix: launching Devart documentation via Start menu

What’s new dotConnect for PostgreSQL V5.10?

Added DDEX support in Express Edition

Fixed bug with resetting CopyLocal property of Devart references to False after using Upgrade Wizard

Fixed bug with unicode characters when using Upgrade Wizard

Fixed bug with compatibility with Microsoft Team Foundation Server 2010 Power Tools (broken designers for WPF, Silverlight, etc)

Fixed Visual Studio integration conflict with Windows Phone Developer Tools

Fixed bug with backing up composite unique keys with the PgSqlDump component

Fixed the overflow when inserting DateTime.MaxDate to the fields of the Timestamp type

Fixed bug with using the PositiveInfinity and NegativeInfinity fields of the PgSqlTimeStamp structure in Date columns

LinqConnect (formerly known as LINQ to PostgreSQL)

Fixed bug with deserializing LinqConnect exceptions

Fixed bug with attaching entities as modified to DataContext

Entity Developer

Added sorting in the 'Return Type' ComboBox for methods in the Properties window

Fixed code generation for many-to-many associations when the Unidirectional serialization mode is enabled (LinqConnect models)

Fixed some bugs in Table Per Concrete Type (TPC) design time support in Entity Framework models

Fixed bug with wrong Metadata Artifact Processing setting for Web Site projects in Entity Framework models

What’s new dotConnect for PostgreSQL V5.0?

Added the 'Validate Connection' connection string parameter to validate a connection from a pool

Fixed bug with WebSite projects in Delphi Prism

What’s new dotConnect for PostgreSQL V4.95.140?

Supports password salt in ASP.NET membership provider

Improved Upgrade wizard

Removed redundant queries on PgSqlDataTable.Open()

Fixed bug with Upgrade Wizard on web sites

Fixed bug with disposing data table with InterForm ParentRelation

Fixed bug with lost InterForm connection

Fixed NRE on executing recursive queries with MissingSchemaAction = AddWithKey

Fixed bug with changing the type of Domain fields

Fixed bug with PgSqlLoader loading floats in the text mode

Fixed bug with hashed passwords in Membership provider

Fixed bug with case-insensitivity of the PgSqlConnection.UserID property

Fixed problems with connecting to PostgreSQL databases of version 8.0 and earlier via the connection dialog

Fixed bug with PgSqlLoader.Error event on constraint violation

What’s new dotConnect for PostgreSQL V4.90.120?

Supports Visual Studio 2010

Install Wizard improved (ability to automatically uninstall previous version added)

ADO.NET Data Services v1.5 supported

Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors

Changed queries for retrieving metadata to match the escape symbols rules for PostgreSQL 8.4

What’s new dotConnect for PostgreSQL V4.65?

Integration with improved dbMonitor added

Implemented Ping method in PgSqlConnection class

Added orderid column for Site Map provider for custom map node ordering

Added some DataSet Wizard design-time improvements

Changed default behaviour of DataSet generation: if index is set as an expression, this index will be ignored

Fixed bug with MembershipProvider.GetAllUsers() method

Fixed bug with DataLink.DataSource property after regeneration of DataSet

What’s new dotConnect for PostgreSQL V4.5?

Added PgSqlAlerter class to handle LISTEN/NOTIFY commands

Now supports binary mode in PgSqlLoader

New database object types supported in PgSqlDump

Added PgSqlArray class to support PostgreSQL ARRAY data type

Added support for SSL connections

Added PgSqlLargeObject class to support PostgreSQL large objects

What’s new dotConnect for PostgreSQL V4.0x?

PostgreSQLDirect .NET renamed to dotConnect for PostgreSQL

Supported LINQ to PostgreSQL

Added Entity Developer for LINQ to PostgreSQL

What’s new dotConnect for PostgreSQL V3.7x?

Added DB server-based data paging for web applications

PgSqlDataSource design time improvements

ASP.NET demo pack added

PgSqlSelectStatement.TryParse method added

DataLink.DataSource property can refer to another DataLink component

What’s new dotConnect for PostgreSQL V3.30x?

Visual Studio 2008 supported

Entity Framework Beta 3 supported

Added Licensing Information dialog

What’s new dotConnect for PostgreSQL V3.25?

.NET Entity Framework Beta 2 supported

Visual Studio 2008 Beta 2 supported

Added Visual Basic versions to CRM, WinForms, and Web samples

Supported .NET Entity Framework

Added support for x64 architecture

Enhanced command builder with generation of row refresh statements

Added DbCommand.GetRecordCount() method to determine rows count of a request

Added INullable interface for provider specific types

Added capability to store connection strings in application settings

Extended drag'n'drop capabilities in DataSet Manager

Add-in menu moved to Visual Studio package

Demo projects reorganized

Added CRM (Customer Relationship Management) demo project

Added Ping demo project for Mobile Edition

dotConnect for PostgreSQL V2.55.24 new features:

Now supports Windows Vista

dotConnect for PostgreSQL V2.50.15 new features:

Implemented advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard,

TableAdapter configuration, Query Builder and configuring web component SqlDataSource

Mono support added

Enterprise Library Data Access Application Block support added for Professional edition

ASP.NET 2.0 providers added for Professional edition: Membership Provider, Role provider, Session State Provider, Profile provider

Borland Delphi 2006 support added

EnterpriseDB Postgre SQL Server supported

Provider invariant name changed

Added streaming support for PgSqlScript

Added list of Frequently Asked Questions

Full-featured ADO.NET provider for direct access to PostgreSQL servers for Microsoft .NET Framework and .NET Compact Framework.

Pricing: dotConnect for PostgreSQL Data Provider V5.80 - Standard Edition 1 Developer License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V5.80 - Standard Edition 1 Developer Upgrade License from V2.x Standard Edition, dotConnect for PostgreSQL Data Provider V5.80 - Standard Edition 4 Developer Team License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V5.80 - Standard Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V5.80 - Standard Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from V2.x Standard Edition - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V5.80 - Professional Edition 1 Developer License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V5.80 - Professional Edition 1 Developer Upgrade License from Standard Edition, dotConnect for PostgreSQL Data Provider V5.80 - Professional Edition 1 Developer Upgrade License from V2.x Professional Edition, dotConnect for PostgreSQL Data Provider V5.80 - Professional Edition 4 Developer Team License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V5.80 - Professional Edition 4 Developer Team Upgrade License from Standard Edition, dotConnect for PostgreSQL Data Provider V5.80 - Professional Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V5.80 - Professional Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from Standard Edition - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V5.80 - Professional Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from V2.x Professional Edition - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V5.80 - Mobile Edition 1 Developer License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V5.80 - Mobile Edition 1 Developer Upgrade License from V2.x Mobile Edition, dotConnect for PostgreSQL Data Provider V5.80 - Mobile Edition 4 Developer Team License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V5.80 - Mobile Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider Standard Subscription Renewals 1 Developer License Subscription Renewal, dotConnect for PostgreSQL Data Provider Standard Subscription Renewals 4 Developer Team License Subscription Renewal, dotConnect for PostgreSQL Data Provider Standard Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal, dotConnect for PostgreSQL Data Provider Professional Subscription Renewals 1 Developer License Subscription Renewal, dotConnect for PostgreSQL Data Provider Professional Subscription Renewals 4 Developer Team License Subscription Renewal, dotConnect for PostgreSQL Data Provider Professional Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal, dotConnect for PostgreSQL Data Provider Mobile Subscription Renewals 1 Developer License Subscription Renewal, dotConnect for PostgreSQL Data Provider Mobile Subscription Renewals 4 Developer Team License Subscription Renewal, dotConnect for PostgreSQL Data Provider Mobile Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal

Evals & Downloads: Read the dotConnect for PostgreSQL License Agreement, Download the dotConnect for PostgreSQL V5.80 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows 7, Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Component

Component Type: .NET Class, .NET Compact Framework, 100% Managed Code

Compatible Containers: MS Visual Studio 11 Beta, Microsoft Visual Studio 2010, Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, MS Visual Basic 11 Beta, Microsoft Visual Basic 2010, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, MS Visual C++ 11 Beta, Microsoft Visual C++ 2010, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, MS Visual C# 11 Beta, Microsoft Visual C# 2010, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Delphi 2006 (10.0), Delphi 2005 (9.0), Delphi 8.0, C#Builder, .NET Framework 4.5 Beta, .NET Framework 4.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Product Class: Business Components

Keywords: corelab ADO.NET direct access PostgreSQL Postgre SQL

crlab corelab

Database DB Connectivity

Database DB Management

SQL query language

Part numbers: PC-516382-449396 516382-449396 PC-516382-449422 516382-449422 PC-516382-449420 516382-449420 PC-516382-449398 516382-449398 PC-516382-449424 516382-449424 PC-516382-449402 516382-449402 PC-516382-449394 516382-449394 PC-516382-449434 516382-449434 PC-516382-449428 516382-449428 PC-516382-449430 516382-449430 PC-516382-449404 516382-449404 PC-516382-449432 516382-449432 PC-516382-449436 516382-449436 PC-516382-449400 516382-449400 PC-516382-449442 516382-449442 PC-516382-449440 516382-449440 PC-516382-449406 516382-449406 PC-516382-449408 516382-449408 PC-516382-449426 516382-449426 PC-516382-449410 516382-449410 PC-516382-449412 516382-449412 PC-516382-449438 516382-449438 PC-516382-449414 516382-449414 PC-516382-449416 516382-449416 PC-516382-449444 516382-449444 PC-516382-449418 516382-449418