dotConnect for PostgreSQL History

5.70.293 27-Jan-12

The bug with timezone retrieving by PgSqlDataReader.GetDateTimeOffset method is fixed

LinqConnect (formerly known as LINQ to PostgreSQL)

The bug with empty spaces in foreign key names generated by the CreateDatabase() method is fixed

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
The bug with resetting the Validate Required property after reopening model is fixed
The bug with generating System.ComponentModel.DataAnnotations.KeyAttribute() for Primary Key columns is fixed
The bug with a workability of documentation links on Start Page is fixed
The bug with resetting the StoreGeneratedPattern attribute by the Update Model From Database wizard is fixed (Entity Framework models)

Entity Framework support

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

5.60.283 12-Jan-12

The bug with performing an incorrect 'show bytea_output' query when activating a connection for PostgreSQL 8.4 and lower is fixed

Entity Developer

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
The bug with adding diagrams when the Notation parameter of the diagram "Property Details Level" is set to "Name And Type" is fixed
The bug with changing the Type property simultaneously for several inheritances is fixed
The bug with invalid Properties grid data refreshing for the selected attribute in the Attributes dialog box is fixed
The bug with formatting indents when generating code is fixed
The bug with saving inheritance layout on the diagram is fixed
The bug with incorrect model diagram saving after deleting a complex type from a diagram is fixed
The bug when the names of constraints in the Store part of the model are not taken into account by Generate Database Script From Model wizard is fixed (Entity Framework models)
The bug with Retrieve Data when using DbContext template is fixed (Entity Framework models)
The bug with Table Per Hierarchy (TPH) when using abstract intermediate class between the base and derived classes is fixed (Entity Framework models)

Entity Framework support

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
The bug with using slashes in string parameters of the .Contains method is fixed

5.60.268 22-Dec-11

The bug with setting the PrimaryKey attribute of DataTable.Constraints when editing an existing DataSet using DataSet Wizard is fixed

Entity Developer

The bug with Visual Basic templates is fixed
The bug with scanning the network, when setting the connection, is fixed
The bug with duplicating EntitySet attribute when using entity return type is fixed (Entity Framework models)

Entity Framework support

The bug with generating CROSS JOIN statement when using LINQ to Entities is fixed
The bug with config.DmlOptions.InsertNullBehaviour for non-EntityKey columns with initialized DefaultValue and StoreGeneratedPattern is fixed

5.60.258 08-Dec-11

The bug with redundant backslashes in text parameters of unprepared commands is fixed

LinqConnect (formerly known as LINQ to PostgreSQL)

The bug with inserting both sides of a one-to-one relationship is fixed

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 bug with code generation for foreign key fields in Entity Framework models with fluent mapping is fixed
The bug with code generation for default values of DateTime fields is fixed (LinqConnect models)
The bug with 'losing' additional diagrams when re-opening a model is fixed

Entity Framework support

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 bug with generating SQL for EdmFunction is fixed

5.50.250 24-Nov-11

Entity Developer

The bug related to Visual Studio crashes at query execution is fixed
The bug with removing associations when updating the model is fixed

Entity Framework support

The size of generated SQL is reduced by excluding redundant aliases

5.50.244 11-Nov-11

The possibility of using payload string for PostgreSQL version 9.0 and higher is implemented
The bug with bytea type when using protocol 2 is fixed
The bug with setting Port connection string parameter in Visual Studio connection editor to the value that is greater than 10000 is fixed
The bug with returning invalid connections to pool is fixed

LinqConnect (formerly known as LINQ to PostgreSQL)

The bug with updating explicitly attached entities is fixed

Entity Developer

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
The default value of the Unicode facet is changed to true for PostgreSQL CITEXT columns (LinqConnect models)
The bug with detecting whether Devart Entity Model is changed or not is fixed
The bug with setting the Concealed Function property in Stored Procedure Editor is fixed
The bug with creating an association between classes participating in a TPC inheritance hierarchy is fixed (Entity Framework models)
The bug with the local settings used for the default value of DateTime fields is fixed (LinqConnect models)
The bugs with storage synchronization for TPC inheritance classes is fixed

Entity Framework support

The bug with determining correct data types in columns of descendants in TPT and TPC hierarchies is fixed
The bug with the TimeSpan parameters is fixed
The bug with the Group By expression is fixed

5.50.237 19-Oct-11

The bug when consequent distributed transaction fails if previous TransactionScope failed is fixed
The bug with TransactionScope behaviour, when Commit() is not invoked, is fixed
The bug with connection pooling when using SSPI/GSS authentication is fixed
The bug with breaking result set of PgSqlDataReader by PgSqlConnection.Ping() method is fixed
The bug with PgSqlDump when using it with tables which have case sensitive names is fixed
The bug with license check in ILMerged assembly in Mobile Edition is fixed

LinqConnect (formerly known as LINQ to PostgreSQL)

The bug with getting wrong query from the compiled query cache is fixed
The bug with ordering results of a query with eager loading options enabled is fixed
The bug with inserting entity objects having multiple relations to other entity type with auto-generated primary key is fixed
The bug with updating navigation properties based on a composite foreign key which intersects with the primary key is fixed

Entity Developer

The possibility of specifying the name of the connection string to be saved in the application configuration file is implemented
The bug with saving the IsFlags property of enum types in Entity Framework models is fixed

Entity Framework support

The bug with config.Workarounds.DisableQuoting behaviour with checking DatabaseExists is fixed

5.50.228 29-Sep-11

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

5.50.214 06-Sep-11

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 bug with the resource file in Mobile Samples which are shipped with provider is fixed
The bug with serial columns when working with PgSqlLoader is fixed
The bug with PgSqlCommand.Cancel() is fixed
The bug with setting the Min Pool Size connection string parameter is fixed

LinqConnect (formerly known as LINQ to PostgreSQL)

Fluent Mapping support is added
The bug with inserting a TPT 'child' entity in case its primary key column names differ from the 'parent' entity ones is fixed
The bug with deleting dependent entities when other changes were made is fixed
The bug with entity materialization for queries with multiple eager loading options is fixed
The bug with saving (inserting or updating) System.Data.Linq.Binary objects is fixed

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
Changed behaviour: when the FirstLetterUpperCase / FirstLetterLowerCase option is enabled in Naming rules, each letter after underscore will be capital/lower
The bug with saving custom attribute properties with default values in .edml files is fixed
The bug with changing property names ("Index was outside the bounds of the array") is fixed
The bug with an incorrect generation of the private variables names in Entity Framework models is fixed

Entity Framework support

The possibility to turn off generation of fake updates for parent entities is implemented
The bug with constraint violation on Database.Delete is fixed
The bug with escape symbols in the query is fixed

5.30.202 11-Aug-11

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 "Offset and length were out of bounds..." bug in the Unicode mode is fixed

LinqConnect (formerly known as LINQ to PostgreSQL)

The bug with deleting dependent entities when the 'main' one is modified is fixed
The bug with update commands for Table Per Type inheritance is fixed

Entity Developer

The pluralization algorithm is improved when Naming rules are defined

Entity Framework support

The CITEXT data type is supported

5.30.196 28-Jul-11

The internal threads created by provider are named in a user-friendly way

Entity Developer

The Entity Key handling for Views in Update From Database Wizard in Entity Framework models is improved
The bug with wrong error placing in Model Explorer in Entity Framework models is fixed
The bug with regeneration of the ed:Guid attribute of navigation properties after Update From Database wizard completes is fixed (Entity Framework models)

Entity Framework support

The processing of LINQ expressions which work with literals is improved
The bug with functions returning set of record is fixed
The bug with insert into Identity single-column table is fixed

5.30.185 07-Jul-11

SSPI authentication is supported
The bug with multi value parameters in SQL Server Reporting Services is fixed
The bug with securityTrimmingEnabled option of Site Map provider is fixed

LinqConnect (formerly known as LINQ to PostgreSQL)

The bug with the 'Cannot remove an entity that has not been attached' error when using compiled queries is fixed

Entity Developer

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 changes in the Entity name are now preserved by Update From Database Wizard (Entity Framework models)
The bug with default value quotation in Entity Framework models is fixed
The bug with Primary Key naming in case of many-to-many associations in Model First is fixed (LinqConnect models)

Entity Framework support

Entity Framework 4.2 June 2011 CTP is supported
The bug with Save All for the Read Only model files in Entity Framework models is fixed

5.30.172 15-Jun-11

LinqConnect (formerly known as LINQ to PostgreSQL)

The 'IsReference' mode of entity serialization is supported
The bug with querying entity tables having no primary key is fixed
The bug with ArgumentException on accessing DataContext.Table when the TEntity class has user-defined properties is fixed

Entity Developer

The bug with Extended Properties handling is fixed
The bug with setting the multiplicity of updated constraint in Entity Framework models is fixed

Entity Framework support

The PgSqlFunctions.ILike support is added
The update functionality for default values is improved
The bug with ordering in subqueries is fixed
The bug with Default Value and the Identity columns is fixed

5.30.165 01-Jun-11

The bug with license check in ILMerged assembly is fixed
The bug with PgSqlLoader when loading data with literal carriage return is fixed
The bug with generating Insert/Update/Delete commands via TableAdapter Configuration Wizard is fixed

LinqConnect (formerly known as LINQ to PostgreSQL)

Implemented fetch mode customization for eager loading of related entities
The bug with NullReferenceException when selecting non-entity types is fixed
The bug with type mismatch when using null parameters in LINQ queries is fixed
The bug with refreshing entities with a changed entity reference is fixed
The bug with updating entities that have associations based on unique (not primary) keys is fixed
The bug with parameters of compiled queries not being refreshed is fixed

Entity Developer

The bug with configuring a sequence ID generator in LinqConnect models is fixed
The bug with LinqConnect external mapping file in case entity classes belong to non-default namespace is fixed
The bug with persisting associations between LinqConnect entity classes inherited from the same base class is fixed
The bug with Unicode symbols in template is fixed

Entity Framework support

Processing of Edm.StartsWith, Edm.Contains, and Edm.EndsWith is improved
The bug with the EndsWith method is fixed

5.30.160 17-May-11

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
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 "Use schema name" and "Use catalog name" checkboxes are added to DataSet Wizard
The bug with handled FormatExceptions when fetching data of the 'serial' data type is fixed
The bug with Membership provider compatibility between .NET Framework 2.0 and 4.0 is fixed
The bug with launching Devart documentation via Start menu is fixed

LinqConnect (formerly known as LINQ to PostgreSQL)

Implemented eager loading in case the related entities collection is referenced in the select clause of the query
The bug with incorrect operation order during SubmitChanges() calls is fixed
The bug with ArgumentExceptions thrown in background threads is fixed
The bug with using public properties when refreshing or materializing an entity is fixed
The bug with grouping a collection by a whole entity is fixed

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
Implemented runtime support for literals specified in the 'Default Value' entity field property for LinqConnect models
The "Preserve schema name in storage" option is added
The bug with code generation for the 'Delete Rule' association property in LinqConnect models is fixed
The bug with generation of attach/detach methods for many-to-many associations in LinqConnect models is fixed
The bug with external mapping for LinqConnect models is fixed
The bug with default values set via a function for string fields in LinqConnect models is fixed
The bug with the "Access" combobox of the Association editor in LinqConnect models is fixed
The bug with procedures that differ only by name in Database Explorer is fixed (Entity Framework models)

Entity Framework support

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
Configurable schema deletion and creation support is added
The bug with Entity Framework configurability is fixed

5.10.141 19-Apr-11

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
Fixed bug with locking *.key file after opening SSL connection
Fixed bug with NullReferenceException on PgSqlCommand preparation
Fixed bug with binary mode of PgSqlLoader and empty array
Fixed bug with PgSqlArray.Parse()

LinqConnect (formerly known as LINQ to PostgreSQL)

Fixed bug with invalid aliases in queries that include the UNION clause
Fixed bug with simultaneous insert of both sides of a one-to-one association when the 'master' side has auto-generated ID

Entity Framework support

Entity Framework 4.1 RTW supported

5.10.135 06-Apr-11

Fixed bug with upgrading *.cs files in App_Code folder when using Upgrade Wizard

LinqConnect (formerly known as LINQ to PostgreSQL)

Implemented the Attach(object entity, object original) method of the Devart.Data.Linq.ITable interface

Entity Developer

Fixed bug with multiplicity changing in the association editor (Entity Framework models)

5.10.126 23-Mar-11

Supported Visual Studio 2010 Service Pack 1
Fixed memory leak when executing prepared commands on the 2.0 protocol
Fixed bug with upgrading *.ascx files when using Upgrade Wizard
Fixed bug with generating no PgSqlException for an exception raised inside a stored function

LinqConnect (formerly known as LINQ to PostgreSQL)

Fixed bug with inserting 'detail' entities together with 'master' ones for one-to-one associations
Fixed bug with 'double' parameters of stored functions

Entity Developer

Changed behaviour: when adding two related entities with the corresponding properties having different types, an invalid association is created now
Fixed bug with generating incorrect code for models having one-to-one associations with a nullable property at the 'detail' side
Fixed bug with generating script with duplicate columns for entities having two fields of the same complex type

Entity Framework support

Supported Entity Framework 4.1 Release Candidate
Fixed bug with incorrect column name generation on update in case of Timestamp column having Computed StoreGenerationPattern

5.10.121 11-Mar-11

Significantly improved performance of prepared commands execution on protocol 3.0
Fixed bug with the "The message filter indicated that the application is busy" error during uninstall
Fixed bug with DataLink.Find() method

LinqConnect (formerly known as LINQ to PostgreSQL)

Implemented implicit sorting by the entity key in queries with defined LoadWith rules
Fixed bug with calling the base Devart.Data.Linq.DataContext constructor with the mapping argument

Entity Developer

Fixed bug with discarding changes in Navigation Properties names

5.10.111 24-Feb-11

Added DDEX support in Express Edition
Supported SQL Server Reporting Services x64
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

5.10.103 09-Feb-11

Fixed bug with Functions node in DataSet Wizard

LinqConnect (formerly known as LINQ to PostgreSQL)

Fixed bug with setting no reference to the Devart.Data.Linq.Web assembly when adding a DbLinqDataSource object to a web form
Fixed bug with retrieving entities participating in a many-to-many association with a composite key
Fixed bug with continuing identity tracking for deleted entities
Fixed bug with incorrect order of executing create/update/delete commands on SubmitChanges()

Entity Developer

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: classes created with the Update From Database Wizard are now added to the current diagram
Changed behaviour: the 'Update Check' is now set to 'Always' and disabled for properties that form the entity key (LinqConnect models)
Fixed bug with wrong Complex Type properties in Stored Procedures
Fixed bug with the 'Show Print Markup' button and 'Page Setup' menu item being disabled

5.10.96 27-Jan-11

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
Fixed bug with incorrect EventType passed to TraceEvent of DbMonitor
Fixed bug with backing up data with PgSqlDump from PostgreSQL servers of version 9.0
Fixed bugs with applying the 'Default Command Timeout' and 'Unprepared Execute' connection string parameters to PgSqlCommands created for this connection
Fixed bug with throwing no exceptions if an error occurs when leaving the TransactionScope environment
Fixed bug with named parameters in Data Design Extensibility (DDEX)

LinqConnect (formerly known as LINQ to PostgreSQL)

Fixed bug with repeated creation of DataContexts with external mapping
Fixed bug with many-to-many associations based on composite keys

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
Fixed bug with opening the connection dialog of the Create Model Wizard with Turkish regional settings
Fixed bug with handling errors when accessing server via an invalid connection
Fixed bug with generating code for methods returning scalar result in Entity Framework models
Fixed bug with adding associated tables from the Store part of the model to designer in Entity Framework models
Fixed bug with opening models that have invalid connection strings

Entity Framework support

Fixed bug with TruncateTime canonical function

5.00.86 12-Jan-11

Changed behaviour: setting the DbDataTable.Connection property sets the InsertCommand.Connection, UpdateCommand.Connection, and DeleteCommand.Connection properties
Fixed bug with incorrect case of data sources shown in the DataLink.DataSource property when using the Interform technology
Fixed bug with establishing SSL connections in the 'Allow' SSL mode
Fixed bug with fetching result sets from function which returns multiple cursors

LinqConnect (formerly known as LINQ to PostgreSQL)

Fixed bug with incorrect detaching entities in the master/detail association
Fixed bug with VB code generation for models with Unidirectional serialization
Fixed bug with creating DataContext using external mapping

Entity Developer

Fixed bug with many-to-many and Update From Database Wizard
Fixed bug with retrieving metadata under a user account with limited privileges
Fixed bug with using functions which return void

Entity Framework support

Added support for Entity Framework CTP 5
Improved DatabaseExists functionality

5.00.69 16-Dec-10

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
Changed behaviour: when clearing the pool, the number of connections specified in 'Min Pool Size' is never removed
Fixed bug with including database name to generated update commands for DataSets

LinqConnect (formerly known as LINQ to PostgreSQL)

Implemented support for custom type arguments in LinqConnect compiled queries
Fixed bug with redundant subqueries and Order By clauses in commands generated for entities with configured load options
Fixed bug with Visual Basic code generation for sequence-generated entity properties
Fixed bug with the DataContext.Query<TResult> method in the case when TResult is not an entity class
Fixed bug with the 'The process was terminated due to an unhandled exception' error on severely loaded applications

Entity Developer

Fixed bug with the null-reference exception when adding LinqConnect model to web site folders other than App_Code

Entity Framework support

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

5.00.58 29-Nov-10

Added the 'Validate Connection' connection string parameter to validate connection on its retrieving from pool
Fixed bug with validating connections in pool
Fixed bug with WebSite projects in Delphi Prism

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
Changed behaviour: retrieving master entity from details one now generates left outer join instead of inner join

Entity Developer

Added Update Model From Database functionality
Update To Database with Storage Synchronization functionality added
Added possibility for changing the UpdateCheck property for several fields at once
Added multiselect support for properties
Improved large models handling
Fixed bug with IndexOutOfRangeException on code generation
Fixed bug with keyword quotation in the Source property
Fixed bug with Unknown parameter direction
Fixed "Cannot find column Position" bug
Fixed bug with Visual Basic code generation for stored functions
Fixed bug with not loading Master property in Detail entity of master/details associations
Fixed bug with mapping One-to-One associations to One-to-Many
Fixed bug with Default Value in Entity Framework models
Fixed bug with SETOF functions
Fixed bug with default editor in Visual Studio
Fixed bug with associations that crash Visual Studio
Fixed bug with Guid and inheritance
Fixed 'Model is not registered' bug
Fixed bug with Retrieve Data
Fixed bug with incorrect view key generation
Fixed some bugs in Team Foundation Server support

4.95.190 04-Nov-10

Implemented integration with Visual Web Developer 2008 and 2010 Express editions
Implemented the BackupQuery method of PgSqlDump for dumping result sets

LinqConnect (formerly known as LINQ to PostgreSQL)

Improved transaction behaviour in case when exception is thrown
Fixed bug with translating the IIf method in LINQ queries
Fixed bug with custom methods in the 'select new' clause of LINQ queries
Fixed bug with not loading associated entity when LoadWith is not used

Entity Developer

Added validation error in case of non-supported association between Unique keys

Entity Framework support

Model First support improved

Added more settings in Devart SSDLToPostgreSql.tt file
DROP statements generation added
Schema name is not generated before each object

4.95.180 14-Oct-10

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
Fixed bug with generating license resource for ILMerged assembly
Fixed problem with the 'Unprepared Execute' connection parameter not influencing connections created via DbProviderFactory

LinqConnect (formerly known as LINQ to PostgreSQL)

DataContext class is now CLS-Compilant
Fixed bug with DataLoadOptions not working when object tracking is disabled
Fixed bug with second-level details loading
Fixed bug with creating compiled query using more than three parameters
Fixed bug with select queries from tables with no primary key
Fixed bug with constraint violation on inserting details before master data
Fixed bug with ArgumentException when using System.Nullable.GetValueOrDefault in Visual Basic LINQ queries
Fixed bug with incorrect marking of changed fields when using several DataContexts

Entity Developer

Added default bindings to entity fields in Insert(Update/Delete) MethodMappings
Fixed bug with serializing entities loaded using DataLoadOptions

Entity Framework support

Added implementation for the DatabaseExists method

4.95.170 23-Sep-10

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
Fixed the 'Retrieving the COM class factory for component ... failed' error during installation on x64 machines
Fixed bug with Minimal+LINQ installation
Fixed bug with Timestamp without timezone parameter when Protocol=2
Fixed bug with empty reader for the cursor returned by a stored function
Fixed bug with reusing prepared PgSqlCommand
Fixed bug with PgSqlLoaderMode.Binary mode when inserting DBNull.Value
Fixed bug with the 'Cannot insert multiple commands into a prepared statement' error when using PgSqlScript
Fixed bug with PgSqlDump backing up schema to stream
Fixed bug with casting 'char(N)' parameters to 'char'
Fixed bug with displaying Unicode characters when character set is not specified (Mobile edition)
Fixed bug with enlisting ASP.NET provider's activity to distributed transaction
Fixed bug with assertion failure on show call tree in dbMonitor

LinqConnect (formerly known as LINQ to PostgreSQL)

Fixed bug with editing Entity Key values
Fixed bug with IndexOutOfRangeException on the DeleteOnSubmit call
Fixed bug on inserting new rows into a table with many-to-many association
Fixed bug with fetching records one-by-one from the 'detail' table in master/details relation
Fixed bug with retrieving entities of an inherited type
Fixed bugs with using the Contains method of empty arrays
Fixed bug with the RejectChanges method not working
Fixed bug with structs in queries
Fixed bug with Command Timeout

Entity Developer

Fixed bug with VB Code generation for Associations
Fixed bug with Unidirectional serialization mode
Fixed design time bug with Referential constraints
Fixed bug with generating code for stored procedures with out parameters

4.95.152 28-Jul-10

Implemented capability of extending base functionality of ASP.NET providers
Added support for Enterprise Library 5
Added Unprepared Execute connection string parameter
Added functionality for creating and using empty PgSqlArrays (CreateEmptyArray and IsEmpty methods)
Changed the primary key of the aspnet_sessions table for ASP.NET Web providers (the ApplicationName column added)
Fixed bug with creating stored functions using the $ sign
Fixed bug with creating connections in Server Explorer
Fixed bug with SmallInt parameter in PgSqlCommand
Fixed bug with PgSqlDump working in the PgSqlDumpObjects.All mode
Fixed bug with DataTable in design time when using DevExpress XtraReport
Fixed bug with creating connection in Server Explorer (connections are removed after uninstall now)

LinqConnect (formerly known as LINQ to PostgreSQL)

Added implementation of the ITable interface for the Table class
Changed DataContext.Log output format for Microsoft compatibility reasons
Fixed bug with creating XmlMappingSource object when the File Per Class model property is set to true
Fixed bug with IndexOutOfRangeException on the Refresh call
Fixed bug with CompiledQueryCache
Fixed bug with InvalidCastException on selecting a new anonymous type
Fixed bug with FilePerClass and XMLMappingSource

Entity Developer

Added possibility of renaming associations in the model
Fixed bug with change tracking for inherited tables

Entity Framework support

Fixed bug with association mapping in case of inheritance

4.95.146 07-Jul-10

Fixed bug with membership provider (connection is not opened on Initialize() now)
Fixed bug with model registration in web applications
Fixed bug with PgSqlDump missing schemas on backup
Fixed bug with PgSqlDump backing up sequences
Fixed bug with connecting as a user with Unicode name

LinqConnect (formerly known as LINQ to PostgreSQL)

Improved select performance
Improved insert performance
Fixed bug with Concat()
Fixed bug with the CacheStoreReader and Cast

Entity Developer

Fixed bug with column Summary serialization
Fixed bug with Visual Basic code generation template

Entity Framework support

Fixed bug with the DevartEntityDeploy build action
Fixed bug with the unnecessary trigger and sequence generation

4.95.140 20-May-10

Supported 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

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
Fixed bug with DbLinqDataSource and RadGrid paging
Fixed bug with 'Nop' node translation
Fixed bug with empty type in specific Group By clause
Fixed bug with ArgumentNullException on DataContext.Query().Contains()
Fixed bug with Cast() method
Fixed bug with binary primary keys

Entity Developer

Fixed bug with Properties window
Fixed bug with Discriminator property drag&drop
Fixed bug on Customization window load
Fixed bug with property editor grid updating
Fixed bug with Document.Reload
Fixed bug with LINQ models on Windows XP 64-bit

Entity Framework support

Fixed bug with string concatenation
Fixed bug with data type mapping in function result set

4.90.124 15-Apr-10

Supported Visual Studio 2010

Entity Developer

Support for ADO.NET Entity Framework 4 added

Entity Framework support

Supported ADO.NET Entity Framework 4

4.90.120 31-Mar-10

Supported Visual Studio 2010 Release Candidate
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
Fixed bug with filling DevExpress ASPxGridView in Auto DataPagingMode of PgSqlDataSource
Fixed bug with creating PgSqlDataSource in Visual Studio 2008
Fixed bug with TimeStamp fields loaded by PgSqlLoader in Binary mode
Fixed bug with licensing in Visual Studio 2010 Release Candidate projects
Fixed bug with array of UDT as a PgSqlCommand parameter
Fixed bug with exception in License Information window
Fixed bug with PgSqlDataSource parameters
Fixed bug with multiple rows constraint generation

LINQ to PostgreSQL

Added support for XML type
Added support for specific dynamic expressions
Fixed bug with Refresh() method
Fixed bug with LoadWith() method
Fixed the 'Unable to cast object' problem
Fixed bug with Where() and nullable parameter
Fixed bug with multiple LoadWith() calls
Fixed bug with calling a method in the Select clause
Fixed "Cannot Refresh Entity" error
Fixed bug with UUID type
Fixed bug with nullable boolean and null comparison
Fixed "Cannot access a disposed object" error
Fixed bug with "select new"
Fixed bug with insert of autoincremented values
Fixed bug with NotImplementedException and IGrouping.Count
Fixed the problem with group by and ordering
Fixed bug with exception on the master-detail insert
Fixed bug with Int32 instead of Int64

Entity Developer

Support for ADO.NET Entity Framework 4 Release Candidate added
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
Fixed bug with different namespaces and procedure code generation
Fixed bug with Unicode facet serialization
Fixed problem with DevartEntityDeploySplit
Fixed problem with metadata resources generation
Fixed bug with App_Code subfolders
Fixed bug with Many-to-Many associations
Fixed several bugs in VB.NET code generation templates
Fixed bug with "Trial period expired" on 64-bit Windows
Fixed the "MSL Parsing failed" problem on some model opening
Fixed bug with Read Only attribute
Fixed bug with Storage attribute setting
Fixed bug with OtherKey attribute setting
Fixed bug with model opening in case of manual association edit
Fixed bug with Generate related property check box

Entity Framework support

Supported ADO.NET Entity Framework 4 Release Candidate
- 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)
Fixed bug with Returning SQL
Fixed bug with exception on Generate Database from Model
Fixed bug with EndsWith method

4.65.79 14-Jan-10

Added support of "inet" PostgreSQL type in SQL Server Data Transformation Services
Supported parameterized commands in Reporting Services
Supported stored procedures with cursors in reporting projects
Fixed bug with inability to "Copy data from one or more tables or views" in SQL Server Import and Export Wizard
Fixed bug with non-complete uninstall of dotConnect

LINQ to PostgreSQL

Added support for the UUID type
Fixed the "Destabilize the runtime" problem

Entity Developer

Fixed bug with incorrect updating of the Project Explorer root node names

Entity Framework support

Fixed bug with EntitySQL BigCount function

4.65.62 16-Dec-09

Fixed bug with empty exception message

LINQ to PostgreSQL

Changed exception type on the Single method not returning value
Fixed bug with redundant quering of the nullable association end
Fixed bug with DataContext.CommandTimeout

Entity Developer

Fixed bug with 'Generate Related property' serialization

Entity Framework support

Unprepared execution is supported

4.65.57 02-Dec-09

Entity Developer

Fixed bug with the Custom.After.Microsoft.Common.targets file appending
Fixed bug with inheritance and primary keys

4.65.54 19-Nov-09

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

LINQ to PostgreSQL

Devart DbLinqDataSource added
Linq performance improved
Supported navigation using properties (not only keys)
Fixed issue with removing entities from EntitySet
Fixed bug with EntitySet onAdd action
Fixed bug with void functions
Fixed bug with updating the detached object
Fixed the security problem in medium trust environment
Fixed bug with functions returning SETOF

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
Corrected the setting of Source and Table attribute for non-database objects
Fixed bug with attach_Entity methods
Fixed bug with access and inheritance modifiers for properties
Fixed bug with out-parameters of stored procedures
Fixed bug with LINQ to SQL code generation for out-parameters
Fixed bug with procedures returning nullable types

Entity Framework support

Fixed bug with CommandText in case of stored procedures
Fixed bug with out parameters in stored procedures

4.55.49 19-Oct-09

Added SchemaTable property to DbDataTable
Added Enlist parameter to connection string

LINQ to PostgreSQL

Fixed bug with the Attach() method
Fixed bug with updating the associated entities
Fixed the "Constant cannot be sequence" error
Fixed bug with populating DataContext.GetCommand().Parameters collection
Fixed bug with Single() method
Fixed bug with "order by" clause

Entity Developer

Fixed bug with wrong IDE configuration path
Fixed bug with VS template
Fixed bug with model placed in non-root project folder

4.55.44 24-Sep-09

Implemented Default Command Timeout property in PgSqlConnectionStringBuilder class
Fixed bugs in DataSet Wizard with Web Service projects
Fixed bug with licensing projects using wizard in nested folders of solution
Fixed bug with timestamp without time zone field value inexact retrieving
Fixed bug with SSL mode in Mobile version

LINQ to PostgreSQL

Suported DeleteOnNull attribute of association and changed default behaviour (DeleteOnNull=false now)

Entity Developer

Added support for EF Precision and Scale facets
Improved MS EDM Designer compatibility
Fixed bug with using Entity Developer in Web Site projects

Entity Framework support

Added support for Byte and SByte types
Added support for XML type
Increased performance for StartsWith, Contains and EndsWith methods

4.55.42 04-Sep-09

Unprepared query execution is supported
Fixed bug with licensing Startup projects
Fixed bug with using String.Format function computed at client side

LINQ to PostgreSQL

Fixed bug with using objects from different contexts
Fixed bug with String.IsNullOrEmpty() function

Entity Developer

Added design time support for some EF facets
Enabled adding Schema name as prefix
Fixed bug with the connection reopen on refresh

Entity Framework support

Fixed bug with non-superuser connection

4.55.39 06-Aug-09

TransactionScope supported
Added some installation command line options
Fixed bug with dotConnects and dbForge Fusion integration
Fixed bug with returning NULL instead of empty string in PgSqlCommand
Fixed the "SSL socket not connected" bug

Entity Developer

Fixed bug with Entity Set pluralization naming rule
Fixed bug with EntitySet property deserialization
Fixed bug with Source property for the added classes
Fixed bug with connection string quotation for the standalone projects
Fixed bug with the serialization of property accessors

4.55.37 14-Jul-09

Visual Studio 2010 Beta supported
The behavior of ConnectionTimeout corrected
Additional SSL paremeters: SslCACert and SslKey added
ASP.NET Web Providers: Added requiresUniqueEmail functionality
Fixed bug with DDEX when retrieving metadata from tables in PostgreSQL

LINQ to PostgreSQL

Added support of the String.IsNullOrEmpty() method
Fixed bug with nested LoadWith() methods on the query level
Fixed bug with inserting parent and several child entities in one InsertOnSubmit() when keys are db-generated
Fixed bug with the AssociateWith() method and VB.NET
Fixed several bugs with Group By clause
Fixed bug with Count()
Fixed bug with Navigation Properties

Entity Developer

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
Fixed bug with namespaces
Fixed bug with invisible OK button in Association Editor
Fixed bug with <edmx:*> tags
Fixed bug with XML Comments serialization

4.50.33 21-May-09

LINQ to PostgreSQL

Added support for DataContext.CommandTimeout property
Added support for CompiledQuery
Fixed bug with the ExecuteCommand() method
Fixed bug with Distinct and count symultaneous usage
Fixed bug with DevExpress 9 integration
Fixed bug with insertion to the table with single autoicrement column
Fixed bug with the SelectMany() method

Entity Developer

Fixed some code generation bugs

4.50.29 28-Apr-09

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
Fixed bug with OnValidate()
Fixed bug with associations based on non-Primary keys
Fixed bug with SingleOrDefault and BLOBs
Fixed bug with update of entities that declare a version member
Fixed bug with ArgumentException in the Contains() method

Entity Developer

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

4.00.26 02-Apr-09

Fixed bug with DataSet stored procedures mapping
Fixed bug with PgSqlDataTable.Load(IDataReader)
Fixed bug with serialization in C++ projects

4.00.22 16-Feb-09

Fixed bug with reading GUID values
Fixed bug with DbDataTable in WPF applications
Fixed bug with binding DbDataTable to ComboBox in Mobile Edition
Fixed bug with Detail command in DbDataSet ParentRelation

LINQ to PostgreSQL

Fixed bug with refreshing field values
Fixed bug with inserting several entities with autogenerated key

4.00.20 14-Jan-09

Fixed bug with .NET Compact Framework 3.5 support
Fixed bug with parsing command text that contains symbols @, :, and ?

Entity Framework support

Fixed bug with parameter type mapping

LINQ to PostgreSQL

Fixed bug with Table.Attach function
Fixed bug with inserting and deleting entities with an associations
Fixed bug with supporting parameters IsDbGenerated, IsVersion, UpdateCheck, CanBeNull in ColumnAttribute
Fixed bug with refreshing key fields when an association is present

4.00.16 05-Dec-08

Fixed bug with GetByte method and Integer type fields
Fixed bug with null value of EntityRef field in LINQ to PostgreSQL
Fixed bug with Queriable.Cast to interface type in LINQ to PostgreSQL
Fixed bug with submitting changes in DbDataTable on WPF
Fixed bug with duplicate column mapping
Several bugfixes in design time

Entity Framework support

Fixed bug with casting numeric values

4.00.12 13-Nov-08

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
Fixed bug with commented tables in DataSet Designer
Fixed bug with importing large amount of tables in SSIS
Fixed several bugs in DataSet Wizard

Entity Framework support

The MONEY type is now mapped to System.Double
Supported special character type "char"
Fixed bug with data retrieval in custom mapping
Fixed type mapping in models with inherited entities
NULLs can now be used in typed expressions

3.75.33 26-Sep-08

Fixed bug with UniqueConstraint generation in DataSet Wizard
Fixed bug with wrong AllowDBNull mapping in DataSet Wizard
Fixed bug with wrong Relation generation after changing column mapping

3.75.32 09-Sep-08

Fixed bug with Preview Data in DataSet and DataAdapter components when data exceeds the System.Decimal's scale

Entity Framework support

Supported views in EDM Wizard
Now objects in edmx models can be named without the database prefix
Improved object sorting and grouping in EDM Wizard

3.75.31 29-Aug-08

Fixed bug with context menu in the DataSet Manager

Entity Framework support

EDM Wizard now can work with several schemas
Supported Entity SQL canonical functions: Left, Year, Month, Hour, Minute, Second, Millisecond
Fixed bug with updating entities in concurrency mode

3.75.30 20-Aug-08

Supported .NET Framework 3.5 Service Pack 1
Supported Visual Studio 2008 Service Pack 1
Implemented GetGuid(), GetByte(), and GetChar() methods in PgSqlDataReader

Entity Framework support

Supported inserting, updating, and deleting entities with stored procedures
Supported user-defined PL/pgSQL functions that return REFCURSOR
Supported user-defined PL/pgSQL functions that return unspecified row type
Supported user-defined SQL queries as functions in SSDL
Supported Create Function Import dialog
PostgreSQL type UUID is now mapped to System.Guid
PostgreSQL type ENUM is now mapped to System.String
PostgreSQL types TIME, TIME WITH TIME ZONE, and INTERVAL are now mapped to System.TimeSpan

3.70.29 18-Jul-08

Fixed bug with connection strings from app.config and Server Explorer
Fixed bug with DataSet Wizard in Visual Studio 2008
Unified provider name in Visual Studio 2008 (Devart.Data.PostgreSql instead of Devart.Data.PostgreSql.Entity)
Fixed bug with executing queries with comments

Entity Framework support

Supported StoreGeneratedPattern attribute with values Identity and Computed (PostgreSQL version 8.2 and above)
Fixed bug with simultaneous usage of Skip() and Take() methods
Fixed type mapping in EntityKey.EntityKeyValues

3.70.28 25-Jun-08

Connection strings from web.config are now available in Visual Studio 2008 design time
Improved PgSqlDataSource design time capabilities

3.70.27 04-Jun-08

Fixed bug with dotConnect for PostgreSQL Data Provider missing in the EDM wizard
Fixed bug with inserting a row in DbDataTable when a filter is enabled

3.70.26 29-May-08

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

3.50.25 19-Mar-08

Fixed bug with licensing in Delphi for .NET and RAD Studio 2007

3.50.24 26-Feb-08

Added DB server-based data paging for ASP.NET applications
PgSqlDataSource design time improvements
ASP.NET demo pack added
PgSqlSelectStatement.TryParse method added
DataLink.DataSource property can refer to another DataLink component
Fixed bug with executing Entity Framework queries
Fixed bug with DbDataTable and some visual controls
Fixed bug with DbDataTable.FillPage method

3.30.23 20-Dec-07

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

3.25.22 13-Dec-07

Improved compatibility with PostgreSQL server version 8.3
Fixed bug with the PgSqlDataAdapter.Fill method in Mono
Fixed bug with compiling web applications in CodeGear RAD Studio 2007
Fixed bug with samples
Fixed bug with DataSet Wizard when editing standard DataSets

3.25.21 20-Nov-07

Fixed bug with PgSqlDataReader.GetSchemaTable method when executing stored functions
Fixed bug with filling DataSet using PgSqlDataAdapter with TableMappings
Fixed bug with filling DataSet asynchronously
Fixed bug with hidden columns in DataSet Wizard
Fixed bug with DataSet generator
Fixed bug with .NET Entity Framework support
Fixed bug with licensing in multithreaded applications

3.25.20 05-Nov-07

Fixed bug with schema generator for .NET Entity Framework
Fixed bug with case sensitive names in DbDataTable.ParentRelation

3.25.19 25-Oct-07

.NET Entity Framework Beta 2 supported
Visual Studio 2008 Beta 2 supported
Added Visual Basic versions to CRM, WinForms, and Web samples
Fixed bug with editing filtered and sorted DbDataTable
Fixed bug with design time editors of DbDataTable.ParentRelation
Fixed bug with editing relation resultset with DataLink
Fixed bug with building Refresh SQL when TableMappings are used
Fixed bug with editing PgSqlConnection in design time
Fixed bug with columns containing question mark
Fixed bug with serial and bigserial fields in Integration Services Project
Added scheme creation SQL statements to dump text

3.20.18 19-Sep-07

Bug with Enterprise Library missing in the installation fixed
Bug with Visual Studio 2005 integration fixed
Bug with PgSqlDataTable design time fixed
Bug with DataSet Wizard fixed
Bug with InterForm design time fixed

3.20.17 04-Sep-07

Bug with PgSqlDataTable component designer fixed

3.20.16 30-Aug-07

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

3.00.10 19-Jun-07

Bug with fetching big numeric types fixed
Bug with changing serial records
Bug with Membership.GetNumberOfUsersOnline() method fixed
Bug with MembershipUser.IsOnline property fixed

3.00.9 30-May-07

Bug with DbDataSet.ReadXml() fixed
Bug with closing IDbDataReader in DbDataTable fixed
Bug with 7.x server relations in DDEX fixed
Bug with TIMESTAMP and TIME fields on some Linux servers fixed
Bug with PgSqlDataReader.GetSchemaTable() fixed
Bug with PgSqlSelectStatement fixed
Bug with PgSqlDump.Backup() fixed

3.00.8 13-Apr-07

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 Devart.Data.dll
New demo projects added
Added DbLoader class that serves to load external data into database
Added dotConnect for PostgreSQL information to Visual Studio 2005 splash screen and About box
Bug with SQL expressions in SELECT statements fixed
Bug with creating Table Adapters with dotConnect for PostgreSQL DataSet Wizard fixed

2.55.25 01-Mar-07

Bug with using stored functions in UPDATE/DELETE/INSERT commands of TableAdapter in DataSet Designer fixed
Bug with using stored functions with unnamed parameters in Server Explorer fixed

2.55.24 25-Jan-07

Bug with installation on Vista x64 edition fixed
Bug with retrieving password in PgSqlMembershipProvider fixed
Bug with creating DataSet with tables and relations through DDEX fixed

2.55.23 12-Dec-06

Windows Vista support added

2.50.22 24-Nov-06

Bug with case-sensitive UserName, Email, ApplicationName, RoleName in Web providers fixed
Bug with removing items in PgSqlSessionStateStore provider fixed
Bug with error message when decryption key is not defined in PgSqlMembershipProvider fixed
Bug with adding a request with parameters to DataAdapter in DataSet fixed
Bug with creating Update and Delete commands for DataAdapter in DataSet fixed
Bug with reading out data in FetchAll=false mode fixed
Bug with handling broken connections in connection pool fixed

2.50.21 19-Sep-06

Data Design Extensibility (DDEX) features supported for Visual Studio 2005 Standard Edition
Fixed bug with PgSqlCommandBuilder for queries with FROM ONLY clause

2.50.20 08-Sep-06

Data Design Extensibility features included in Standard Edition of dotConnect for PostgreSQL
Fixed bug with Visual Studio integration
Fixed bug with converting NULL DateTime values
Fixed bug with connection after command timeout error

2.50.19 23-Aug-06

Fixed bug with filling DataSet with Interval type data
Fixed bug with retrieving relations in DataSet Wizard

2.50.18 04-Aug-06

Fixed bug with DataSet Wizard
Returned metadata structure for PgSqlConnection.GetSchema has been changed
Fixed bug with PgSqlDataAdapter.BatchUpdateSize initial value (was 0)
Fixed bug with infinity and -infinity DateTime values
Fixed bug with PgSqlDataReader.GetSchemaTable
Fixed bug with converting C++ samples in Visual Studio 2005
Bug with creating Table Adapters with dotConnect for PostgreSQL DataSet Wizard fixed
Bug with SQL expressions in SELECT statements fixed

2.50.17 25-Jul-06

Fixed bug with using stored functions in Data Source Wizard
Fixed bug with mapping NULL columns in parameters
Fixed bug with processing empty string fields

2.50.16 22-May-06

Bug with Initial Schema parameter in ConnectionString for .NET Framework 1.x fixed
Fixed bug with PgSqlConnection.GetSchema for "Indexes" and "Groups" arguments
Fixed bug with getting int2vector and oidvector values
Fixed bug with using stored functions in DataSource Wizard

2.50.15 17-Apr-06

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
Bug with setting empty parameter in connection string fixed
Bug with fetching oidvector values for PostgreSQL 8.0 and later fixed
Bug with finalizators fixed
Bug with licensing in Std version for .NET2 Framework fixed
Bug with .NET and .NET2 versions compatibility fixed
Bug with mixed case in database objects names fixed
Bug with parameters regenerating in PgSqlDataAdapter editor fixed
Bug with DataSet generator fixed

2.40.14 08-Feb-06

Bug with licensing fixed
Bug with PgSqlCommand.FetchSize property fixed
Fixed broken links to documentation
Incompatibility issues with .NET Framework and Mono fixed

2.40.13 20-Dec-05

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
Bug with update from NULL value in Preview Data form of DataAdapter fixed
Precision of PgSqlInterval class increased due to bigger maximal days number

2.20.12 17-Oct-05

NULLs are not treated as empty strings on data fetch any more
Bug with generating dataset schema in case of multiple columns with the same name fixed

2.20.11 12-Oct-05

Bug with generating dataset schema fixed

2.20.10 30-Sep-05

Composite types supported
Tested with Mono Framework
Bug with PgSqlConnection.GetSchema() method fixed
Bug with setting transaction isolation level fixed
Bug with updating fields with user defined types fixed
Bug with converting double type values fixed

2.11.9 29-Jul-05

Bug with generating update commands on quoted table names fixed

2.11.8 01-Jul-05

PgSqlCommandBuilder.UpdatingFields property added
Devart.Data.PostgreSql.PgSqlLoader now inherits from Devart.Common.DbLoader
Bug with reading unicode characters fixed
Bug with TEXT type column size fixed
Bug with generation update commands for geometric type columns fixed

2.10.7 08-Jun-05

Bugs with values conversion fixed

2.10.6 30-May-05

Support for Microsoft Visual Studio 2005 Beta 2 added
Publisher policy file added for versions compatibility
Bug with cross-database reference in PgSqlCommandBuilder fixed
Bug with integer values conversion in PgSqlDataReader fixed
Bug with precision in interval values fixed

2.10.5 28-Apr-05

Bug with Unicode strings for PostgreSQL 7.2 fixed
Bug with "Bit" type values fixed

2.10.4 12-Apr-05

Bug with fetching "Bit" type values in binary format fixed
Bug with getting count of bytes in PgSqlDataReader.GetBytes() method fixed
Bug with named parameters for stored procedures fixed

2.10.3 30-Mar-05

Performance increased
Output parameters support added
"DefaultValue" column in GetSchemaTable() result added
Bug with PgSqlException serialization fixed
Bug with timestamp type fixed
Bug with upper case database name fixed
Bug causing memory leaks on server fixed

2.00.2 25-Feb-05

Bug with GetSchemaTable for PostgreSQLDirect server version 7.2 fixed
Bug with numeric type conversion fixed
Bug with CommandBehavior fixed
Bug with PgSqlCommand.Prepare fixed

2.00.1 09-Feb-05

Support composite types(row types) result set in stored procedures
Bug with GetSchemaTable fixed
Bug with timestamp converting fixed
Bug with PgSqlLoader fixed
Bug with PgSqlDump fixed

2.00.0 24-Jan-05

Support for .NET Framework 2.0 added
Support for Microsoft Visual Studio .NET 2005 Beta 1
Support for Borland Delphi 2005
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
PgSqlConnection.AutoCommit is obsolete (not supported since server version 7.4)

1.85.3 07-Dec-04

Bug with quoting fixed

1.85.2 29-Nov-04

Bug with notification messages fixed
Bug with PgSqlDump.QuoteIdentifier fixed
Bug with interval types conversion fixed
PgSqlException deserialization constructor added

1.85.1 22-Oct-04

PgSqlCommand.InsertOid property added
Bug with prepared statements fixed
Bug with BLOB distortion fixed
Bug with geometry types fixed
Bug with loader fixed
Bug with type conversion fixed

1.85.0 22-Sep-04

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
Bug with connection timeout fixed

1.80.1 02-Jul-04

Bug with connection pooling fixed
Bug with component deserialization for Compact Framework fixed
Bug with timestamp types conversion fixed
Bug with connect to PostgreSQL server 7.2 fixed
Bug with special chars in command parameters fixed

1.80.0 07-Jun-04

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

1.70.0 17-May-04

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

1.51.0 12-Feb-04

Support for Borland Delphi 8 added

1.50.4 26-Jan-04

Bug with custom update commands in DataAdapter was fixed

1.50.3 22-Jan-04

Bug with Migration Wizard was fixed

1.50.2 09-Jan-04

Fixed bug with update quoted table names
Bug with update tables with multiple key fields was fixed
Database name was removed from table name inside automatic generated updates

1.50.1 23-Dec-03

Fixed bug with generating automatic updates
Bug with MD5 authentication was fixed
GetSchemaTable from multiply SELECT queries added
Fixed bug with Fill dataset from multiply SELECT queries

1.50.0 18-Dec-03

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
Documentation integrated into Visual Studio .NET
XML documentation for code completion added
New sample applications added
Support for Borland C#Builder added

1.10.4 04-Nov-03

Bug with hanging up PgSqlDataReader on attempt to call Close() method after all data was fetched fixed

1.10.3 23-Oct-03

Fixed bug with closing connection before data reader was closed
PgSqlDataReader.Close() method call not necessary if all data was fetched
Bug with insert NULL values was fixed
Bug with connection pooling was fixed
Bug with fetch large number of date datatype fields was fixed

1.10.2 15-Oct-03

Performance was greatly improved
Invalid date format bug was fixed

1.10.1 14-Jul-03

Bug with large fetch data was fixed

1.10 24-Jun-03

Visual Studio .NET 2003 support added
Property editors for PgSqlCommandBuilder.KeyFields and PgSqlCommandBuilder.UpdatingTable added

1.00 10-Apr-03

First release of dotConnect for PostgreSQL data provider