Home / Products / ADO.NET Data Providers / dotConnect for PostgreSQL / History

dotConnect for PostgreSQL History

This page lists the functionality added in each version of dotConnect for PostgreSQL. To view the full changelog including bug fixes, consult the dotConnect for PostgreSQL revision history.

27-Jan-12 New features in dotConnect for PostgreSQL 5.70

Entity Developer

• The documentation generation for navigation properties is implemented
• The "Recreate Model" option, allowing to rebuild the model from a scratch, is added to the "Update Model From Database" wizard
• The "GeneratePartialClass" template property to generate a partial class, which will not be overwritten by the designer, for each class in the model is added
• The stored procedures support in DbContext template in case of XML mapping is implemented (Entity Framework models)
• The behaviour is changed: database column comments are transfered to the Summary attribute of the Documentation property now

Entity Framework

• Entity Framework 4.3 Beta 1 (Code First Migrations) is supported

09-Dec-11 New features in dotConnect for PostgreSQL 5.60

Entity Developer

• Capability for customizing the default Type Mapping Rules is implemented
• Capability for setting diagram options either globally for all diagram documents or separately for a particular one is implemented: the Diagram Appearance and Printing options can now be set through the Options dialog box
• Capability for setting such options as Environment, Diagram and Servers' to adjust the Entity Developer behavior, Model diagram behavior and Type Mapping Rules to your needs is implemented
• Capability for setting and defining the class property validation rules based on different engines (Data Annotation, Enterprise Library, NHibernate Validator) is added
• The HasStream attribute of entity types, used retrieve binary data as a stream via Open Data Protocol, is supported (Entity Framework models)
• The documentation generation for Enum members is implemented
• The "Detect function-based column default value" option for automatic setting StoreGeneratedPattern to Identity for corresponding columns is implemented for Entity Framework models (by default, false)
• The algorithm for forming the Navigation Properties names, when there are several FOREIGN KEY constraints between the same tables, is changed
• The behaviour is changed: the Navigation Property will not be displayed on the diagram and in Model Explorer if "Generate" is set to false for the appropriate association end
• The behaviour is changed: the Validate Max Length attribute is synchronized with the Max Length attribute of Property by default now
• The behaviour is changed: the Validate Required attribute is synchronized with the Nullable attribute of Property by default now
• The behaviour is changed: when selecting a property in the Model Explorer, the corresponding entity on the diagram does not expand if it is collapsed

Entity Framework

• The behavior of the Database.Delete code-first method is changed: the constraints are now disabled when database objects are deleted
• The config.QueryOptions.NoEscapeLike and CaseInsensitiveLike options are implemented to manage LIKE behaviour when using Linq to Entities extention methods .Contains() .EndsWith() .StartsWith()
• The generation of SQL-literals for byte array when using PostgreSQL server 9.x is supported
• The generation of SQL-literals for DateTime with fractional part of seconds is improved

06-Sep-11 New features in dotConnect for PostgreSQL 5.50

• GSS authentication is supported
• Changed behaviour: the type of 'userid' and 'roleid' columns in database schema of ASP.NET Provider Model Support is UUID now
• The possibility of using payload string for PostgreSQL version 9.0 and higher is implemented

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fluent Mapping support is added

Entity Developer

• Fluent Mapping template for LinqConnect models is added
• Support for enumerated types ("enums") in LinqConnect and Entity Framework June 2011 CTP models is implemented
• Import for selected stored procedures into the context model for Entity Framework models is implemented
• New skins to improve the apllication appearance are implemented
• Selection driven highlighting is implemented
• Capability for changing the shape color for entities, complex types and enums is implemented
• Capability for selecting the diagram skin type is implemented
• Disabling facets that are not applicable to the current field type is implemented (LinqConnect models)
• The possibility of specifying the name of the connection string to be saved in the application configuration file is implemented
• 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 default attribute mapping source for LinqConnect models is made static
• Behaviour is changed: table is not marked as "Changed" in Update Wizard if DefaultValue is set for its expression column

Entity Framework

• The possibility to turn off generation of fake updates for parent entities is implemented

17-May-11 New features in dotConnect for PostgreSQL 5.30

• DbTransactionBase class is added
• TransactionStateChanging and TransactionStateChanged events are added to the DbConnectionBase class
• Policy file for the Devart.Data.PostgreSql.Entity assembly is added
• SSPI authentication is supported
• The License Information Wizard is 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
• The support of events which occur when connections are taken and returned to pool for processing PgSqlMonitor.TraceEvent is added
• The PgSqlDump.BlockSize property is implemented to control the size of data block when making dump of large object
• The "Use schema name" and "Use catalog name" check boxes are added to DataSet Wizard

LinqConnect (formerly known as LINQ to PostgreSQL)

• Eager loading is implemented in case the related entities collection is referenced in the select clause of the query
• Fetch mode customization for eager loading of related entities is implemented
• The 'IsReference' mode of entity serialization is supported

Entity Developer

• New Templates are added:
  • LinqConnect: POCO template with XML mapping generation
  • Entity Framework: POCO template, Self-Tracking template, DbContext template with fluent mapping generation
• Templates usability is improved
• Template Editor is significantly improved
• Ability to declare additional properties for model objects is added
• Ability to specify .NET attributes for model objects is added
• The possibility to export the diagram into an image file was added
• The possibility to restrict adding the connection string information to the application configuration file is added
• The CITEXT data type is supported
• The changes in the Entity name are now preserved by Update From Database Wizard (Entity Framework models)
• The pluralization algorithm is improved when Naming rules are defined
• Runtime support for literals specified in the 'Default Value' entity field property for LinqConnect models is implemented
• The "Preserve schema name in storage" option is added

Entity Framework

• Entity Framework 4.2 June 2011 CTP is supported
• Batch Updates support is added
• Adjustable SQL Formatting for DML commands is added
• Ability to configure the NULL values inserting behaviour is added
• IgnoreSchemaName workaround (mainly for Code First) is added
• DisableQuoting workaround is added
• PgSqlFunctions.Like support (including LINQ to Entities) is added
• The PgSqlFunctions.ILike support is added
• Configurable database deletion and creation support is added
• The processing of LINQ expressions which work with literals is improved
• Processing of Edm.StartsWith, Edm.Contains, and Edm.EndsWith is improved

27-Jan-11 New features in dotConnect for PostgreSQL 5.10

• Supported Visual Studio 2010 Service Pack 1
• Added DDEX support in Express Edition
• Supported SQL Server Reporting Services x64
• Implemented possibility to include tablespace names to the table definition script when backing up schema via PgSqlDump
• Supported SSL connection to PostgreSQL server v 9.0
• Added BeginTransaction value to the MonitorEventType enum
• Implemented the DbMonitor.EventQueueLimit property which allows to set the maximal allowed number of messages waiting for being processed by the dbMonitor application
• Significantly improved performance of prepared commands execution on protocol 3.0

LinqConnect (formerly known as LINQ to PostgreSQL)

• Implemented the Attach(object entity, object original) method of the Devart.Data.Linq.ITable interface
• Implemented implicit sorting by the entity key in queries with defined LoadWith rules

Entity Developer

• Added possibility to split model into several diagrams for better handling of large models
• Implemented possibility to disable automatic recognition of many-to-many associations
• Added ConstraintSet property for Constraints in the Store part of the Entity Framework model
• Added mapping for Function Import result types (Entity Framework v4 only)
• Changed behaviour: when adding two related entities with the corresponding properties having different types, an invalid association is created now

Entity Framework

• Entity Framework 4.1 RTW supported

29-Nov-10 New features in dotConnect for PostgreSQL 5.00

• Supported Visual Studio 2010 Service Pack 1 Beta
• Implemented the LocalFailover property and ConnectionLost event of the PgSqlConnection class for processing connection problems
• Added "Transaction Scope Local" connection string option that enables the support for non-distributed transactions in the TransactionScope implementation
• Added overloads for methods of DbDataReaderBase class with column name parameter
• Improved interface in DbLoader class - added string and integer indexers
• Added the 'Validate Connection' connection string parameter to validate connection on its retrieving from pool
• Changed behaviour: when clearing the pool, the number of connections specified in 'Min Pool Size' is never removed

LinqConnect (formerly known as LINQ to PostgreSQL)

• Ability to execute DML statements in batches on SubmitChanges added
• Table Per Type inheritance supported
• Supported ASP.NET Dynamic Data with ASP.NET Dynamic Data project templates
• PLINQ support added (connection manager redesigned for thread safety)
• Supported Visual Studio Debugger Visualizer with SQL syntax highlighting for the DataQuery objects
• Implemented support for custom type arguments in LinqConnect compiled queries

Entity Developer

• Update To Database with Storage Synchronization functionality added
• Added possibility for changing the UpdateCheck property for several fields at once
• Added Update Model From Database functionality
• Added multiselect support for properties
• Improved large models handling

Entity Framework

• Entity Data Model Wizard and Update Model from Database Wizard in Visual Studio 2010 Service Pack 1 Beta supported
• Improved SQL generation for IN (Entity SQL) and Contains (LINQ to Entities) clauses

20-May-10 New features in dotConnect for PostgreSQL 4.95

• Supported password salt in ASP.NET membership provider
• Implemented capability of extending base functionality of ASP.NET providers
• Added support for Enterprise Library 5
• Added Unprepared Execute connection string parameter
• Changed the primary key of the aspnet_sessions table for ASP.NET Web providers (the ApplicationName column added)
• Implemented integration with Visual Web Developer 2008 and 2010 Express editions
• Implemented the BackupQuery method of PgSqlDump for dumping result sets
• Changed behaviour: PgSqlCursor.GetDataReader() returns a reader depending on the FetchAll and FetchSize properties of the command that returned PgSqlCursor
• Changed behaviour: removed the Database element from the PgSqlDumpObjects enumerator
• Implemented support for PgSqlLargeObject in PgSqlDump
• Implemented trimming leading spaces in fixed-length char fields when backing up data with PgSqlDump
• Added the Constraints element into the PgSqlDumpObjects enumeration
• Changed the mode of PgSqlScript execution: PgSqlScript is always executed in unprepared mode now
• Implemented host option for current process in dbMonitor
• Added possibility for tracing the distributed transactions in DBMonitor
• Added functionality for creating and using empty PgSqlArrays (CreateEmptyArray and IsEmpty methods)
• Improved Upgrade wizard
• Removed redundant queries on PgSqlDataTable.Open()

LinqConnect (formerly known as LINQ to PostgreSQL)

• LINQ to PostgreSQL support is renamed to LinqConnect
• Added support for Complex type
• Added support for different configurable algorithms for primary key generation
• Automatic configurable compiled query caching supported
• Performance improved
• Improved transaction behaviour in case when exception is thrown
• DataContext class is now CLS-Compilant
• Added implementation of the ITable interface for the Table class
• Changed DataContext.Log output format for Microsoft compatibility reasons

Entity Developer

• Added possibility of renaming associations in the model
• Added default bindings to entity fields in Insert(Update/Delete) MethodMappings
• Added validation error in case of non-supported association between Unique keys

Entity Framework

• Model First support improved
• Added more settings in Devart SSDLToPostgreSql.tt file
• DROP statements generation added
• Schema name is not generated before each object
• Added implementation for the DatabaseExists method

15-Apr-10 New features in dotConnect for PostgreSQL 4.90

• Supported Visual Studio 2010
• Install Wizard improved (ability to automatically uninstall previous version added)
• ADO.NET Data Services v1.5 CTP2 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

LINQ to PostgreSQL

• Added support for XML type
• Added support for specific dynamic expressions

Entity Framework

• Supported ADO.NET Entity Framework 4
  • Support for new Canonical aggregate and scalar functions added
  • Ability to use standard DBMS functions in LINQ queries added
  • Support for Model First (templates for DB generation) added
  • Full support for Entity Data Model Wizard/Update Wizard added
• Added support for methods creating and deleting the database (EF v1 and EF v4)

Entity Developer

• Support for ADO.NET Entity Framework 4 added
• Added possibility of renaming associations in the model
• Added validation error in case of non-supported association between Unique keys
• Support for multi-result set methods added
• Improved dialogs for editing model objects
• Full integration with Visual Studio implemented
• Added full support for ModificationFunctionMapping
• Improved Find in Model functionality
• Strongly typed reference cursors supported
• Improved One-To-One associations handling

20-Nov-09 New features in dotConnect for PostgreSQL 4.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

LINQ to PostgreSQL

• Devart DbLinqDataSource added
• Linq performance improved
• Supported navigation using properties (not only keys)

Entity Developer

• New T4 like template engine with powerful editor added
• Updated code generation
  • Ability to generate separate files for classes added
  • Entity Framework Pregenerated Views support added
  • Improved null handling code generation
• Ability to execute LINQ and Entity SQL queries with data and native sql preview added
• Ability to preview and edit data displayed in Database Explorer added
• Table splitting added (emulation of deferred loading for "large" datatypes in EF)
• OnDelete support for associations added

14-Jul-09 New features in dotConnect for PostgreSQL 4.55

• Visual Studio 2010 Beta supported
• The behavior of ConnectionTimeout corrected
• Additional SSL paremeters: SslCACert and SslKey added
• ASP.NET Web Providers: Added requiresUniqueEmail functionality

LINQ to PostgreSQL

• Added support of the String.IsNullOrEmpty() method

Entity Developer 2.20

• Advanced mapping with Entity Framework QueryView supported
• Added dialogs for suitable storage model editing
• Displaying of Navigation properties on diagram and project explorer implemented
• Ability to change properties order added
• Ability to edit Referential constraints added
• Ability to set OnDelete action added
• Ability to set Rows Affected parameter added
• Added advanced search on the model
• Added support for storing connections in the configuration files
• Added Entity Set Pluralization Naming Rule

28-Apr-09 New features in dotConnect for PostgreSQL 4.50

• Added PgSqlAlerter class to handle LISTEN/NOTIFY commands
• Supported 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

LINQ to PostgreSQL

• Supported extended errors processing
• Supported DataLoadOptions class and Include method for tuning data loading
• Supported DeferredLoadingEnable functionality
• Supported function import
• Supported stored procedures as insert/update/delete behavior
• Supported user-defined functions in selection part of a query
• Supported CreateDatabase() and DeleteDatabase() methods
• Supported SqlMethods class
• Supported returning new Dictionary from query

Entity Developer 2.00

• Supported Entity Framework
• Supported stored procedures and functions for LINQ to SQL
• Added naming rules for database objects
• Added Visual Studio integration
• Stability and performance improvements
• Validation schema improved
• Entity Framework Complex Type supported
• Entity Framework Storage Model editing supported
• Many-to-Many associations retrieving added
• Usability improvements

13-Nov-08 New features in dotConnect for PostgreSQL 4.00

• PostgreSQLDirect .NET renamed to dotConnect for PostgreSQL
• Supported LINQ to PostgreSQL
• Added Entity Developer for LINQ to PostgreSQL
• Added free Express Edition with basic connectivity features
• Supported UUID type
• Supported REF Cursors
• Support for .NET Framework 1.x is discontinued
• Renamed assemblies, namespaces, and classes (for information on upgrading your projects please refer to FAQ, section Subscriptions and Upgrades)

Entity Framework support

• The MONEY type is now mapped to System.Double
• Supported special character type "char"
• NULLs can now be used in typed expressions

20-Aug-08 New features in PostgreSQLDirect .NET 3.75

• Supported .NET Framework 3.5 Service Pack 1
• Supported Visual Studio 2008 Service Pack 1

29-May-08 New features in PostgreSQLDirect .NET 3.70

• Supported .NET Framework 3.5 Service Pack 1 Beta
• Supported Visual Studio 2008 Service Pack 1 Beta
• Improved support for ADO.NET Entity Framework

26-Feb-08 New features in PostgreSQLDirect .NET 3.50

• 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

20-Dec-07 New features in PostgreSQLDirect .NET 3.30

• Visual Studio 2008 supported
• Entity Framework Beta 3 supported
• Added Licensing Information dialog

25-Oct-07 New features in PostgreSQLDirect .NET 3.25

• .NET Entity Framework Beta 2 supported
• Visual Studio 2008 Beta 2 supported
• Added Visual Basic versions to CRM, WinForms, and Web samples

30-Aug-07 New features in PostgreSQLDirect .NET 3.20

• Supported Visual Studio codename Orcas Beta 1
• 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

13-Apr-07 New features in PostgreSQLDirect .NET 3.00

Application development enhancement

• Added DataSet Manager to control dataset instances in the project
• Added DataSet Editor for convenient datasets manipulation
• New PgSqlDataSet class to use with PgSqlDataTable
• New component DataLink added for flexible data binding
• New capabilities added to PgSqlDataTable class
• Added capability for cross-form components cooperation
• Design time visualization extended
• Supported addin and DataSet Wizard integration with Borland Developer Studio

.NET 2 features

• Added PgSqlDependency class to support Database Change Notification
• Added PgSqlDataSourceEnumerator class to support Server Enumeration feature
• Added support for Batch Update in PgSqlDataAdapter
• Added support for returning provider-specific types in PgSqlDataReader and PgSqlDataAdapter

Other features

• SQL Server 2005 Business Intelligence Solutions supported
• Added PgSqlSelectStatement class for building SELECT statements
• Added PgSqlTimeStamp class to represent TIMESTAMP and DATE types
• Added list of hosts in connection form and connection properties
• Added PgSqlLoader.LoadTable() method
• Base level classes moved to the new assembly CoreLab.Data.dll
• New demo projects added
• Added DbLoader class that serves to load external data into database
• Added PostgreSQLDirect .NET information to Visual Studio 2005 splash screen and About box

12-Dec-06 New features in PostgreSQLDirect .NET 2.55

• Windows Vista support added

17-Apr-06 New features in PostgreSQLDirect .NET 2.50

• Implemented advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SqlDataSource
• ASP.NET 2.0 providers added: Membership Provider, Profile Provider, Role Provider, Session State Provider
• DataSet Wizard added
• Enterprise Library Data Access Application Block support added
• Mono support added
• 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

20-Dec-05 New features in PostgreSQLDirect .NET 2.40

• Supported .NET Framework 2.0 release version
• Supported Visual Studio 2005 release version
• Supported PostgreSQL server 8.1 release version
• Supported Pervasive Postgres SQL server
• Compact .NET Framework 2.0 supported
• Added support for InputOutput parameters
• Precision of PgSqlInterval class increased due to bigger maximal days number

17-Oct-05 New features in PostgreSQLDirect .NET 2.20

• Composite types supported
• Tested with Mono Framework
• NULLs are not treated as empty strings on data fetch any more

01-Jul-05 New features in PostgreSQLDirect .NET 2.11

• PgSqlCommandBuilder.UpdatingFields property added
• CoreLab.PostgreSql.PgSqlLoader now inherits from CoreLab.Common.DbLoader

30-May-05 New features in PostgreSQLDirect .NET 2.10

• Support for Microsoft Visual Studio 2005 Beta 2 added
• Publisher policy file added for versions compatibility
• Performance increased
• Output parameters support added
• "DefaultValue" column in GetSchemaTable() result added

24-Jan-05 New features in PostgreSQLDirect .NET 2.00

• Support for .NET Framework 2.0 added
• Support for Microsoft Visual Studio .NET 2005 Beta 1 added
• Support for Borland Delphi 2005 added
• Added support ADO.NET 2 features including:
  • Support for metadata schemas added
  • The Base-Class-Based provider model used
  • Connection pooling enhancements functionality added, that allows you to programmatically "drain" the connection pool
  • New PgSqlConnectionStringBuilder component to build connection strings to represent data sources
• PostgreSQL 8.0 support added
• Support for transferring data in binary format added
• PgSqlInterval type added
• Performance increased due to using binary format of transferring data for protocol 3.0 and optimizing data conversion for protocol 2.0
• Support composite types(row types) result set in stored procedures
• PgSqlConnection.AutoCommit is obsolete (not supported since server version 7.4)

22-Sep-04 New features in PostgreSQLDirect .NET 1.85

• PgSqlCommand.InsertOid property added
• PgSqlException deserialization constructor added
• Support for multiple ExecuteReader added
• New component PgSqlDataTable added
• New methods for asynchronous working added
• Support for paginal access to query result added
• Support for command timeout added

07-Jul-04 New features in PostgreSQLDirect .NET 1.80

• Support for Compact Framework added
• PgSqlDataReader.HasRows property added
• Support for connection timeout added

17-May-04 New features in PostgreSQLDirect .NET 1.70

• PostgreSQL 7.4 protocol was supported
• Full PostgreSQL 7.4 error information
• Native PostgreSQL 7.4 parameters and unnamed parameters added
• Unicode property added to PgSqlConnection class
• Charset property added to PgSqlConnection class
• AutoCommit property added to PgSqlConnection class
• FetchAll property added to PgSqlCommand class
• New component PgSqlScript added
• New component PgSqlLoader added
• New component PgSqlDump added
• Connection pooling was improved
• C++ sample added

12-Feb-04 New features in PostgreSQLDirect .NET 1.51

• Support for Borland Delphi 8 added

18-Dec-03 New features in PostgreSQLDirect .NET 1.50

• PostgreSQL 7.4 support
• Support for connection pooling added
• MD5 and Crypt user authentication methods available
• GetSchemaTable with full KeyInfo added
• Batch execution of multiply SELECT statements enabled
• New structures and classes for geometric and LOB types were added
• New component PgSqlMonitor was added
• Enhanced connection editor enabled
• GetSchemaTable from multiply SELECT queries added
• Documentation integrated into Visual Studio .NET
• XML documentation for code completion added
• New sample applications added
• Support for Borland C#Builder added

15-Oct-03 New features in PostgreSQLDirect .NET 1.10

• Visual Studio .NET 2003 support added
• Property editors for PgSqlCommandBuilder.KeyFields and PgSqlCommandBuilder.UpdatingTable added
• Performance greatly improved

10-Apr-03 New First release of PostgreSQLDirect .NET