dotConnect for PostgreSQL

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

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.