dotConnect for PostgreSQL	support@devart.com
History

8.4.193 11-Feb-25

• Fixed an issue with inserting an empty array of the INET data type
• Marked the SslCipherList property of the PgSqlConnectionStringBuilder class as obsolete for .NET Framework 4+ and .NET Standard 2.0+ assemblies. Encryption algorithms are now determined by the operating system settings

Entity Framework support

• Updated support for Entity Framework Core 9 to version 9.0.1
• Updated support for Entity Framework Core 8 to version 8.0.12
• Fixed an issue with the Unexpected ProjectionExpression implementation error in EF Core 9

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with incorrect caching of the materialization function for different queries in LinqConnect

Entity Developer

• Added the new attribute SynchronizeNullableReferenceTypes to the model settings (*.edps file) to control the synchronization of NullableReferenceType properties across different templates
• Fixed an issue with property mapping for nested types in Entity Framework models
• Fixed an issue with the Update From Database wizard falsely detecting precision and scale changes in DECIMAL or NUMERIC columns

8.4.191 14-Jan-25

• Fixed an issue with .NET Core projects in the Upgrade Wizard

Entity Framework support

• Fixed an issue with throwing MissingMethodException in EF Core 9
• Fixed an issue with a missing assembly in the Devart.Data.PostgreSql.EF6 NuGet package

Entity Developer

• Fixed an issue with the generation of complex types for stored procedures
• Fixed an issue with the Update From Database wizard failing to apply changes to the column identity/autoincrement option in model properties, impacting ValueGenerated for EF Core models and StoreGeneratedPattern for EF models
• Fixed an issue where the Update Database From Model and Generate Database Script From Model wizards did not apply the Precision and Scale options for the DECIMAL data type in PostgreSQL
• Fixed an issue that caused the "'prefix' is not declared" error in the VB.NET template of the EF Core model
• Fixed an issue with model generation that occurred when using the EF Core template extended property "Do not generate the default constructor"
• Fixed an issue that caused the 'EntityColumn does not contain a definition for UniqueKey' error in legacy custom user templates

8.4.190 27-Dec-24

• .NET 9 compatibility
• Supported PostgreSQL 17
• Supported Visual Studio 2022 version 17.13 Preview
• Added confirmation for the execution of stored procedures and functions in the DataSet Wizard
• Fixed an issue with applying the license key on Red Hat-based Linux systems (Red Hat 9, AlmaLinux 9, Rocky Linux 9) when the system-wide cryptographic policy was set to DEFAULT
• Fixed an issue with the missing Name and Owner properties in the DbCommandBase class within .NET Standard 2.0 compliant assemblies
• Fixed an issue that occurred when reading data from a multirange array

Entity Framework support

• Supported Entity Framework Core 9
• Updated support for Entity Framework Core 8 to version 8.0.11
• Updated support for Entity Framework Core 6 to version 6.0.36
• Updated support for Entity Framework 6 (EF6) to version 6.5.1
• Supported the SQL translation of TimeSpan.Milliseconds used in LINQ queries in EF Core
• Supported the SQL translation of TimeSpan.Microseconds used in LINQ queries in EF Core 8 or higher

Entity Developer

• .NET 9 has been added to the list of available Target Framework versions in the Create Model Wizard and Model Settings for EF and EF Core models
• Added the "Nullable Reference Types" property to C# Data Transfer Object templates to control whether C# 8 nullable and non-nullable reference types should be generated
• Fixed an issue with incorrect One-to-One relation multiplicity in EF Core models
• Fixed a bug with the incorrect detection of two unique indexes on the same column in the Update From Database wizard for EF Core models
• Fixed an error with code generation for stored procedures when Pluralization=Unchanged in the Model naming rules of the LinqConnect model

8.3.104 08-Nov-24

• Added support for Visual Studio 2022 version 17.12 Preview
• Fixed an issue with integration into Visual Studio 2015 and earlier versions
• Fixed the DataSet Wizard crash in Visual Studio 2022
• Fixed a design-time bug with the PgSqlDataTable Tasks interface element in Visual Studio 2022
• Fixed the behavior of returning an infinity value for timestamps

Entity Framework support

• Updated support for Entity Framework Core 8 to version 8.0.10
• Updated support for Entity Framework Core 6 to version 6.0.35
• Added support for generating LEFT JOIN LATERAL and CROSS JOIN LATERAL in EF Core LINQ when translating EF Core LINQ queries for PostgreSQL 9.3 and above
• Fixed an issue that caused the error "No coercion operator is defined between types 'System.Byte[]' and 'NetTopologySuite.Geometries.Geometry'" when using NetTopologySuite in EF Core
• Fixed a bug where UNION types could not be matched in EF Core
• Fixed an issue with creating the MigrationHistory table in EF Core when it already exists in PostgreSQL 9.1 and later

Entity Developer

• Fixed an issue where the Update From Database Wizard reset navigation property names in EF Core models

8.3.21 06-Jun-24

• Fixed an issue with the TLS certificate chain received from the remote servers like Amazon RDS for PostgreSQL / Amazon Redshift

Entity Framework support

• Updated support for Entity Framework Core 8 to version 8.0.6
• Updated support for Entity Framework Core 7 to version 7.0.20
• Updated support for Entity Framework Core 6 to version 6.0.31

8.3.20 29-May-24

• Added support for Visual Studio 2022 version 17.11 Preview
• Fixed an issue with PgSqlParameter that occurred when processing TIMESTAMP values close to DateTime.MaxValue
• Fixed an error that occurred when parsing the 'MM.dd.yyyy' date format in PgSqlTimeStamp
• Fixed an issue with ignoring the CultureInfo argument of PgSqlTimeStamp.Parse() method
• Fixed an issue with PgSqlTimeStamp.MaxValue
• Fixed an issue with reading data when UnpreparedExecute=True
• Fixed an issue causing high CPU usage in the PgSqlAlerter class
• Fixed the 'column "datlastsysoid" does not exist' error when calling PgSqlConnection.GetSchema(PgSqlMetaDataCollectionNames.Databases) for PostgreSQL 15 or higher

Entity Framework support

• Updated support for Entity Framework Core 8 to version 8.0.5
• Updated support for Entity Framework Core 7 to version 7.0.19
• Updated support for Entity Framework Core 6 to version 6.0.30
• Added support for the translation of the DateTime.Millisecond and DateTimeOffset.Millisecond properties, as well as the DateTime.AddMicroseconds() and DateTimeOffset.AddMicroseconds() methods, in LINQ queries into SQL statements in EF Core 8
• Fixed an issue with incorrect SQL translation of DateTime property comparisons in LINQ queries for EF Core 5, 6, 7, and 8

Entity Developer

• Fixed an issue with saving 'Version=Original' in the Stored Procedure Mapping menu for LinqConnect model

8.3.10 17-Jan-24

• Added compatibility with .NET 8
• Added support for Visual Studio 2022 version 17.9 Preview
• Fixed an issue with PgSqlInet.Parse()
• Fixed an issue with PgSqlArray.Parse()
• Fixed an issue with parsing DO, CREATE FUNCTION and CREATE PROCEDURE statements by PgSqlScript
• Fixed an issue with processing BYTEA data type

Entity Framework support

• Added support for Entity Framework Core 8.0.0
• Added support for Entity Framework Core 7.0.14
• Added support for Entity Framework Core 6.0.25
• Fixed an issue with string concatenation in LINQ queries in EF Core

LinqConnect (formerly known as LINQ to PostgreSQL)

• Added compatibility with .NET 8

Entity Developer

• Added EF Core 8 to the list of available Entity Framework versions in Create Model Wizard and Model Settings in EF Core Model
• Added .NET 8 to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF, EF Core, and LinqConnect models
• Added a new extended property Do Not Generate OnConfiguring Method for the model in EF Core Model
• Fixed an issue with naming of local variables in the code generated for invoking stored procedures and functions with parameters in EF Core
• Fixed an issue with unnecessary generation of the GetByKey() method in a repository for entities without primary key (QueryType=True) in EF Core
• Fixed an issue with wrongly turned on without the ability to turn off options "Detect Many-to-Many associations" and "Detect Table-Per-Type inheritances" in Model Settings of EF Core 1, 2, 3 models
• Fixed an issue with the availability of the "Table-Per-Type Hierarchy (TPT)" option in the "Model Refactoring" dialog of EF Core 1, 2, 3 models
• Fixed an issue with the availability of the "Table-Per-Concrete-Type Hierarchy (TPC)" option in the "Model Refactoring" dialog of EF Core 1, 2, 3, 5, 6 models
• Fixed the lags of Visual Studio 2022 that occurred when saving a model

8.2.0 16-Nov-23

• Added support for PostgreSQL 16
• Added support for Visual Studio 2022 version 17.8 Preview
• Fixed an issue that occurred during installation on the 32-bit version of Windows
• Fixed an issue with IPv6 host in the connection string
• Fixed an issue with unhandled NullReferenceException
• Fixed an issue with timestamp precision load in protocol v3

Entity Framework support

• Added support for Entity Framework Core 7.0.5
• Added support for Entity Framework Core 6.0.16
• Fixed an issue with incorrect SQL translation of reused LINQ query, which includes array.Contains() and other expressions, in EF Core 5/6/7
• Fixed an issue with throwing Microsoft.EntityFrameworkCore.Infrastructure.ManyServiceProvidersCreatedWarning by the UsePostgreSql(DbConnection connection) extension method of DbContextOptionsBuilder in EF Core 6 and EF Core 7
• Fixed an issue with using custom converters in mapping in EF Core 3 and higher

Entity Developer

• Fixed an issue with detecting the numeric default value of string columns as function-based column default value in EF Core Model

8.1.151 01-Jun-23

• Added support for Visual Studio 2022 version 17.7 Preview
• Fixed an issue with throwing the "Unexpected server response" error when executing INSERT into a non-existing table
• Fixed an issue in DataSet designer

Entity Framework support

• Added support for Entity Framework Core 7.0.5
• Added support for Entity Framework Core 6.0.16
• Fixed an issue with incorrect SQL translation of a reused LINQ query, which includes array.Contains() and other expressions, in EF Core 5/6/7

Entity Developer

• Changed the behavior of the primitive properties, which now by default have Inheritance Modifier = None
• Fixed an issue with the detection of non-existent changes while updating a model from a database
• Fixed an issue with creating Devart Entity Model in Visual Studio 2022
• Fixed an issue with missing model context namespace in EntityFrameworkUnitOfWork.cs produced by the Repository And Unit of Work template (C#) in EF Core
• Fixed an issue with generating incorrect scale in mapping for decimal columns by the EF Core template (Visual Basic) in EF Core 5 and higher

8.1.134 01-Mar-23

• Added support for Visual Studio 2022 version 17.5 Preview
• Added compatibility with .NET 7
• Added support for PostgreSQL 15
• Added support for сonnections to PostgreSQL 12 and higher via SSH using SHA-256/512 algorithms
• Fixed an issue with processing PgSQL block in within SQL script
• Fixed an issue with processing numeric field type
• Fixed an issue with processing inet[] field type
• Fixed an issue with processing BIT field type to BitArray

Entity Framework support

• Added support for Entity Framework Core 7.0.2
• Added support for Entity Framework Core 6.0.13
• Added support for Entity Framework Core 3.1.32
• Fixed an issue with missing the CREATE TABLE statement for __EFMigrationsHistory in EF Core 5 and EF Core 6 Migrations

Entity Developer

• Added new extended properties Do Not Generate Serializable Attribute and Do Not Serialize for complex types in EF Core Model
• Fixed an issue with applying the Generate Serializable Attributes and Serialization Library settings of the EF Core template to the generated complex types

8.0.0 30-Jun-22:

• Added compatibility with .NET 6
• Added support for macOS 11 Arm64 (or "Apple Silicon" or "Apple M1")
• Added support for Windows 11
• Added support for Visual Studio 2022 version 17.2
• Added support for Visual Studio 2022 version 17.3 Preview

Entity framework:

• Added support for Entity Framework Core 6.0.5
• Added support for Framework Core 5.0.17
• Added support for Entity Framework Core 3.1.25

Entity Developer:

• Added a 64-bit version of standalone Entity Developer application
• Added a 64-bit version of console Entity Developer application

7.24.2066 25-Jan-22

• Implemented a KeepConnected connection string parameter to determine the number of seconds of connection inactivity before the client sends a ping request
• Implemented Load Balancing: now several hosts with their ports can be specified in the Host parameter of the connection string
• Added a Target Session connection string parameter for managing Load Balancing functionality, possible values are SuppressLoadBalancing, Any, PreferStandby, PreferPrimary, Primary, Standby
• Added a TargetSession property to the PgSqlCommand class to provide the possibility to overwrite the behavior of the same option set in the connection object

Entity Developer

• Fixed an issue that occurred when mapping PostgreSQL inet and macaddr types in Entity Framework Core Model
• Changed the behavior: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code
• Changed the behavior: Devart.Data.PostgreSQL.Entity.EF5.dll compiled with .NET Framework 4.7 is used now in EF5 models

Entity Framework support

• Added a new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.EF5.dll assembly compiled with .NET Framework 4.7
• Added a new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Migrations.EF5.dll assembly compiled with .NET Framework 4.7
• Added a new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Spatials.EF5.dll assembly compiled with .NET Framework 4.7
• Fixed an issue with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core
• Fixed an issue with a materialization used within the Let operator of LINQ query in EF6
• Fixed an issue with using .Contains with a collection within .Select of LINQ query in EF Core 2
• Fixed an issue with throwing the "schema does not exist" error by Database.EnsureDeleted() in EF Core
• Fixed an issue with saving and reading string value NULL to/from HSTORE data type in PostgreSQL mapped to Dictionary<string, string> or ImmutableDictionary<string, string> or SortedDictionary<string, string> or ImmutableSortedDictionary<string, string> in EF Core 3, EF Core 5, EF Core 6

7.23.2042 21-Dec-21

• Fixed an issue with reading SSL certificates from MemCryptStorage

Entity Developer

• Improved model validation: the errors are generated for all entities with QueryType=True in EF Core Model when EF Core version=EF Core 1 in Model Settings
• Fixed an issue with wrong automatic assigning QueryType=True for views added to EF Core Model, when EF Core version=EF Core 1 in Model Settings
• Fixed an issue with throwing System.NullReferenceException when saving the changed value of the "Save connection to" option in Model Settings of EF Core Model

Entity Framework support

• Added support for Entity Framework Core 6.0.1
• Added support for Entity Framework Core 5.0.13
• Added support for Entity Framework Core 3.1.22
• Added support for the config.SpatialOptions settings in EF Core
• Added support for NetTopologySuite 2.4.0 in EF Core 3, EF Core 5, and EF Core 6
• Fixed an issue with throwing the "Expression in SQL tree does not have type mapping assigned" error with NetTopologySuite in EF Core
• Fixed an issue with generating the "Value cannot be null" error when adding or dropping FK via Code-First Migrations in EF Core

7.22.2014 09-Nov-21

• Added support for the new features of PostgreSQL Server 14:
• Multirange data types
• The database types int4multirange, int8multirange, nummultirange, datemultirange, tsmultirange, tstzmultirange can be used with the provider now
• The new members IntMultirange, BigIntMultirange, NumericMultirange, TimeStampMultirange, TimeStampTZMultirange, DateMultirange are added to the PgSqlType enum
• PgSqlReader.GetProviderSpecificValue returns provider-specific range types: PgSqlIntRange[] for int4multirange, PgSqlBigIntRange[] for int8multirange, PgSqlNumericRange[] for nummultirange, PgSqlTimeStampRange[] for datemultirange, PgSqlTimeStampTZRange[] for tsmultirange, PgSqlDateRange[] for tstzmultirange
• NaN, Infinity, -Infinity values of numeric data types generate a NotSupportedException to avoid inconsistency
• OUT parameters of stored procedures
• The start value and the current value of the sequence are saved correctly by PgSqlDump

Entity Developer

• Fixed an issue with parsing discriminator value as string, even when its type is different, in TPH inheritance of EF Core Model

Entity Framework support

• Added support for Entity Framework Core 5.0.12
• Added support for Entity Framework Core 3.1.21

7.21.2001 21-Oct-21

• Discontinued support for Visual Studio 2019 Preview support
• Fixed an issue with throwing Devart.Common.LicenseException, when Devart.Data.PostgreSql.dll is embedded into a single file application
• Fixed an issue with applying .NET Standard licensing to .NET 6 projects

Entity Developer

• Fixed an issue with launching Entity Developer after applying Windows 10 Update KB5006670 and Windows 11 Update KB5006674

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with parsing TypeName values in XML mapping generated by Visual Basic template

Entity Framework support

• Added support for Entity Framework Core 5.0.11
• Added support for Entity Framework Core 3.1.20
• Improved the implementation of config.CodeFirstOptions.TruncateLongDefaultNames in EF6 .NET Standard compliant assemblies: the generated names are constant, independent on a current domain and workstation
• Fixed an issue with using DateTime.Today, DateTime.Now, DateTime.UtcNow, DateTimeOffset.Now within LINQ query in EF Core 5

7.21.1985 28-Sep-21

Entity Developer

• Implemented a new property Validation Framework in the Data Transfer Object template for generating DataAnnotations attributes
• Added support for the Uri data type in EF Core Mode
• Implemented a new option "Save connection to" in Model Settings of EF Core Model to provide the ability to store the connection string in "Model file", "Entity Developer storage", "Environment variable"
• Added a new option "Enum Output" to the EF Core template to specify output for the generated enums
• Implemented a new property Generate UnitOfWork Repository Properties (by default, True) in the Repository and Unit Of Work template of EF Core Model for accessing the collections of entities
• Changed the representation of one-to-one association with non-nullable properties on both ends from 1 -> 1 to 0..1 -> 1 on a diagram in EF Core Model
• Fixed an issue with code generation for the Constrained option of Association Editor in the case of 0..1 -> 1 association in EF Core Model
• Fixed an issue throwing "Unknown property 'DoNotSerialize'.", when complex types and VB.NET template are used in EF Core Model

Entity Framework support

• Added support for Entity Framework Core 5.0.10
• Added support for Entity Framework Core 3.1.19
• Added support for the SQL translation of the following class members used in LINQ query in EF Core 3 and EF Core 5:
• Static method IsNullOrWhiteSpace() of the String class
• Static property Today and instance properties DayOfWeek, Ticks of the DateTime class
• Static methods Max(), Min(), Sqrt(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan() of the Math class
• Added support for the SQL translation of the following class members used in LINQ query in EF Core 5:
• Static method Parse() of the System.Net.IPAddress class
• Static method Parse() of the System.Net.NetworkInformation.PhysicalAddress class
• Static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Max(), Min(), Pow(), Sqrt(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan() of the MathF class
• Added support for the mapping of System.Decimal to PostgreSQL DECIMAL with specified precision and scale in EF Core 5
• Added support for the mapping of the PostgreSQL HSTORE data type to Dictionary, SortedDictionary, ImmutableDictionary, ImmutableSortedDictionary in EF Core 3 and EF Core 5
• Added support for the HasFilter extension on IndexBuilder in EF Core Migrations in EF Core 3 and EF Core 5
• Added support for the mapping of internet/intranet data type System.Uri to PostgreSQL TEXT in EF Core 3 and EF Core 5
• Added support for the mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to PostgreSQL INET and MACADDR/MACADDR8 in EF Core 5
• Removed the definition of System.ICloneable from .NET Framework assembly \Entity\EFCore3\Devart.Data.PostgreSql.Entity.EFCore.dll

7.20.1944 30-Jul-21

LinqConnect (formerly known as LINQ to PostgreSQL)

• Added new methods IsNotDistinctFrom() and IsDistinctFrom() to the Devart.Data.Linq.SqlMethods class

Entity Framework support

• Added support for Entity Framework Core 5.0.8
• Added support for Entity Framework Core 3.1.17

7.20.1930 08-Jul-21

• Added support for Visual Studio 2019 version 16.11 Preview 2.0
• Excluded the "WITH OIDS" clause from dump results for PostgreSQL version 12 and higher
• Fixed an issue with converting the timestamp with time zone value to DateTimeOffset by PgSqlDataReader

Entity Developer

• Changed the behavior of the Regenerate Storage and Mapping functionality in EF Core Model: the NOT NULL attribute of the column is reset to undefined now; after that, the behavior depends on the Nullable attribute of the class property only
• Fixed an issue with applying the Default Precision and Default Scale values from Model Settings to the non-decimal data types by Update To Database Wizard in EF Core
• Fixed an issue with updating TIMESTAMP WITH TIME ZONE, BOOLEAN, DOUBLE PRECISION, NUMERIC, CHARACTER(1) columns via Update To Database Wizard

Entity Framework support

• Added support for Entity Framework Core 5.0.7
• Added support for Entity Framework Core 3.1.16
• Fixed an issue with comparing enum values in EF Core 3 and EF Core 5
• Fixed an issue with .Contains and .Length in EF Core 3 and EF Core 5, when using NetTopologySuite spatial functionality

7.20.1905 03-Jun-21

• Fixed an issue with the "Failed to merge object(s). Object reference not set to an instance of an object…" error during the creation of DataSet with View objects

Entity Developer

• Added a new extended property Use Generic DbContextOptions Constructor Argument to model properties of EF Core Model
• Added a new extended property Do Not Generate Constructor With DbContextOptions Argument to model properties of EF Core Model
• Fixed an issue with generating the Equals method for entities with Record Type=True by C# EF Core template
• Fixed an issue with cleaning values of Length and Precision/Scale column's attributes by Update From Database Wizard in EF Core Model
• Fixed an issue with ignoring template's Validation Error Messages values in the generated code, when class property's Validate Expression is initialized and Validate Format is set to a non-default value
• Fixed an issue with creating app.config in Visual Studio .NET Framework projects, when the "Rewrite connection string during regeneration" option is turned off in Model Settings

Entity Framework support

• Added support for Entity Framework Core 5.0.6
• Added support for Entity Framework Core 3.1.15
• Improved the EF6 provider registration used with .NET Framework compliant assemblies: the [DbConfigurationType(typeof(PgSqlEntityProviderServicesConfiguration))] attribute set for DbContext descendant allows now calling the DbContext constructor, that accepts a connection string, with no need to register a custom IDbConnectionFactory implementation
• Fixed an issue with connection recovery after the initial connection attempt failure in EF Core

7.20.1866 09-Apr-21

Entity Developer

• Implemented a new hotkey Alt+E in Property Editor for opening Column Editor in EF Core Model
• Fixed an issue with throwing "bufferAdapter is not a VsTextDocData" when saving a model in .NET Core, .NET Standard, .NET 5, .NET 6 projects of Visual Studio 2019
• Fixed an issue with missing .NET Framework, .NET Core 1, .NET Core 2 options for the Target Framework property in Model Settings of EF Core Model in a standalone Entity Developer
• Fixed an issue with preserving Target Framework=.NET Framework in Model Settings of EF Core Model in a standalone Entity Developer

7.20.1860 01-Apr-21

• Added support for Visual Studio 2019 version 16.10 Preview
• Implemented the use of SslStream to create SSL connections for .NET Standard (.NET Core) Projects
• Added an extra mode of parameter substitution in the query in the SSIS Data Flow Source component: substitution as is, without escaping
• Fixed an issue with a DateTime variable in the SSIS Source component
• Fixed an issue with opening SSL connection to PostgreSQL Server 13 that uses password_encryption=scram-sha-256

Entity Developer

• Added .NET 6.0 to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF Core, EF6, LinqConnect models
• The new extended property Record Type is added for classes in the case of C# EF Core template to generate records instead of classes in C# 9.0 or higher and .NET 5 or higher
• The new options "Private setter for store generated properties" and "Constructor parameter" are added to Model Settings in EF Core for controlling visibility of setter for store generated properties
• The new options "Don't show this message again" in the prompt window and "Prompt before generating code when there are model validation warnings" in the menu Options are implemented in a standalone Entity Developer to provide the ability not to stop code generation by warnings
• The new extended property Do Not Generate Default Constructor is added to EF Core Model for model, classes, and complex types
• The new extended property Do Not Generate Mapping is added to EF Core Model for class properties
• The JSON (Newtonsoft.Json, Microsoft.Text.Json) and YAML (YamlDotNet) serializations are supported in EF Core (via EF Core template) and EF6 (via DbContext template):
• The new template property Serialization Library is added for specifying the library used for serialization
• The new template property Serialize Original Column Names is added for controlling the appearance of original column names in serialization
• The new template property Serialize Navigation Properties is added for controlling the appearance of navigation properties in serialization
• The new template property Serialize Null Value is added for managing the behavior of nullable properties
• The new extended property Do Not Serialize is added for properties and navigation properties to exclude them from serialization
• The new extended property Serialization Name is added for properties and navigation properties to set custom names in serialization
• The Data Transfer Object template is improved:
• The new template property Serialization Library is added for specifying library used for serialization, possible values are Data Contract, JSON (Newtonsoft.Json), JSON (Microsoft.Text.Json), YamlDotNet
• The new extended property Do Not Serialize is added for properties and navigation properties to exclude them from serialization
• The new extended property Serialization Name is added for properties and navigation properties to set custom names in serialization
• Changed the behavior: WCF Data Contract Attributes is set to False by default now
• The following properties are marked as obsolete:
• The Generate Data Contracts property of the EF Core template
• The Do Not Generate Data Contract Attribute extended property of navigation properties in EF Core Model
• The WCF Data Contract Attributes property of the DbContext and Data Transfer Object templates
• The WCF DataMember Attribute on Navigation Properties property of the DbContext and Data Transfer Object templates
• Fixed an issue with creating app.config in Visual Studio .NET Core projects
• Fixed an issue with detecting the existing classes with QueryType=True by Update From Database Wizard in EF Core Model

Entity Framework support

• Entity Framework Core 5.0.4 is supported
• Entity Framework Core 3.1.13 is supported

7.20.1836 18-Feb-21

• The new command line option /disablegac that disables adding assemblies to GAC is added
• Fixed an issue in PgSqlDependency when created a lot of dependences
• Fixed an issue with applying the "Unprepared Execute=True;" connection string parameter to the command object created with PgSqlCommand.Clone()

Entity Developer

• Changed the behavior in Entity Developer embedded into Visual Studio: lower versions in the EF Core version property of Model Settings are not hidden any more
• Changed the behavior in EF Core Model: QueryType=True is set now for all classes without PK
• C# code generation is improved: the using directives are generated instead of full namespaces in the names of attributes for DataAnnotations, NHibernate Validator, and Enterprise Library validation frameworks
• Code generation is improved: OnModelCreating(modelBuilder) of the base class is invoked now if the Base Context Type property of EF Core Model is initialized

Entity Framework support

• Entity Framework Core 5.0.3 is supported
• Entity Framework Core 3.1.12 is supported
• Fixed an issue with translating Enum.HasFlag to SQL in EF Core 3 and EF Core 5

7.20.1812 14-Jan-21

• Fixed an issue with blocking thread during retrieving a connection from the pool, when connections from the same pool are used in several threads
• Fixed an issue with inserting JSONB value via a parameter of PgSqlCommand

Entity Developer

• The new attribute DisplayName is implemented for model objects' extended properties which are available via template properties
• The new options --ContextNamespace and --DefaultNamespace are added to the Create-Model command of Console Entity Developer
• The new extended model property Base Context Type is added for specifying a parent class for the generated context in EF Core Model
• The new extended properties Base Type for complex types and Base Complex Type for model are implemented in EF Core Model
• The %type name% keyword is supported in the Base Type extended property of entities and complex types, and in Base Complex Type, Base Entity Type, Base Context Type extended model properties for setting generic base type in EF Core Model
• Code generation is improved: RelationalIndexBuilderExtensions.HasDatabaseName is generated now instead of RelationalIndexBuilderExtensions.HasName in EF Core 5
• Display names of extended properties in EF Core Model are updated: Entity Base is renamed to Base Type in class properties, Entity Base is renamed to Base Entity Type in model properties, Context Base is renamed to Base Context Type in model properties
• Fixed an issue with setting additional keyboard mapping scheme via menu Options on Windows with German display language

LinqConnect (formerly known as LINQ to PostgreSQL)

• The new property Local is added to the Table and Table<T> classes to return a collection of the entities attached to the context
• The new method GetEntityState(object entity) is added to Table class and ITable interface to return one of the EntityState values
• Fixed an issue with throwing "Bad key member '...' in association '...' of type '...'." in runtime by .NET Standard compliant assemblies

Entity Framework support

• Entity Framework Core 5.0.2 is supported
• Entity Framework Core 3.1.11 is supported
• The new metadata to describe autoincremental columns via annotations in EF Core Code-First Migrations are implemented

7.20.1792 17-Dec-20

Entity Framework support

• Entity Framework Core 5.0.1 is supported
• Fixed an issue with creating savepoints in EF Core 5

7.20.1782 03-Dec-20

• Visual Studio 2019 version 16.9 Preview is supported
• Fixed an issue with loading data into the JSONB column via PgSqlLoader in the PgSqlLoaderMode.Binary mode
• Fixed an issue with updating projects that reference EF6 provider assembly via Upgrade Wizard

Entity Developer

• The new features are supported in Entity Framework 5.0:
• TPT inheritance
• Many-to-many associations
• The new types of properties IPAddress and PhysicalAddress
• The Model Refactoring functionality is supported for classes in EF Core Model
• Changed the behavior in a standalone Entity Developer: by default the Target Framework model property in EF Core Model is set to .NET 5 instead of .NET Framework
• Fixed an issue with saving non-default value of Target Framework model property in EF6 model modified with a standalone Entity Developer
• Fixed an issue with adding new arguments at the end of argument list instead of actual position in method signature by Update From Database Wizard

Entity Framework support

• Entity Framework Core 5.0 is supported
• Entity Framework Core 3.1.10 is supported
• Changed the behavior: EF Core 3 assemblies available via NuGet package are compiled for .NET Standard 2.0 instead of .NET Standard 2.1
• Changed the behavior: EF Core 2 assemblies are no longer available via NuGet package but created in the provider installation folder
• Fixed an issue with using another context's connection in DbContextOptionsBuilder.UsePostgreSql(connection) in EF Core

7.19.1759 29-Oct-20

• PostgreSQL 13 is supported
• Changed the behavior: metadata returned by the GetSchema("Tables") and GetSchema("Columns") methods of PgSqlConnection are supplemented now with the list of Foreign tables and columns correspondingly
• Fixed an issue with Visual Studio 2019 integration, when both v16.7 RTM and v16.8 Preview are installed on the same computer
• Fixed an issue with missing Name and Owner properties of the PgSqlConnection class in .NET Standard compliant assemblies

Entity Developer

• Fixed an issue with reading templates from *.edps by console Entity Developer

Entity Framework support

• Entity Framework Core 3.1.9 is supported
• Fixed an issue with detecting FK relationship by the Scaffold-DbContext functionality in EF Core 3

7.18.1739 01-Oct-20

• Visual Studio 2019 version 16.8 Preview is supported

Entity Developer

• EF Core 3 spatial data types support is improved: in addition to Geometry and Geography, specific .NET NetTopologySuite types like GeographyPoint, GeographyLine are now available property types
• Fixed an issue with throwing "EntityProperty does not contain a definition for IsSpatialType", when custom template from previous versions is used, in EF Core Model
• Fixed an issue with applying On Delete Action=Cascade set in Association Editor to the Generate Database Script functionality in EF Core Model
• Fixed an issue with reading settings from *.edps by console Entity Developer

Entity Framework support

• Fixed an issue with throwing System.NullReferenceException by the Code-First CreateDatabase() / Code-First Migrations functionality in EF Core

7.18.1730 17-Sep-20

• The SendCallStack property is added to the Devart.Common.DbMonitor class for possibility to turn off resource-demanding logging of CallStack
• The Filter property is added to the Devart.Common.DbMonitor class for possibility to choose events being logged
• The Devart.Common.DbMonitor class is improved: now values of the DateTime parameters sent to the dbMonitor tool are supplemented with milliseconds
• Fixed an issue with updating projects in folders below the main project by Upgrade Wizard
• Fixed an issue with connecting via Amazon RDS Proxy

Entity Developer

• The error message in console Entity Developer is improved: now the text includes the list of all available templates if the specified name of template was incorrect
• Fixed an issue with saving a new model, which has never been saved before, after some time of work in a standalone Entity Developer
• Fixed an issue with generating mapping for the properties with Shadow=True in EF Core Model
• Fixed an issue with using spatial types inside complex types in EF Core Model

Entity Framework support

• Support for spatial data types in EF Core 3 is implemented
• Entity Framework Core 3.1.8 is supported
• The new NuGet package Devart.Data.PostgreSql.EFCore.NetTopolosySuite with a .NET Standard 2.1 assembly, that is compatible with .NET Core 3, is added
• The new \Entity\EFCore3\Devart.Data.PostgreSql.Entity.EFCore.NetTopolosySuite.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
• The PgSqlFunctions class, which allows using PostgreSQL-specific functions in LINQ to Entities, is supported in EF Core
• The PgSqlTextFunctions class, which allows using PostgreSQL full-text search functionality in LINQ to Entities, is supported in EF Core

7.17.1696 30-Jul-20

Entity Developer

• Fixed an issue with throwing System.NullReferenceException when opening *.edmx with invalid associations

7.17.1686 16-Jul-20

• Changed the behavior: ReadOnly=true is no longer set for all columns in PgSqlDataTable.Columns when the query joins several tables

Entity Developer

• Fixed an issue with detecting FK relationships to tables in other schemas by Create Model Wizard and Update From Database Wizard

LinqConnect (formerly known as LINQ to PostgreSQL)

• The overload of Compare() method, that accepts StringComparison as an argument, is supported
• The "Could not find element type in model" bug when loading XML mapping in .NET Standard LinqConnect assemblies
• Fixed an issue with using enums via .NET Standard compliant assemblies

Entity Framework support

• Fixed an issue with incorrect SQL generation when using .Substring() in a .Select() statement in EF Core 2

7.17.1666 17-Jun-20

• Visual Studio 2019 version 16.7 Preview is supported

Entity Developer

• .NET 5 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF6, EF Core, LinqConnect models
• The new option "Execute procedures for result set detection" is added to Model Settings of EF Core Model to control obtaining metadata of a procedure or function result set
• The new option "Use NULL parameter values" is added to Model Settings of EF Core Model to specify whether NULL parameter values are used for stored procedure execution
• The new option "Add complex types to diagram" is added to Model Settings of EF Core Model to control behavior of Create Model Wizard and Update Model From Database Wizard
• The new option "Add new complex types to the current diagram" is added to Update Model From Database Wizard of EF Core Model
• The new Primitive Default Value Generation property is added to EF, EF Core templates to determine whether to generate initialization for a primitive property based on database DEFAULT column value
• The new property Collection Property Type is added to EF template "DbContext" and EF Core template "EF Core" to determine .NET type used as a property type for the Many end of associations
• The new property Collection Initialization Type is added to EF template "DbContext" and EF Core template "EF Core" to determine .NET type used for initialization of the Many end of association; if it is set to None, then no initialization is generated
• The new property "Nullable Reference Types" is added to C# templates of EF, EF Core models to specify whether C# 8 nullable reference types and non-nullable reference types must be generated
• The new partial method is added to the OnModelCreating(DbModelBuilder modelBuilder) method generated by DbContext template of EF model
• The EF Core model deserialization is improved: Entity Developer shows the full list of detected errors and tries to load the model with invalid elements or ignores such elements if their deserialization is not possible
• Console Entity Developer improvements:
• Import of stored procedures and functions via Create-Model command is supported
• The new options --Procedures and --Functions are added to Create-Model command for filtering stored procedures and functions; by default all procedures/functions are imported
• The new option --Execute is added to Create-Model command for executing procedures/functions to get metadata from result set
• The asterisk symbol (*) is supported in --Tables and --Views parameters of Create-Model to include all objects
• Fixed an issue with opening connection via some supported providers
• Fixed an issue with enumerating values separated with comma and without whitespace in --Templates, --Schemas, --Tables parameters
• The list of keywords and reserved words of PostgreSQL being quoted by Entity Developer is updated
• The DbProviderFactories registration is implemented in Create Model Wizard for EF6 models and .NET Framework provider assemblies
• The new property Target Framework is added to Create Model Wizard and Model Settings of EF6 models
• The compatibility issue with JetBrains ReSharper
• Changed the behavior: the definition of auto-implemented property is put now on the single line with
• C# DbContext template of Devart Entity Model when ImplementINotifyPropertyChanging=False and ImplementINotifyPropertyChanged=False and PropertyChangePartialMethods=False
• C# EF Core template of Devart EF Core Model when PropertyChangeNotifiers=False and PropertyChangePartialMethods=False
• The behavior for the new EF, EF Core models is changed: Primitive Default Value Generation is set to Literal now instead of LiteralOrExpression
• Changed the behavior: the names of system types are generated without "System." prefix now in EF Core models; for example, it is DateTime instead of System.DateTime
• Changed the behavior: only one confirmation for executing stored procedure is requested by Entity Developer when drag&drop-ing procedure from Database Explorer to Model Explorer or diagram surface
• Changed the behavior: now the EF Core template generates an additional partial class for the context class when "File Per Class" and "Generate Partial Class" are set to True
• Fixed an issue with detecting strings, being expressions, as string literals when generating initialization of string properties basing on database columns' default values in EF, EF Core models
• Fixed an issue with detecting numbers, being quoted string literals, as strings when generating initialization of numeric properties basing on database columns' default values in EF, EF Core models
• Fixed an issue with missing default value in the generated code basing on DEFAULT value in a database, when any of ImplementINotifyPropertyChanging, ImplementINotifyPropertyChanged, PropertyChangePartialMethods options of DbContext template in EF is turned on
• Fixed an issue with code generation for zero-or-one to zero-or-one association in the EF6 model with the DbContext template (Fluent Mapping=True)
• Fixed an issue with generating .HasMany end of one-to-many association in EF Core Model
• Fixed an issue with generating TPH mapping in EF Core 3 model
• Fixed an issue with false appearing the "Table or view '...' has no primary key columns, and the entity key for the corresponding storage entity was calculated automatically from other fields." warning in the Error List window
• Fixed an issue with generating new Guid() with Primitive Default Value Generation=Literal in EF, EF Core models

LinqConnect (formerly known as LINQ to PostgreSQL)

• The overloads of Contains(), StartsWith(), EndsWith(), IndexOf(), Equals() methods, that accept StringComparison as an argument, are supported
• Fixed an issue with materializing elements, the types of which are explicitly converted from non-nullable to nullable on the client side
• Fixed an issue with incorrect detection of altered column comment in a many-to-many association join table by Update From Database Wizard

Entity Framework support

• Entity Framework 6.4.4 is supported
• The translation of the DateTime.AddMinutes() method in LINQ query into SQL statement in EF Core is supported
• The EF6 provider registration used with .NET Standard compliant assemblies is improved: the [DbConfigurationType(typeof(PgSqlEntityProviderServicesConfiguration))] attribute set for DbContext descendant allows now calling the DbContext constructor, that accepts a connection string, with no need to register a custom IDbConnectionFactory implementation
• Fixed an issue with adding / subtracting DateTime and TimeSpan, DateTimeOffset and TimeSpan values in LINQ query in EF Core 3
• Fixed an issue with SQL generation in EF Core 3, when enum values are used in CASE and COALESCE statements

7.17.1612 02-Apr-20

• Fixed an issue with setting multiple comma-delimited schemas via the Schema connection string parameter
• Fixed an issue with passing the PgSqlArray object with RAW element type as a parameter value

LinqConnect (formerly known as LINQ to PostgreSQL)

• The insert of the object, the type of which is an unmapped class inherited from a mapped class, is supported
• Fixed an issue with throwing System.NullReferenceException, when constructing the error saying that unmapped class is not supported

Entity Developer

• Command-line interface is implemented in a standalone Entity Developer
• The new property Context Name is added to Model Properties in EF Core Model
• The new property Target Framework is added to Model Properties in EF Core Model
• The provider registration is improved: requirement to put provider registration entry in the config file is not obligatory anymore
• Create Model Wizard is improved: now it allows installing multiple NuGet packages on the final step
• Model file tree in .NET Core / .NET Standard projects is improved: all generated code files and model files are nested under the same node in Solution Explorer

Entity Framework support

• Entity Framework Core 3.1.3 is supported
• The .ToString() call for numbers, DateTime/DateTimeOffset properties and values in LINQ queries in EF Core is supported
• The call of Convert.ToString(value) in LINQ queries in EF Core is supported

7.17.1583 20-Feb-20

• SQL Server Integration Services 2019 (SSIS 2019) is supported
• The PgSqlDataTable and PgSqlDataSet classes are supported in .NET Standard 2.0
• Changed the behavior: pool is automatically cleared when AppDomain is being closed
• Fixed an issue with initializing NHibernate configuration on .NET Standard 2.0

Entity Developer

• Fixed an issue with returning multiple result sets in code generated by the EF Core template
• Fixed an issue with detecting Identity=True for columns with synonym data type, when DetectFunctionBasedColumnDefault=True in Model Settings

Entity Framework support

• Entity Framework Core 3.1.1 is supported
• Fixed an issue with using nullable enum properties with default mapping to integers in LINQ query in EF Core 3.1
• Fixed an issue with using value converters detected automatically by .HasConversion<string>() in EF Core 3
• Fixed an issue with using NULL constant values in EF Core 3
• Fixed an issue with using binary operators AND, OR in EF Core 3

7.16.1541 23-Dec-19

• Visual Studio 2019 version 16.5 Preview is supported
• Fixed an issue with using Toolbox component PgSqlDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019
• Fixed an issue with enabling Devart DataSet Editor in Visual Studio 2017 and Visual Studio 2019

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with using Toolbox component DbLinqDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019

Entity Developer

• Fixed an issue with creating one-to-one association basing on an optional FK in EF Core Model
• Fixed an issue with code generation for oneOrZero-to-one and one-to-many associations based on an optional FK in EF Core Model
• Fixed an issue with generating a mapping for a unique constraint specified in owned type property of EF Core Model

Entity Framework support

• Entity Framework 6.4 is supported
• Entity Framework Core 3.1 is supported
• The new \Entity\EFCore3\Devart.Data.PostgreSql.Entity.EFCore.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
• The new config.CodeFirstOptions.TruncateAllLongNames option (default value is False) is added to use EF Core 2/EF Core 3 implementation for truncating long names of columns and PK/FK/IX/UX
• The config.DatabaseScript.ForeignKey.IndexCreation configuration option is supported in EF Core 1/EF Core 2/EF Core 3
• Fixed an issue with creating a unique constraint in the database via EF Core Code-First Migrations
• Fixed an issue with applying .ValueGeneratedOnAdd() to the string, guid, byte[] properties with .Key() and without .HasDefaultValueSql() in EF Core
• Fixed an issue with detecting implicit database column type, when model mapping and migration mapping are different, via EF Core Code-First Migrations
• Fixed an issue with generating SQL when using explicit cast in LINQ queries in EF Core 1/EF Core 2
• Fixed an issue with throwing the "Null TypeMapping in Sql Tree" error by methods in LINQ query in EF Core 3

7.15.1519 21-Nov-19

• The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Editor
• Fixed an issue with using PgSqlArray of the Varchar type as a command parameter, when connection string includes "UnpreparedExecute=True;"

Entity Developer

• The Self-Contained Entity Configuration property is added to VB.NET version of EF Core template
• The Entities Configuration Output property is added to VB.NET version of EF Core template
• The code generation for the class properties with Alternate Key=True by VB.NET version of EF Core template is supported in EF Core model
• Fixed an issue with code generation, when Raw SQL Query is initialized in class properties, in EF Core 3 model
• Fixed an issue with generating .HasNoKey(), when Self-Contained Entity Configuration is set to True in properties of EF Core template, in EF Core 3 model
• Fixed an issue with generating alternate keys, when Self-Contained Entity Configuration is set to True in C# version of EF Core template, in EF Core model

Entity Framework support

• The SQL generation in case of config.QueryOptions.UseCSharpNullComparisonBehavior=true in EF1/EF4/EF5/EF6 is improved
• Fixed an issue with using Scaffold-DbContext in EF Core 3
• Fixed an issue with the redundant empty ORDER BY clause in a subquery, when paging is used, in EF Core 3
• Fixed an issue with using .Contains within .Select of LINQ query in EF Core 2
• Fixed an issue with generating invalid SQL when calling members of owned type in EF Core 2

7.15.1504 31-Oct-19

• Visual Studio 2019 version 16.4 Preview is supported

Entity Developer

• The DbContext template is improved: precision and scale for database types are generated now in EF4/EF5/EF6 models when Fluent Mapping=True and Mapping Generation Strategy=UseAttributes
• Fixed an issue with throwing the EntityFrameworkCoreVersion error in Create Model Wizard in a standalone Entity Developer

Entity Framework support

• Entity Framework Core 2.2.6 is supported
• Fixed an issue with optimistic concurrency implementation in EF Core

7.15.1499 24-Oct-19

• PostgreSQL 12 is supported
• The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Manager
• Fixed an issue with inserting data into GEOMETRY columns
• Fixed an issue with updating TEXT columns in UTF8 databases

Entity Developer

• The DbContext template is improved for using Entity Framework 6.3:
• The "Configuration Type Name" property, which specifies the descendant of DbConfiguration class that should be used for code-based configuration, is added
• The "Use DbConfigurationType Attribute" property, which determines whether to register the configuration type specified in the ConfigurationTypeName property of the DbConfigurationType attribute, is added
• The DbProviderFactories.RegisterFactory method is generated when UseDbConfigurationTypeAttribute=true and ConfigurationTypeName='%Default%'
• With UseDbConfigurationTypeAttribute=false, the static constructor for registering factory and the new partial method OnStaticConfigured are generated
• The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported
• The compatibility issue with JetBrains ReSharper

Entity Framework support

• Entity Framework Core 3.0 is supported
• Entity Framework 6.3 is supported
• The lock for Microsoft.EntityFrameworkCore dependency is added to the NuGet package Devart.Data.PostgreSql.EFCore
• Fixed an issue with invoking DbFunctions with the DateTime and DateTimeOffset parameters

7.14.1470 12-Sep-19

• The integration with Visual Studio 2019 is improved: now the installation detects both 2019 Release and 2019 Preview versions
• Fixed an issue with throwing System.NullReferenceException instead of actual error in Workflow Foundation

Entity Developer

• Entity Framework 6.3 Preview 9 is supported for projects with target framework .NET Core 3 or .NET Standard 2.1
• Changed the behavior: a plural form of names ending with "s" now has a longer version (for example, status -> statuses)
• Fixed an issue with applying the new Foreign Key's Delete Rule values SET DEFAULT and SET NULL by the Update Database From Model and Update Model From Database wizards (Entity Framework)
• Fixed an issue with copying a property with Primary Key=True / Entity Key=True to a complex type (Entity Framework)
• Fixed an issue with naming of a composing unique key by Create Model Wizard / Update From Database Wizard in EF Core (Entity Framework)
• Fixed an issue with invalid attempt to cast unsupported Visual Studio project to type 'VSLangProj.VSProject'

Entity Framework support

• Entity Framework 6.3 Preview 9 is supported
• A new NuGet package Devart.Data.PostgreSql.EF6 with a .NET Standard 2.1 assembly, compatible with .NET Core 3, is added
• Fixed an issue with using the same database connection in several EF Core contexts
• Fixed an issue with applying a value converter to .Where expression with .Contains on nullable enum in EF Core 2
• Fixed an issue with casting the DateTimeOffset value passed to a function as an argument in EF6

7.13.1437 25-July-19

Entity Framework support

• Fixed an issue with applying a value converter to a nullable column in EF Core 2
• Fixed an issue with using DbFunctions.TruncateTime in EF6

7.13.1422 04-July-19

• Fixed an issue with throwing "Operation is not supported" by web providers, when the cookie is used

Entity Developer

• The ability to disable generation of the byte order mark (BOM) in the beginning of code files in a standalone Entity Developer is implemented
• Fixed an issue with design time copy/cut/paste functionality for entities
• Fixed an issue with invalid integer to enum conversion by a generated method, which is based on SQL query and returns a collection of entities, in EF Core 2

Entity Framework support

• Fixed an issue with applying a filter to the nullable property with implicit EnumToStringConverter via LINQ queries in EF Core 2
• Fixed an issue with missing brackets around SELECT inside the generated CASE statement in EF Core 2
• Fixed an issue with nullable parameters in EF Core 2
• Fixed an issue with reopening connections in EF Core 2

7.13.1402 06-Jun-19

• Deprecated design-time Synchronous API calls are no longer used with Visual Studio 2019 and Visual Studio 2017
• Changed the behavior: now PgSqlDataAdapter performs inserts in a batch with protocol 3 when the UpdateBatchSize property is used and UnpreparedExecute is true for InsertCommand
• Fixed an issue with missing schema name in a function return type when the function is backed up via PgSqlDump.Backup
• Fixed an issue with creating foreign key constraints before primary key constraints in a PgSqlDump.Backup result script
• Fixed an issue with adding timestamp(6) instead of timestamp to a PgSqlDump.Backup result script
• Fixed an issue with connecting to a PostgreSQL server on Google Cloud Platform

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with running stored procedure in PostgreSQL Server 11 or higher
• Fixed an issue with executing incorrect SQL request (cached during one of the previous calls), when a variable initialized with an empty collection participates in LINQ query

Entity Framework support

• Entity Framework Core 2.2.4 is supported
• Fixed an issue with closing database connection by context.Dispose() in the scope of a distributed transaction in EF Core 2
• Fixed an issue with using a value converter, when the .NET data type remains the same, within the WHERE clause in EF Core 2

7.13.1366 11-Apr-19

• Visual Studio 2019 is supported

Entity Developer

• Fixed an issue with processing DBNull returned by the function in EF Core

Entity Framework support

• The performance of Entity Data Model Wizard when retrieving foreign keys metadata is improved
• Fixed an issue with using the "Generate Database from Model" wizard when working with Entity Framework 6 Tools

7.12.1357 28-Mar-19

• Visual Studio 2019 Release Candidate 4 is supported
• Fixed an issue with corrupting not Latin-1 characters by Migration Wizard for files with non-unicode encoding

Entity Framework support

• Entity Framework Core 2.2.3 is supported
• The translation of DateTimeOffset literal into SQL statement is supported
• The SQL translation of the following method overloads, that accept the StringComparison argument and return bool, in the System.String class is supported in EF Core 2: Contains, StartsWith, EndsWith, Equals
• Fixed an issue with removing an empty __EFMigrationsHistory table by EnsureDeleted() in EF Core 2 for PostgreSQL 9.0 and higher
• Fixed an issue with generating the COALESCE expression in EF Core
• Fixed an issue with calling DbExecutionStrategy.ShouldRetryOn(Exception), when the first connection fails to open

7.12.1328 14-Feb-19

• Fixed an issue with PgSqlLoader.LoadTable(IDataReader) for .NET Standard 1.3 and .NET Standard 2
• Fixed an issue with applying Convert.IsDBNull() to PgSqlParameter.Value

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with executing incorrect SQL request (cached during one of the previous calls), when .Contains() is invoked in the multithreaded application

Entity Developer

• Fixed an issue with generating fluent mapping for the one-to-one association by the DbContext template in EF4/EF5/EF6

Entity Framework support

• The translation of single-char literal into SQL statement in EF Core is supported
• Fixed an issue with SQL generation, when optionsBuilder.UseLoggerFactory() is used, in EF Core
• Fixed an issue with using a value converter for the property used in .Contains() in EF Core 2
• Fixed an issue with translating String.IndexOf() into SQL statement in EF Core
• Fixed an issue with updating a null value of the concurrency check column with some non-null value in EF Core

7.12.1307 10-Jan-19

• PostgreSQL 11 is supported
• Fixed an issue with connecting to database with .NET Standard 1.3 compatible assemblies on .NET Framework 4.6.0 run-time

LinqConnect (formerly known as LINQ to PostgreSQL)

• The new overload DataContext.Refresh(bool ignoreErrors, RefreshMode mode, object entity) is added for ignoring errors during refresh
• The existing overload DataContext.Refresh(RefreshMode mode, object entity) is improved: its check avoids the try to refresh the entity that is added to the context but not submitted to the database
• The type and text of the error generated by the DataContext.Refresh(RefreshMode mode, object entity) method, when the passed entity doesn't exist in database

Entity Developer

• The multiple select functionality in EF Core Model is improved: now it allows setting PrimaryKey, ValueGenerated, Concurrency for several properties simultaneously
• Fixed an issue with detecting order of columns in composite primary key with two or more columns by Update To Database and by Update From Database wizards in EF Core
• Fixed an issue with using ASP.NET Core Web Application (.NET Framework) and Azure Functions v1 (.NET Framework) projects in Visual Studio 2017

Entity Framework support

• Entity Framework Core 2.2.1 is supported
• The new extension method Database.IsPostgreSql() in EF Core 2 is implemented
• Fixed an issue with applying config.Workarounds.IgnoreSchemaName=true to the .ToTable() functionality in EF Core 2
• Fixed an issues with using the GuidToStringConverter, EnumToStringConverter, ValueConverter classes in EF Core 2 are fixed
• Fixed an issue with constructing the LIKE clause in EF Core 2
• Fixed an issue with generating a subselect within the SELECT list in EF Core 2
• Fixed an issue with applying an aggregate function to the result of a subselect in EF Core 2

7.11.1278 29-Nov-18

• Fixed an issue with calculating a time zone in case of "(UTC-08:00) Pacific Time (US & Canada)"

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with throwing "Operation could destabilize the runtime." during materialization of result set, when query includes a cast to the base unmapped class

Entity Developer

• The new Generate GeneratedCode Attributes option (by default, False) is added to the DbContext template in EF4/EF5/EF6 and the EF Core template
• The new Generate Dummy Comments option (by default, False) is added to the DbContext template in EF4/EF5/EF6
• The code formatting in the DbContext template in EF4/EF5/EF6 and the EF Core template
• The code generation of DateTime.Now for the DateTime property mapped to the column with the default value NOW() is supported in EF and EF Core
• The code generation of DateTimeOffset.Now for the DateTimeOffset property mapped to the column with the default value NOW() is supported in EF and EF Core
• Fixed an issue with generating fluent mapping for the TPC inheritance by VB.NET version of DbContext template in EF4/EF5/EF6

Entity Framework support

• The PgSqlFunctions.Unaccent method is implemented to provide accent insensitive search
• Fixed an issue with quoting the table alias, that includes an invalid character, in the SQL query generated by EF Core
• Fixed an issue with generating a subquery within the IN clause in EF Core 2
• Fixed an issue with generating a subselect within the CASE clause in EF Core 2
• Fixed an issue with comparing columns, that use a value converter, to parameters and constants in EF Core 2
• Fixed an issue with loading both Devart.Data.PostgreSql.Entity.EF4.dll and Devart.Data.PostgreSql.Entity.EF5.dll in the process of EF4 application

7.11.1253 25-Oct-18

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with updating the existing entities that participate in FK associations in .NET Standard 2 compliant assemblies

Entity Developer

• Fixed an issue with throwing "Custom tool error: bufferAdapter is not a VsTextDocData" in .NET Standard projects
• Fixed an issue with adding references to the provider assemblies when creating Entity Framework 5 model

Entity Framework support

• Entity Framework Core 2.1.4 is supported
• The bit-wise functions OR, AND in EF Core are supported
• Fixed an issue with throwing "Collection was modified; enumeration operation may not execute" by EF Core provider in multithreaded applications
• Fixed an issue with applying explicit name of FK within CREATE TABLE in EF Code-First Migrations

7.11.1229 20-Sep-18

• Fixed an issue with absent Devart.Data.PostgreSql.NHibernate.NHibernatePgSqlConnection and Devart.Data.PostgreSql.NHibernate.NHibernatePgSqlCommand classes in the .Net Core NuGet package

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with applying LEFT JOIN LATERAL in the generated SQL

Entity Developer

• Using an extended property of type OutputInfo is supported
• Code generated for nullable properties is simplified: now T? is generated instead of System.Nullable<T>
• An additional constructor that accepts DbContextOptions as an argument is added to the DbContext class descendant in the VB.NET version of the DbContext template for EF Core
• Fixed an issue with "No database provider has been configured for this DbContext." in the DbContext template for EF Core
• Fixed an issue with code generation for nullable properties for EF1/EF4/EF5/EF6

Entity Framework support

• Entity Framework Core 2.1.3 is supported
• Fixed an issue with throwing an error by context.Database.Migrate(), when the __EFMigrationsHistory table already exists but tables being mapped by model classes are not created yet, in EF Core 2
• Fixed an issue with a memory leak in EF Core 2, when a connection is set for DbContext as an PgSqlConnection instance, and not via a connection string
• Fixed an issue with creating database objects in the same schema by several EF Core contexts in Code-First approach against PostgreSQL 9.0 and earlier

7.11.1216 30-Aug-18

Entity Developer

• Fixed an issue with setting password as clear text in connection string when "Persist Security Info=False;"
• Fixed an issue with creating and opening the model in .NET Core project after VS 2017 upgrade to v15.8 (Entity Framework, LinqConnect)

Entity Framework support

• Entity Framework Core 2.1.2 is supported
• The misleading "The current provider does not support ambient transactions." warning, generated by TransactionScope in EF Core 2.1, is disabled
• Fixed an issue with the DropPrimaryKey operation, when the schema name of a table is set via a separate Schema parameter, in EF Core Code-First Migrations
• Fixed an issue with using Scaffold-DbContext against multicolumn PK, FK, IX, UX in EF Core 2

7.11.1202 09-Aug-18

• Fixed an issue with missing comments on schemas, tables and columns when performing a backup with PgSqlDump
• Fixed an issue with missing IMMUTABLE and STRICT attributes in function declarations when performing a backup with PgSqlDump
• Fixed an issue with missing OUT attribute in function declarations when performing a backup with PgSqlDump
• Fixed an issue with missing quotes for column names with upper case characters when performing a backup with PgSqlDump

Entity Developer

• Fixed an issue with detecting order of columns in composite primary key by Update Model From Database Wizard in EF Core

Entity Framework support

• The new static method SetDefault is added to the EntitySpatialServices class in EF5/EF6
• The performance in case of the CROSS APPLY/OUTER APPLY operations is improved: only one database query is sent to the server now instead of many SELECTs with executing part of operations locally
• Changed the behavior: the default value of config.QueryOptions.UseCSharpNullComparisonBehavior is true now in EF Core
• Fixed an issue with using the RenameIndex operation, when index name exceeds a max length allowed by the server and has to be transformed to a shorter name, in EF Core Code-First Migrations
• Fixed an issue with incorrect generation of shortened PK/FK/IX/UX names in EF Core when using .NET Standard provider assemblies
• Fixed an issue with SQL generation for comparing column with parameter in EF Core 2

7.11.1190 19-Jul-18

• The IDbColumnSchemaGenerator interface and the PgSqlDataReader.GetColumnSchema() method are implemented in .NET Standard provider assemblies
• The performance of the SSIS Lookup component is improved due to using one IN clause instead of many OR clauses
• Fixed an issue with throwing the "Socket.IOControl handles Windows-specific control codes and is not supported on this platform." error by .NET Standard compliant assemblies on Linux and MacOS
• Fixed an issue with reading an array of cursors as an array of strings
• Fixed an issue with PgSqlScript execution when it includes declarations of blocks, quoted with dollar signs
• Fixed an issue with not backing up column length via the PgSqlDump.Backup method

Entity Framework support

• Fixed an issue with paging in EF Core 2.1
• Fixed an issue with using the aggregate functions in EF Core 2.1
• Fixed an issue with processing arguments of functions mapped via .HasDbFunction in EF Core 2
• Fixed an issue with applying a filter with implicit EnumToStringConverter via LINQ queries in EF Core 2
• Fixed an issue with using the String.CompareTo method via LINQ queries in EF Core

7.11.1172 21-Jun-18

• SSH connections are supported
• SSL is supported in .NET Standard 2.0 provider assemblies
• The PgSqlDependency class is supported in the .NET Standard 1.3 version of provider assemblies
• The Unknown value is added to the Severity enum
• The SeverityMessage property is added to the PgSqlException and PgSqlError classes for returning a severity message
• The following static properties ServerMessageSeverityError, ServerMessageSeverityFatal, ServerMessageSeverityPanic, ServerMessageSeverityWarning, ServerMessageSeverityNotice, ServerMessageSeverityDebug, ServerMessageSeverityInfo and ServerMessageSeverityLog are added to PgSqlLocalization

Entity Developer

• Entity Framework Core 2.1 is supported
• Query type support is added: classes now have the Query Type property, and if it is set to true, this class is generated as a query type
• Lazy loading for Entity Framework Core 2.1 is supported:
• Model now has the Use Lazy-Loading Proxies property, which enables lazy loading on the model level
• Navigation properties now have the Lazy property, which enables lazy loading for a specific navigation property
• Properties now have the Constructor Parameter property, for configuring a parameterized constructor of the class
• The "Include Environment Variables" property, determining whether context configuration will be extended with environment variables when a connection string from the appsettings.json file is used, is added to the EF Core template
• The "Json File Base Path" property, specifying the base path for file-based providers when a connection string from the appsettings.json file is used, is added to the EF Core template

Entity Framework support

• Entity Framework Core 2.1.1 is supported
• Fixed an issue with delimiting statements with Batch Updates in EF Core 2
• Fixed an issue with applying the updated provider behavior after changing connection string options in EF Core 2
• Fixed an issue with generating incorrect SQL when using IndexOf expression in EF Core

7.10.1152 24-May-18

LinqConnect (formerly known as LINQ to PostgreSQL)

• A destructor for DataContext is added

Entity Framework support

• Entity Framework Core 1.1.5 is supported
• Entity Framework Core 2.0.3 is supported
• The generation of the idempotent script in EF Core 2 Code-First Migrations for PostgreSQL 9.0 and higher is supported
• The DeleteDatabaseBehaviour.Database value of the config.DatabaseScript.Schema.DeleteDatabaseBehaviour option in EF Core 2 is supported
• Fixed an issue with using EnsureSchema in EF Core against PostgreSQL 9.2 and earlier, if schema names should be quoted when the schema exists but the required tables are missing
• Fixed an issue with missing Devart.Data.PostgreSql.Entity namespace in *.Designer.cs generated by EF Core 2 Code-First Migrations via Devart NuGet package
• Fixed an issue with generating command separators in the EF Core 2 Code-First Migrations script

7.10.1134 27-Apr-18

• Fixed an issue with opening connection by .NET Standard 2.0 compliant assemblies on Linux

Entity Developer

• The new Controller Area extended class property is added to EF Core Model (Entity Framework models)
• The check of conditions for setting optionsBuilder.Use... in the generated OnConfiguring method by the EF Core template is improved (Entity Framework models)

Entity Framework support

• Fixed an issue with retrieving the DateTimeOffset and TimeSpan data in EF Core

7.10.1115 29-Mar-18

• Changed the behavior: the License Key connection string parameter value is not sent to the dbMonitor instance when "Persist Security Info=false;"
• Fixed an issue with reading several resultsets by a DataReader with CommandBehavior.SequentialAccess
• Fixed an issue with throwing the "IDE not supported" exception by DataSet Manager in Visual Studio 2017 of versions 15.6.*

LinqConnect (formerly known as LINQ to PostgreSQL)

• The XmlMappingSource.FromResource method is supported in .NET Standard provider assemblies
• Changed the behavior: all existing overloads of the method DataContext.Query() are replaced with DataContext.Query(String,params Object[])
• Changed the behavior: the License Key connection string parameter value is not sent to the LinqMonitor instance when "Persist Security Info=false;"
• Fixed an issue with mapping a function that returns REFCURSOR

Entity Developer

• The new SQL Type, Size, Precision, Scale options are added to the Parameters tab in Method Editor of EF Core Model (Entity Framework models)
• The process of synchronizing methods and parameters with database stored procedures in EF Core Model is improved (Entity Framework models)
• Fixed an issue with adding entry to appsettings.json, when "Use the following connection string from App.Config" and "Rewrite connection string during regeneration" in Model Settings are turned on (Entity Framework models)
• Fixed an issue with throwing the "Multiple constructors accepting all given argument types have been found in type '...'. There should only be one applicable constructor." error by the code generated with the MVC Controller template in ASP.NET Core Web Application (Entity Framework models)
• Fixed an issue with missing DataMember attribute on the Many end of an association, when using the EF Core template with "Generate Data Contracts=True" (Entity Framework models)
• Fixed an issue with the Retrieve Data functionality on the base class of TPH inheritance
• Fixed an issue with the Find Next functionality of T4 Editor embedded into Visual Studio
• Fixed an issue with throwing the "IDE not supported" exception by Entity Developer in Visual Studio 2017 of versions 15.6.*

Entity Framework support

• Entity Framework Core 2.0.2 is supported

7.10.1086 15-Feb-18

• Fixed an issue with connecting to nonunicode PostgreSQL Servers via .NET Standard provider assemblies
• Fixed an issue with using PgSqlAlerter in .NET Core projects

LinqConnect (formerly known as LINQ to PostgreSQL)

• The generation of CROSS JOIN LATERAL and LEFT JOIN LATERAL when connecting to PostgreSQL Server 9.3 or higher is supported
• Fixed an issue with throwing MethodAccessException by .NET Standard provider assemblies when referencing them to a project, targeting Full .NET Framework

Entity Developer

• Identity columns in PostgreSQL 10 are supported
• Support for ASP.NET Core MVC is added to the Data Annotations Metadata template (Entity Framework models)
• Fixed an issue with applying the DevartEFCoreGenerator custom tool in Visual Basic .NET Core projects (Entity Framework models)

7.10.1061 11-Jan-18

• SQL Server Data Tools (SSDT) 2017 is supported - SSIS projects only
• The type of the Offset and Length properties of the ScriptProgressEventArgs class is changed from Int32 to Int64
• The type of the Offset and Length properties of the RestoreProgressEventArgs class is changed from Int32 to Int64
• Fixed an issue with System.Security.Cryptography.CryptographicException in Mono
• Fixed an issue with using composite type INOUT parameter

Entity Developer

• The ModelNameAsFilesPrefix property is implemented in the RepositoryAndUnitOfWork template
• Support for ASP.NET Core MVC is added to the MVC Controller template (Entity Framework models)
• The code generation for async method calls in the EF Core template is improved (Entity Framework models)
• Changed the behavior: a base class in TPT Inheritance is allowed to be abstract now (LinqConnect models)

Entity Framework support

• Entity Framework Core 1.1.4 is supported
• Entity Framework Core 2.0.1 is supported
• Fixed an issue with opening connections, when talking to several non-existing databases, in EF Core
• Fixed an issue with ignoring the maxLength, precision, scale property settings by update-database in EF Core
• Fixed an issue with using enumerations in EF Core model
• Fixed an issue with LIKE (.StartsWith/.Contains./EndsWith)
• Fixed an issue with case-insensitive comparison

7.10.1031 23-Nov-17

• The CancelEditRowIfUpdateFailed property, determining whether to call CancelEdit for the row after update of the row is failed when data binding is used, is added to PgSqlDataTable

LinqConnect (formerly known as LINQ to PostgreSQL)

• The performance of generating complex queries is improved
• Fixed an issue with exceeding a length of duplicated column aliases in the generated SQL

Entity Developer

• The new "Detect function-based column default value" option is implemented in Model Settings of EF Core model
• The code generation for async method calls is added to the EF Core template
• The usage of long identifiers (up to 140 symbols) for naming model objects is supported

Entity Framework support

• Entity Framework 6.2 is supported
• The SQL generation for subselects, when using Distinct(), in EF1/EF4/EF5/EF6 is optimized
• The identity columns in PostgreSQL 10 are supported in Entity Data Model Wizard (classic EF) and in Scaffold-DbContext (EF Core)
• The config.DatabaseScript.Schema.EnsureSchemaBehaviour option is added for controlling behaviour of the EnsureSchema operation in EF Core
• The Code-First Migrations functionality in EF Core is improved:
• the operations InsertData / UpdateData / DeleteData (introduced in EF Core 2), EnsureSchema (creates schema if not exists), DropSchema (removes schema), CreateSequence, AlterSequence, RestartSequence are supported
• Fixed an issue with using UsePostgreSql(DbConnection) extension method of DbContextOptionsBuilder in EF Core
• Fixed an issue with using collections in a .Contains() method in EF Core 2
• Fixed an issue with JOIN conditions in SQL generated from LINQ query in EF1/EF4/EF5/EF6
• Fixed an issue with using multiple .Include() in EF Core 2
• Fixed an issue with processing conditions in LINQ queries with joins in EF Core

7.10.1013 30-Oct-17

• .NET Standard 2.0 is supported
• .NET Standard 2.0 compatible assemblies are added to the Devart.Data and Devart.Data.PgSql NuGet packages
• Distributed transactions are supported
• The PgSqlDataAdapter and PgSqlCommandBuilder are implemented
• The PgSqlConnection.GetSchema() and PgSqlDataReader.GetSchemaTable() methods for metadata retrieving are implemented
• The PgSqlDependency class is implemented
• The PgSqlDataSourceEnumerator class is implemented
• The PgSqlDump class is implemented
• Dynamic columns creation in the PgSqlLoader class is implemented
• Component classes in .NET Standard 2.0 compatible assemblies are inherited from the Component class, and some of them implement the ICloneable and ISupportInitialize interfaces
• Some of the classes, representing data types, now implement the INullable and ISerializable interfaces
• .NET Core 2.0 is supported
• PostgreSQL 10 is supported
• Fixed an issue with a master-detail relation when a select command in the child table has a WHERE or ORDER BY clause

LinqConnect (formerly known as LINQ to PostgreSQL)

• .NET Standard 2.0 is supported
• .NET Core 2.0 is supported
• The macaddr8 data type introduced in PostgreSQL 10 is supported
• Fixed an issue with .Union().Any()

Entity Developer

• .NET Standard 2.0 projects in Visual Studio 2017 are supported
• .NET Core 2.0 projects in Visual Studio 2017 are supported
• Entity Framework Core 2.0 is supported
• The Retrieve Data functionality via Model Explorer for EF Core 2 is implemented
• The macaddr8 data type introduced in PostgreSQL 10 is supported
• Fixed an issue with escaping invalid XML characters in the comments generated by templates

Entity Framework support

• Entity Framework Core 1.1.3 is supported
• Entity Framework Core 2.0 is supported
• The macaddr8 data type introduced in PostgreSQL 10 is supported

7.9.980 06-Sep-17

• The integration with Visual Studio 2017 is improved: the installation is now silent, without VSIX Installer prompt window

Entity Developer

• The Devart Visual Studio packages registration into Visual Studio 2017 is improved: the packages are now available for all Windows accounts
• Fixed an issue with losing Toolbar and docking customizations of a standalone designer during reinstall

Entity Framework support

• Fixed an issue with using a variable with null value in LINQ query in EF Core

7.9.958 03-Aug-17

Entity Developer

• The new Raw SQL Query class property and SQL method property with the corresponding editors are implemented in Entity Framework Core
• Fixed an issue with generating code for the PropertyChanging event
• Fixed an issue with applying Custom Tool by Devart Entity Model (*.edml) in VS 2017 .NET Core projects
• Fixed an issue with quoting default table and column names in EF Core
• Fixed an issue with registering DevartEntityDeploy on the workstation with just Build Tools for Visual Studio 2017 installed

Entity Framework support

• Fixed an issue with using Contains() in multiple LINQ queries in EF Core
• Fixed an issue with comparison and binary operations in EF Core

7.9.946 13-Jul-17

• Fixed an issue with not backing up schemas without tables via the PgSqlDump.Backup method
• Fixed an issue with not adding "WITH OIDS;" for tables that have this clause when performing their backup with PgSqlDump
• Fixed an issue with backing up a function, containing single quotes in its body, with language=sql
• Fixed an issue with adding a schema of the current table for the reference table in a FOREIGN KEY constraint definition in a backup

Entity Developer

• Changed the behavior: IsRequired(false / true) for navigation properties is always generated in EF Core fluent mapping now
• Fixed an issue with throwing "Can't load provider assembly." by EF6 model in a standalone Entity Developer
• Fixed an issue with serializing user defined extended properties for associations
• Fixed an issue with a Devart provider not found in Entity Developer as a standalone application when the provider is installed without placing Devart assemblies to the GAC

7.9.931 22-Jun-17

• The compatibility with Visual Studio 2017 Updates is improved
• Fixed an issue with using the 'Do not install assemblies in the GAC' install wizard functionality for Visual Studio 2017
• Fixed an issue with applying the License Key connection string parameter (concerns .NET Standard 1.3 compliant assemblies only) on Linux

Entity Developer

• Fixed an issue related to the conflict of Entity Developer with dbForge SQL Complete
• Fixed an issue with generating .NET Core code by EF Core and LinqConnect templates for the "Use the following connection string from App.config" option in Model Settings

Entity Framework support

• Fixed an issue with mapping citext data type via Scaffold-DbContext in EF Core

7.9.912 25-May-17

• .NET Core is supported
• The NuGet packages with .NET Standard 1.3 (.NET Core) compliant assemblies are uploaded to www.nuget.org
• The ProcessId property is added to PgSqlAlerterAlertEventArgs
• Changed the behavior: now a new GUID is generated for the MachineKeys container name when loading the application
• Changed the behavior: now the MachineKeys container is immediately removed after establishing a connection to the server, instead of waiting for the end of the process execution
• Fixed an issue with previewing a DataSet

Entity Developer

• The .NET Core projects in Visual Studio 2017 are supported
• The Snake case in both Model and Database naming rules is supported via the new "Add underscore" option

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with running LINQ queries, which invoke .NET methods on client side during materialization of result set
• Fixed an issue with materializing scalar value collection when converting values on the client side

Entity Framework support

• Entity Framework Core 1.1.2 is supported
• The support of EF Core models with string columns, which are defined without length limit and participate in PKs, FKs, indices, is improved
• The possibility to use command interception for EF6 commands executed within batch updates is implemented
• The compatibility with ASP.NET Core Identity is improved
• Fixed an issue with using config.CodeFirstOptions.TruncateLongDefaultNames in EF Core
• Fixed an issue with using the ForPostgreSqlHasColumnName and ForPostgreSqlHasColumnType modelBuilder methods with the value-type properties in EF Core
• Fixed an issue with renaming index via EF Code-First Migrations
• Fixed an issue with paging in EF Core
• Fixed an issue with renaming index via EF Code-First Migrations

7.8.862 16-Mar-17

• Visual Studio 2017 is supported

Entity Developer

• Fixed an issue with generating the virtual keyword when Inheritance Modifier=None (Entity Framework models)

LinqConnect (formerly known as LINQ to PostgreSQL)

• The HSTORE data type is supported
• The CITEXT data type is supported

Entity Framework support

• Entity Framework Core 1.1.1 is supported
• Fixed an issue with using table-valued functions with JOINs in LINQ to Entities queries
• Fixed an issue with generating sequence for the newly added identity property by EF6 Code-First Migrations

7.7.852 02-Mar-17

• Visual Studio 2017 Release Candidate 4 is supported
• Fixed an issue with using alternative quoting in CommandText

Entity Developer

• Fixed an issue with throwing the "Stack empty" error after stopping validation before code generation in a standalone version (Entity Framework models)
• Fixed an issue with a workability of the "Validate on Build" option in Model Settings (Entity Framework models)
• Fixed an issue with compilation of the EF Core template after copying it to model folder (EF Core models)

Entity Framework support

• The translation of collection's Contains method in LINQ query to SQL statement in EF Core is supported

7.7.837 09-Feb-17

• Visual Studio 2017 Release Candidate 3 is supported
• PostgreSQL 9.6 is supported
• The "SSL TLS Protocol" connection string parameter is added to PgSqlConnection for specifying the preferred TLS version that will be send to the server

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with using DataLoadOptions.LoadWith

7.7.832 02-Feb-17

• The "Force IPv4" connection string parameter is added to PgSqlConnection for specifying whether to use only the IPv4 network protocol

Entity Framework support

• The AddUniqueConstraintOperation and DropUniqueConstraintOperation operations are supported in EF Core Code-First Migrations
• Fixed an issue with creating a predefined Migrations History table in EF Core, when config.Workarounds.DisableQuoting = true

7.7.819 16-Jan-17

• Visual Studio 2017 Release Candidate is supported
• The Info property, which contains info from the second parameter of NOTIFY command, is added to PgSqlAlerterAlertEventArgs
• The Error event is added to the PgSqlDependency class
• The PgSqlLine struct and PgSqlDataReader.GetPgSqlLine() method are implemented for PostgreSQL server 9.4 and higher
• Fixed an issue with not creating Constraints and Primary Keys collections for PgSqlDataTable with a query that contains a subquery
• Fixed an issue with backing up values of PostGIS datatypes via the PgSqlDump class
• Fixed an issue with returning a text of the actual error for INSERT queries in the "FetchAll=False" mode

Entity Developer

• Fixed an issue with detecting auto generated columns by Create Model Wizard and Update Model From Database Wizard (LinqConnect models)

Entity Framework support

• Fixed an issue with comparing non-nullable properties in LINQ query when config.QueryOptions.UseCSharpNullComparisonBehavior=true
• Fixed an issue with using AddForeignKeyOperation and DropForeignKeyOperation in EF Core Code-First Migrations
• Fixed an issue with throwing the "Operation is not valid due to the current state of the object" error with Batch Updates in EF1/EF4/EF5/EF6, if the previous SaveChanges() failed

7.7.804 22-Dec-16

Entity Framework support

• Fixed an issue with grouping by constant expression in EF1/EF4/EF5/EF6 when using DevExpress.XtraGrid.GridControl
• Fixed an issue with creating indices by EF Core Code-First migrations
• Fixed an issue with using DropPrimaryKey in Code-First Migrations, when config.Workarounds.DisableQuoting = true

7.7.794 08-Dec-16

• The 'Do not install assemblies in the GAC' checkbox that allows disabling placing the provider assemblies to the GAC is added to the Install Wizard
• Fixed an issue with backing up PostGIS datatypes via the PgSqlDump class as varchar
• Fixed an issue with generating an error when using PgSqlMonitor on Linux
• Fixed an issue with not using parameters value in ParentRelation data in PgSqlDataTable.SelectCommand
• Fixed an issue with retrieving incorrect DateTimeOffset when UnpreparedExecute is set to true
• Fixed an issue with creating columns for a child table in a master-detail relation when a select command in the child table ends with a semicolon

LinqConnect (formerly known as LINQ to PostgreSQL)

• The exception message for invoking CreateDatabase() for the model which includes an association with missing end is improved

Entity Developer

• The possibility to choose whether to add new entities to a diagram or not in Update From Database Wizard is implemented
• Changed the behavior: now the DbContext template generates an additional partial class for the context class when "File Per Class" and "Generate Partial Class" are set to True (Entity Framework models)

Entity Framework support

• Entity Framework Core 1.1.0 is supported
• The Scaffold-DbContext NuGet command of Package Manager Console for generating a model basing on the existing database schema is supported in EF Core
• Batch Updates support in EF Core is added
• The PgSqlJsonFunctions and PgSqlJsonbFunctions classes are implemented in EF4/EF5/EF6 to use JSON/JSONB functions and operators in LINQ to Entities queries
• Signed versions of NetTopologySuite GIS library are supported in EF5/EF6
• NetTopologySuite 1.14 is supported in EF5/EF6
• GeoAPI 1.7.4 is supported in EF5/EF6
• The NetTopologySuiteSigned and NetTopologySuiteUnsigned members are added to the SpatialServiceType enum in EF5/EF6
• The config.DatabaseScript.Schema.DeleteDatabaseBehaviour option is supported in EF Core
• Changed the behavior: the functionality of SpatialServiceType.NetTopologySuiteSigned is moved to Devart.Data.PostgreSql.Entity.EF5.dll / Devart.Data.PostgreSql.Entity.EF6.dll
• Changed the behavior: the SQL statement CREATE/DROP SCHEMA is generated with the IF NOT EXISTS/IF EXISTS clause now
• Fixed an issue with shortening PK, FK, IX, UX names in the Code-First CreateDatabase/CreateDatabaseScript functionality when config.CodeFirstOptions.TruncateLongDefaultNames=True
• Fixed an issue with comparison in LINQ query when config.QueryOptions.UseCSharpNullComparisonBehavior=true
• Fixed an issues with logical expressions in EF Core are fixed

7.6.763 20-Oct-16

• Fixed an issue with throwing NRE in PgSqDataTable descendants when removing the insert command

Entity Framework support

• Fixed an issue with materializing object, which includes the DbGeometry or DbGeography properties, when executing SQL query via DbContext.Database.SqlQuery<> in EF5 and EF6

7.6.753 06-Oct-16

• Fixed an issue with throwing NRE when columns in PgSqlDataTable are recreated
• Fixed an issue with old columns left in a PgSqDataTable descendant when recreating columns
• Fixed an issue with SSL connection freeze when it is closing in a multithreaded application

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with reading columns of the base type in TPT inheritance via .OfType() of LINQ query
• Fixed an issue with loading objects via association which targets to the base class of an inheritance with the materialized child class
• Fixed an issue with throwing "Sequence contains more than one element" when reading objects of TPT hierarchy

Entity Developer

• The generation of static methods by the EntityObject template is supported via the new property Direct Call of EntityMethod (Entity Framework models)
• Fixed an issue with retrieving metadata from PostgreSQL server with the intarray extension installed

Entity Framework support

• Fixed an issue with comparing bool class property with some value in EF Core

7.6.743 22-Sep-16

• Fixed an issue with disabled DataTable editor in a first descendant of the PgSqlDataTable class
• Fixed an issue with closing the PgSqlDataTable editor without an error message

Entity Developer

• Fixed an issue with moving mapping from abstract base class to child classes of TPH inheritance in the fluent mapping generated by the DbContext template (Entity Framework models)

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with materialization in the multithreaded application

Entity Framework support

• Entity Framework Core 1.0.1 is supported
• The config.DatabaseScript.Schema.Extensions configuration option is added to specify the extensions to create with DeleteDatabaseBehaviour.Database via the Code-First approach
• The new optional parameter Action<PgSqlDbContextOptionsBuilder> is added to UsePostgreSql() extension method of DbContextOptionsBuilder in EF Core
• Fixed an issue with processing IN expressions in EF Core
• Fixed an issue with retrieving objects of TPH hierarchy in EF Core

7.6.729 01-Sep-16

• The "Join Statement Notices" connection string parameter, which determines whether all the notices, raised during the statement execution, will be returned together in one InfoMessage event after the statement execution, or each notice will be returned in a separate InfoMessage event, is added
• Fixed an issue with failure of the public schema creation in a script created by the PgSqlDump.Backup method
• Fixed an issue with processing errors in the "FetchAll=True" mode
• Fixed an issue with not quoting of user variables during their dragging and dropping in a Devart PostgreSql Source component
• Fixed an issue with data preview in the PgSqlDataTable designer when the command text was changed

Entity Framework support

• The DatabaseFacade.GetPgSqlConnection() extension method, which returns PgSqlConnection, is implemented in EF Core
• Fixed an issue with using the DatabaseFacade.UseTransaction() method in EF Core
• Fixed an issue with nullable parameters in EF Core
• Fixed an issue with throwing System.NullReferenceException when using TPH inheritance in EF Core
• Fixed an issue with not throwing concurrency check exception on invoking DbContext.SaveChangesAsync()

7.6.714 11-Aug-16

Entity Developer

• Fixed an issue with setting value of the Value Generated property attribute in the EF Core model

Entity Framework support

• Fixed an issue with executing the UsePostgreSql(DbConnection connection) extension method of DbContextOptionsBuilder in EF Core
• Fixed an issue with using the DbContext(DbConnection connection) overload in EF Core
• Fixed an issue with using EF Core logging
• Fixed an issue with using enum values in EF Core
• Fixed an issue with throwing DbUpdateConcurrencyException in EF Core
• Fixed an issue with using comparisons in LINQ queries in EF Core

7.6.699 21-Jul-16

• Fixed an issue with inserting the "/"" value to a column of the JSON type via a parameter
• Fixed an issue with returning a text of the actual error in the "FetchAll=False" mode

Entity Framework support

• PgSqlCSharpMigrationCodeGenerator and PgSqlVisualBasicMigrationCodeGenerator for code-based migrations are implemented for EF4, EF5, EF6
• The CurrentDateTimeOffset and CreateDateTimeOffset canonical functions are implemented
• The PgSqlAddColumnConfiguration class for customization of the AddColumn operation in EF4, EF5, EF6 Code-First Migrations is implemented
• The PgSqlColumnAnnotations class for customization of creating columns in the CreateTable operation in EF6 Code-First Migrations is implemented
• Fixed an issue with convertation of enum values in parameters when using EF Core

7.6.687 07-Jul-16

Entity Developer

• Entity Framework Core 1.0 RTM is supported
• The possibility to set values of stored procedure parameters for getting metadata to generate automatically the corresponding complex type is implemented
• Changed the behavior: the ObservableCollection navigation properties are initialized now in a default class constructor (Entity Framework models)

Entity Framework support

• Entity Framework Core 1.0 RTM is supported
• Fixed an issue with using the CreateDateTime and CreateTime canonical functions with expressions (not constants) as arguments
• Fixed an issue with cast of parameters in the CASE expressions

7.6.677 23-Jun-16

• Fixed an issue with not adding records to the RSPreviewPolicy.config and RSReportDesigner.config files for correct work in Reporting Services(SSRS) projects

Entity Framework support

• The PgSqlConventionSetBuilder class is implemented in the Entity Framework Core support

7.6.667 09-Jun-16

• Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services, Reporting Services, and Integration Services (mapping wizards) in Visual Studio 2015 are supported
• Microsoft SQL Server 2016 is supported in SSIS DataFlow components
• Fixed an issue with signing assemblies in Mobile Edition

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with setting string parameter data types in SQL statements generated basing on the Contains LINQ operator

Entity Framework support

• The config.DatabaseScript.Table.Tablespace configuration option is added to specify the tablespace for tables created via the Code-First approach
• Fixed an issue with ignoring table schema by the DropIndex operation in Code-First Migrations

7.5.658 26-May-16

Entity Developer

• Entity Framework Core support is added
• The DbProviderFactory provider registration in application's *.config is supported by the Entity Developer version integrated into Visual Studio

Entity Framework support

• Entity Framework Core RC2 is supported

7.5.649 12-May-16

• Compatible with other dotConnect providers

7.5.644 05-May-16

• The new RestoreProgress event is added to the PgSqlDump class
• Fixed an issue when a valid command fails after an error in the previous command in case "Default FetchAll=false"
• Fixed an issue with inserting data into a JSON column

Entity Framework support

• Upgrade Wizard is improved for upgrading projects with the Entity Framework functionality

7.5.639 17-Mar-16

• The Run Once Command connection string parameter, which specifies a command to execute when the connection is opened the first time and not executed when the connection is taken from the pool, is added
• The new LoadTable overloads for loading data from a IDataReader, array of rows, or only rows with a specific RowState from a DataTable are added to the PgSqlLoader class
• Truncate member that represents the TRUNCATE TABLE statement is added to the SqlStatementType enum
• Fixed an issue with the inserting incorrect values via parameters with the PgSqlType.Interval type when UnpreparedExecute is set to true
• Fixed an issue with millisecond output when calling the ToString method of the PgSqlInterval class
• Fixed an issue with executing query in PgSQLScript containing function declarations
• Fixed an issue with availability of the materialized views in DataSet Wizard

Entity Developer

• Fixed an issue with quotation of default values for the timestamp columns in the Generate Database Script / Update Database From Model functionality (LinqConnect)
• Fixed an issue with generating the "timestamp with time zone" columns in the Generate Database Script / Update Database From Model functionality

Entity Framework

• Entity Framework Core RC1 is supported
• Entity Framework-related assemblies are renamed
• The config.QueryOptions.OrderByNullBehavior option is added to specify whether to add NULLS FIRST or NULLS LAST to the ORDER BY clause

7.4.616 17-Mar-16

• Fixed an issue with executing query in PgSQLScript containing function declarations

7.4.602 25-Feb-16

• Fixed an issue with the "Parameter name is missing" exception thrown by the Devart PostgreSql Lookup component in SSIS projects
• Fixed an issue in the DevartPostgreSql connection when establishing an SSL connection in a SSIS project

Entity Framework support

• Fixed an issue with comparing property with integer parameter in LINQ query

7.4.592 11-Feb-16

• PostgreSQL 9.5 is supported
• Fixed an issue with wrong order of view definitions in a backup script created by PgSqlDump
• Fixed an issue with PgSqlAlert CPU usage increase when connection to server is lost
• Fixed an issue with deleting trailing zeroes for decimal values

Entity Developer

• The code generation by the DbContext template (fluent mapping) for navigation properties (Entity Framework models)

Entity Framework support

• Fixed an issue with using the uuid() function for constant GUIDs in the generated SQL
• Fixed an issue with executing stored procedure with output parameter

7.4.583 21-Jan-16

• Compatible with other dotConnect providers

7.4.563 24-Dec-15

• Compatible with other dotConnect providers

7.4.558 17-Dec-15

• Fixed an issue with tables having lots of data in SSAS projects

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the "Unable to cast object of type 'Devart.Data.Linq.Engine.SqlColumnRef'" error when using a TPT inheritance

Entity Framework support

• The runtime support for calling Table-Valued Functions (IQueryable methods which return collection of records) is added
• The config.QueryOptions.CaseInsensitiveComparison option is implemented to manage the compare behaviour when using Linq to Entities comparison expression such as "a == b" (by default, false)

7.4.543 26-Nov-15

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the "Index was out of range. Must be non-negative and less than the size of the collection." error when enumerating an IQueryable collection
• Fixed an issue with materializing objects having EntitySet<T> fields via non-anonymous class that is not included in the model

Entity Framework support

• Fixed an issue with some PgSqlFunctions within LINQ queries

7.4.535 12-Nov-15

• Fixed an issue with not adding escape characters into insert statements in the PgSqlDump.Backup method
• Fixed an issue with connection disposing after the ConnectionTimeout exception when working with PgBouncer
• Fixed an issue with throwing the "Unknown connection string parameter" exception
• Fixed an issue with executing query in PgSqlScript containing function declarations

7.4.521 22-Oct-15

• Fixed an issue with calculating a time zone in a day when the clock is set to winter or summer time

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the "Collection is read-only" error when loading mapping of a stored procedure/function that returns a class, mapped as Table, but not related to the DataContext class
• Fixed an issue related to using IQueryable<T>.Count()

Entity Developer

• Fixed an issue with applying naming rules for model properties
• Fixed an issue related to the "Sequence contains no matching element" error in Update Wizards when working with TPH inheritances and many-to-many associations (LinqConnect models)
• Fixed an issue related to the StackOverflowException when deleting method from model in Model Explorer (LinqConnect models)

7.4.506 01-Oct-15

• Fixed an issue with performing a backup of a large database using the PgSqlDump.Backup method
• Fixed an issue with PostgreSQL timestamp with time zone values, containing a milliseconds part, in a SSIS project

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the "cannot insert multiple commands into a prepared statement" error when deleting a record from a table, that has several many-to-many associations with several tables

7.4.497 17-Sep-15

LinqConnect (formerly known as LINQ to PostgreSQL)

• The Parent property is added to the IInheritanceConfiguration interface
• Fixed an issue related to working with TPH inheritances and fluent mapping approach

Entity Developer

• Fixed an issue with wrong diagram layout
• Fixed an issue with checking the evaluation period in the trial version

Entity Framework support

• Fixed an issue with generation of SQL literals for GUID values

7.4.492 10-Sep-15

• Fixed an issue with mapping from SQL Server to PostgreSQL in a SSIS project
• Fixed an issue with adding an InputOutput parameter when a connection is closed
• Fixed an issue with throwing the "IDE not supported" exception by DataSet Manager in Visual Studio 2015

Entity Framework support

• Fixed an issue with mapping the enum datatype by Entity Data Model Wizard

7.4.478 20-Aug-15

• Fixed an issue with using PgSqlDump for tables with array columns

LinqConnect (formerly known as LINQ to PostgreSQL)

• The possibility to use .IsRowVersion() method for properties with non-binary data types when using the fluent mapping approach is added
• Fixed an issue with the materialization of anonymous types

Entity Developer

• The Use ObservableCollection property of the DbContext template is implemented (Entity Framework models)
• Changed the behavior: now the 1:1 and 1:0..1 associations are displayed differently on the diagram (LinqConnect models)
• Fixed an issue with mapping the enum datatype (Entity Framework models)
• Fixed an issue with adding LinqConnect template for C# after adding the WCF RIA Domain Service template (Visual Basic) in Visual Basic projects (LinqConnect models)
• Fixed an issue with non-generated .IsRowVersion() method for entity properties with IsVersion = True when using the fluent mapping approach (LinqConnect models)
• Fixed an issue with adding tables with columns of array data types to the model (LinqConnect models)

Entity Framework support

• Fixed an issue with throwing System.NullReferenceException when applying logical OR operator to the results of several IEnumerable<T>.Contains(T t)

7.4.464 30-Jul-15

• Visual Studio 2015 is supported
• Fixed an issue related to the "The type initializer for 'Devart.Data.PostgreSql.PgSqlConnectionStringBuilder' threw an exception" error

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with CreateAssociationConvention when working with the fluent mapping approach
• Fixed an issue with ManyToManyNamesConvention when working with the fluent mapping approach

Entity Developer

• Fixed an issue with generating namespace for the IsExternal enum

7.3.457 16-Jul-15

• The Transaction Error Behavior connection string parameter is implemented to determine whether to rollback a transaction automatically if an error occurs in a transaction block

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the "Object reference not set to an instance of an object" error on SubmitChanges()

Entity Developer

• The possibility of setting default values for enum properties is implemented (LinqConnect models)
• Fixed an issue with freezing Visual Studio when using the Find dialog in large models

Entity Framework support

• The performance of generating SQL for Enumerable.Contains in LINQ queries is improved by supporting a new expression type, DbInExpression, in Entity Framework 6

7.3.447 02-Jul-15

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with materialization of classes with the same names, which are located in the different namespaces or which are the nested classes of the different classes
• Fixed an issue related to wrong SQL generation when using Count(condition)/ LongCount()/ LongCount(condition) methods in the LINQ query

Entity Developer

• Changed the behavior: now Update To Database / Generate Database Script take into account precision of the timestamp columns

Entity Framework support

• Changed the behavior: now Entity Data Model Wizard/Designer takes into account precision of the timestamp columns in Model First approach

7.3.437 18-Jun-15

• The PgSqlStatementExecute event is added to the PgSqlScript class
• Fixed an issue when the ssl_renegotiation_limit value is reached in PostgreSQL 9.4

LinqConnect (formerly known as LINQ to PostgreSQL)

• The OpenConnection() method is added to the DataContext class
• Fixed an issue with not calling the InitializeConnection() method for a newly created connections while performing query or stored procedure
• Fixed an issue with throwing an incorrect exception with the "Connection must be opened" message, while performing the CreateDatabase() method

Entity Developer

• Changed the behavior: Create Model Wizard / Update From Database Wizard import the timestamp columns with precision

Entity Framework support

• Changed the behavior: now Entity Data Model Wizard/Designer imports the timestamp columns with precision
• Changed the behavior: now the Code-First CreateDatabase() functionality generates the timestamp columns with precision
• Fixed an issue with loosing elements within the IN clause of the generated SQL for the LINQ Contains clause

7.3.422 28-May-15

• Visual Studio 2015 Release Candidate is supported
• SSL renegotiation is supported

Entity Developer

• Fixed an issue with detecting the default values of attributes added via the Attributes menu
• Fixed an issue with generating code by MVC Controller template (Entity Framework models)

7.3.407 07-May-15

LinqConnect (formerly known as LINQ to PostgreSQL)

• The JSONB data type is supported
• Fixed an issue related to not submitting new records, when EntityRef of the corresponding entity class is set to null
• Fixed an issue related to re-materialization of objects of the same type when performing methods that are mapped to different stored procedures
• Fixed an issue with loading metadata and query performing when ITable<TEntity> is used instead of Table<TEntity>
• Fixed an issue with the materialization of UInt32 values greater than Int32.MaxValue

7.3.397 23-Apr-15

• Changed the behavior: now "DROP IF EXISTS" statements will be added to backup script for PostgreSQL server 8.2 and higher when PgSqlDump.IncludeDrop is used
• Changed the behavior: now the "SET AUTOCOMMIT = TRUE" command is not executed any more when a connection to a PostgreSQL server 7.4 or higher is opened
• Changed the behavior: now the statement for deleting defaults for columns before dropping a table with these columns is removed
• Fixed an issue with quotes or parenthesis characters in a composite type

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the odd ESCAPE character in a generated SQL query after LIKE condition
• Fixed an issue related to re-materialization of objects of the same type when performing various SQL-queries via ExecuteQuery() method in multi-threading applications

Entity Developer

• The support of ID generators for primary keys in the Fluent Mapping template is added (LinqConnect models)

Entity Framework support

• Fixed an issue with generating columns in subqueries of a complex LINQ to Entities query containing limit expressions

7.3.389 09-Apr-15

• The 'IgnoreUnnamedParameters' connection string parameter that disables unnamed parameters in queries, executed via the connection, is added

Entity Developer

• Fixed an issue with ignoring the "Delete Cascaded" property of the association when performing the Update Database From Model and Update Model From Database wizards (Entity Framework models)

7.3.379 26-Mar-15

• Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services and Integration Services in Visual Studio 2013 are supported
• SSIS DataFlow Source and Destination components are supported in SSDT-BI for Visual Studio 2013
• Fixed an issue with reading and writing of string arrays with elements containing escape characters

LinqConnect (formerly known as LINQ to PostgreSQL)

• The dependency on the System.Windows.Forms.dll assembly is removed
• Fixed an issue related to the wrong SQL generation (setting value for primary key column in UPDATE statement) when using the Attach(TEntity, asModified) method
• Fixed an issue related the CompiledQueryCache locking issue
• Fixed an issue related to long default names of identifiers (for example, indexes, primary keys, foreign keys) when using CreateDatabase() method

Entity Developer

• Changed the behavior: now the default values are not set for string properties, that correspond to fields with the default values like expressions (Entity Framework models)
• Fixed an issue with missing settings for the LazyLoadingEnabled property in the generated code when working with the Self-Tracking Entity template (Entity Framework models)
• Fixed an issue related to working with the Table Per Type (TPT) and abstract entity classes when synchronization is enabled (Entity Framework models)

Entity Framework support

• The JSONB data type is supported
• Fixed an issue with reading the second and consequent result sets, returned by stored procedure

7.3.359 26-Feb-15

• Fixed an issue with using System.Runtime.CompilerServices.ExtensionAttribute in Devart.Data.Synchronization.dll for the projects with 3.5 and higher versions of .NET Framework

7.3.352 12-Feb-15

• Fixed an issue with the PgSqlCommandBuilder.DeriveParameters method, when more than one schema is set in a connection string and the corresponding schema name is not used in command text

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the "Cannot convert the value to GUID: System.Byte[]" error when working with eager loading and GUIDs

Entity Developer

• Fixed an issue with the wrong code generation for Table Per Concrete Type (TPC) hierarchy when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseConfigurationClasses (or UseOnModelCreatingMethod) options (Entity Framework models)

7.3.344 02-Feb-15

Entity Developer

• Fixed an issue with "Trial period expired"

7.3.342 29-Jan-15

• Fixed an issue in Sync Framework support with synchronization scopes, having a filter based on a template

Entity Developer

• Fixed an issue with generating code by the MVC Controller template for multiple self-associations (Entity Framework models)

7.3.333 15-Jan-15

• Fixed an issue with throwing System.InvalidOperationException by connection pooling in multithreaded applications under high loads
• Fixed an issue with the PgSqlDataReader.GetPgSqlArray method in a multithreaded application

Entity Developer

• Fixed an issue with generating connection string supplied to constructor in case of placing the model in a subfolder of the project (Entity Framework models)

7.3.313 18-Dec-14

Entity Framework support

• Fixed an issue with SQL generation for AddYears, AddMonths, AddDays, AddHours, AddMinutes, AddSeconds, AddMilliseconds, AddMicroseconds, AddNanoseconds canonical functions
• Fixed an issue related to the "Type 'serial' doesn't exist" error while performing the ALTER TABLE statement via Code-First migrations

7.3.303 04-Dec-14

• Changed the behavior: UTC_TIMESTAMP() is used now in WF Services scripts for the DATETIME columns
• Fixed an issues with using Workflow Foundation when UnpreparedExecute is set to true, are fixed
• Fixed an issue related to the "The UTC Offset of the local dateTime parameter does not match the offset argument" error when working with the Pacific Time Zone (US & Canada, UTC-08:00)

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to memory leak errors when working with the disabled compiled query cache

Entity Developer

• Fixed an issue with the incorrect code generation, when the "Enable WinForms Data Binding" property of the DbContext template (Visual Basic) is set to True (Entity Framework models)
• Fixed an issue with missing attributes for the enum members when generating code with the DbContext template (Entity Framework models)

Entity Framework support

• Fixed an issue related to working with the customized Migration History table and Entity Framework 6

7.3.293 20-Nov-14

• ADO.NET implementation of ASP.NET Identity 2.0 support is improved
• The new IQueryableUserStore interface is implemented in the UserStore class
• The new IQueryableRoleStore interface is implemented in the RoleStore class
• The enableExpiredSessionAutoDeletion and expiredSessionAutoDeletionInterval options for deleting expired sessions are added to the session-state store provider definition in the web.config file
• Changed the behavior: the PgSqlMonitor now hides information about the password connection string parameter
• Fixed an issue with fetching not all rows for a table with a JSON column and FetchAll=false property
• Fixed an issue with precision loss when working with PgSqlType.Numeric via the protocol 3
• Fixed an issue with the value of the connection State property not reflecting the actual connection state after a connection loss
• Fixed an issue with the conflict between versions of Devart.Data.PostgreSql.Web.dll assembly for ASP.NET 2 and ASP.NET 4

Entity Developer

• Fixed an issue related to script generation by the "Generate Database Script" wizard with the "Include Drop" option
• Fixed an issue related to resetting enum arguments of custom attributes in the standalone version
• Fixed an issue with incorrect execution of the "Create Storage and Mapping" command for an association (Entity Framework models)

7.3.283 06-Nov-14

• The new \Web\ASP.NET 45\Devart.Data.PostgreSql.Web.dll assembly (its revision number is 5) is added to the provider installation folder to support SimpleMembership in MVC5
• Fixed an issue with returning NULL by PgSqlRowType.GetRowType method for types with large OID

Entity Developer

• Fixed an issue with reading all constructor parameters for attributes when opening model
• Fixed an issue with reading Default Value of database fields with explicit cast
• Fixed an issue related to disappearance of the foreign key property when performing "Create Storage and Mapping" from the context menu of the association (Entity Framework models)
• Fixed an issue related to the "'End Class' must be preceded by a matching 'Class'" error when adding stored procedure to the model and using DbContext template in Visual Basic projects (Entity Framework models)

7.3.274 23-Oct-14

• The error message caused by exceeding the number of connections, specified in the "CONNECTION LIMIT" database parameter, is improved

Entity Framework support

• The config.SpatialOptions.PrecisionModel configuration option is added to specify the NetTopologySuite precision model scale factors
• Fixed an issue with assigning -1 (instead of null) to SRID of the DbGeometry object

7.3.264 09-Oct-14

• The Enterprise Library 6 support is added; all previous versions of Enterprise Library are no longer maintained

Entity Framework support

• Fixed an issue with throwing "Unexpected server type 'a'" error when using DeleteDatabaseBehaviour.Database in the Code-First functionality

7.3.254 25-Sep-14

• The possibility to quote schemas names in connection string is added

Entity Developer

• Changed the behavior: Generate Database Script From Model saves the output in ASCII format if there are no unicode symbols in the script; UTF-8 is used otherwise
• Changed the behavior: now the default value for the 'File Per Class' option of the DbContext template is True (Entity Framework models)
• Fixed an issue with model creation when using multiple naming rules (suffixes, prefixes)
• Fixed an issue with generating .HasPrecision for decimal types when using non-attribute fluent mapping (DbContext template) (Entity Framework models)

Entity Framework support

• Changed the behavior: the DEFAULT value is generated now for the columns in the database which correspond to System.Guid identity properties in the Code-First/Code-First Migrations functionality

7.3.244 11-Sep-14

• Fixed an issue related to the "The type initializer for 'Devart.Data.PostgreSql.PgSqlConnectionStringBuilder' threw an exception" error
• Fixed an issue in executing queries, consisting of multiple select statements, when protocol 2.0 or UnpreparedExecute is used

Entity Framework support

• Fixed an issue with generating IS NULL/IS NOT NULL in SQL statement for LINQ expressions which represent string concatenation
• Fixed an issue with generating CAST for parameters in SQL statements IS NULL/IS NOT NULL
• Fixed an issue related to the "Index was out of range. Must be non-negative and less than the size of the collection" error when working with PgSqlFunctions.Like(value, pattern) method

7.3.239 04-Sep-14

• The 'Keep Alive' parameter, that enables sending TCP keep-alive packets and specifies the interval at which they are sent, is added to the connection string
• Fixed an issue with invalid script when table has only primary key columns for Sync Framework support

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the NullReferenceException on SubmitChanges, when working with association between classes involved in complex TPT hierarchy

Entity Developer

• The Remove Invalid Characters option (by default, True) is added to the Model Naming rules; if it is set to False, all invalid characters will be replaced with underscores
• The Enable WinForms Data Binding property of the DbContext template is implemented (Entity Framework models)
• The Property Change Partial Methods property of the DbContext template is implemented for generating partial methods On%PropertyName%Changing and On%PropertyName%Changed for each primitive property of entity classes (Entity Framework models)
• Changed the behavior: now partial configuration classes are generated when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseConfigurationClasses options (Entity Framework models)
• Fixed an issue with the wrong code generation for associations when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseAttributes options (Entity Framework models)
• Fixed an issue with generating DatabaseGeneratedAttribute for non-EntityKey properties when using attribute mapping (DbContext template) (Entity Framework models)
• Fixed an issue with generating DatabaseGeneratedAttribute for all EntityKey properties when using fluent mapping (DbContext template) (Entity Framework models)
• Fixed an issue related to the "An error occurred during an attempt to compile the template 'LinqConnect'." error in Windows Store applications (LinqConnect models)

Entity Framework support

• The generation of LEFT JOIN LATERAL and CROSS JOIN LATERAL is supported for PostgreSQL 9.3
• Fixed an issue related to working with NULL values and the DateTimeOffset data type

7.3.225 14-Aug-14

Entity Developer

• The possibility to use relative paths to assemblies in code generation templates is implemented
• The Implement Equals property is added to the DbContext, ObjectContext, and POCO Entity templates (Entity Framework models)
• Fixed an issue related to detecting nullable foreign key as non-nullable (Entity Framework models)

7.3.215 31-Jul-14

• Fixed an issue with throwing "Unspecified error" by Migration Wizard when working with Windows Store (WinRT), XNA, Windows Phone, and Silverlight projects

Entity Developer

• Fixed an issue with a format of generated DataAnnotations.RegularExpression for Numeric validate format
• Fixed an issue related to incorrect detection of the default values with the cast operators (LinqConnect models)
• Fixed an issue with displaying Entity Set in the Class Editor dialog (Entity Framework models)
• Fixed an issue with applying changes after editing the list of the extended properties via the Model Settings dialog (Entity Framework models)
• Fixed an issue with adding references to both EntityFramework.dll and System.Data.Entity.dll assemblies simultaneously by Create Model Wizard, when Entity Framework version is set to Entity Framework 6 in the wizard (Entity Framework models)

Entity Framework support

• Fixed an issue with generating DDL for creating TPH tables, when the value of discriminator is not set, in the Code-First/Code-First Migrations functionality
• Fixed an issue with applying DatabaseGeneratedOption.Identity for non-EntityKey integer properties in the Code-First/Code-First Migrations functionality
• Fixed an issue with applying custom HistoryContext settings

7.3.201 10-Jul-14

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with the missing "ASP.NET Dynamic Data LinqConnect Web Application" project template in Visual Studio 2013

Entity Developer

• The View Generation option of the model with Entity Framework version = Entity Framework 6 is supported for the DbContext (only with XML mapping), EntityObject, POCO, and Self-Tracking Entities templates (Entity Framework models)
• Fixed an issue with "DevartEntityDeploy" task, when .NET Framework 2.0 and .NET Framework 3.5 are not installed on the target workstation (Entity Framework models)

Entity Framework support

• Fixed an issue with creating extra schema in the database when config.DatabaseScript.Schema.DeleteDatabaseBehaviour = DeleteDatabaseBehaviour.Database

7.3.191 26-Jun-14

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the memory leak issue when working with EntityCachingMode = StrongReference
• Fixed an issue related to the NullReferenceException when performing queries and working with EntityCachingMode = StrongReference
• Fixed an issue related to the "There is no tables to process" error when using the CreateDatabase() method with the DataContext object, that is based on the empty model
• Fixed an issue related to the error when creating XmlMappingSource via the FromReader() method

Entity Developer

• Fixed an issue with storing custom settings in stored procedure mapping (Entity Framework models)
• Fixed an issue with ordering properties in the .HasKey configuration mapping in case of composite primary key (Entity Framework models)

Entity Framework support

• The behaviuor is changed: the SQL generation is changed from "CAST(ColumnName AS varchar)" to "CAST(ColumnName AS text)" when comparing values of the columns with the JSON data types
• Fixed an issue related to the "operator does not exist: json ~~ text" error when working with the JSON data types in UNION queries

7.3.181 12-Jun-14

• ADO.NET implementation of ASP.NET Identity 2.0 support is improved
• The new IUserStore<T>, IUserClaimStore<T>, IUserLoginStore<T>, IUserPasswordStore<T>, IUserRoleStore<T>, IUserEmailStore<T>, IUserPhoneNumberStore<T> interfaces are implemented in the PgSqlUserStore and PgSqlUserStore<TIdentityUser, TIdentityRole> classes
• The new IRoleStore<T> interface is supported in the PgSqlRoleStore and PgSqlRoleStore<TIdentityUser, TIdentityRole> classes
• The functions with return type TABLE are added to the list of the functions in the DataSet wizard as a data source
• Fixed an issue with mapping smallint data type in SSIS Import Export Wizard
• Fixed an issue with quoting the tables names in the DbSyncScopeDescription.Tables collection returned by the PgSqlSyncDescriptionBuilder.GetDescriptionForScope method

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to using properties of the enum data type (Byte, SByte), that are used in the complex entity key

Entity Developer

• Fixed an issue with resetting value of the extended properties for associations after reopening the model (LinqConnect models)

Entity Framework support

• Fixed an issue with throwing System.NullReferenceException when disposing an ObjectResult
• Fixed an issue with performing "Generate Database from Model" wizard when working with Entity Framework 6.1.0 Tools for Visual Studio 2012/Visual Studio 2013

7.3.171 29-May-14

• Fixed an issue with deserialization of a license resource in ASP.NET applications, running with medium or high trust level
• Fixed an issue with a function that returns table in TableAdapter, which is created in the Dataset Designer
• Fixed an issue with parameters order for functions when creating DataSet

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to using properties of the enum data type, that are used in the complex entity key

Entity Developer

• Fixed an issue related to the opening of the *.edmx files (Entity Framework models)
• Fixed an issue related to adding new entity properties with the spatial data type when using Model First approach (Entity Framework models)

Entity Framework support

• Fixed an issue related to the inserts (for Identity columns) and updates (for Computed columns) when working with unquoted columns and when config.Workarounds.DisableQuoting is set to True
• Fixed an issue related to the Null Reference Exception when loading related entities with the spatial data type
• Fixed an issue with determining the type of local variable used in LINQ query
• Fixed an issue with throwing the "Unexpected query batch command" exception when using the Batch Updates functionality
• Fixed an issue with generating extra condition for limiting subselect by one record in generated subqueries with grouping

7.3.161 15-May-14

• PgSqlUtils class is added
• The PgSqlScript.Cancel() method is added to stop query execution

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to reading values of the string properties, that are database generated, when performing SubmitChanges()

Entity Developer

• Fixed an issue related to performing queries via Query Editor/Retrieve Data when working with the 'Enterprise Library' validation framework
• Fixed an issue related to the storage and mapping regeneration via the "Update Database from Model" wizard, or via the "Regenerate Storage and Mapping" option of the diagram shortcut menu, when changing one DBMS to another (LinqConnect models)

Entity Framework support

• Changed the behavior: now a semicolon (;) after the very last statement is generated in the Code-First CreateDatabaseScript() functionality
• Changed the behavior: the constraint name is ignored if a table primary key is deleted when running Code-First Migrations, that allows successful removing of automatically named primary key in PostgreSQL 9 or higher
• Fixed an issue with adding a primary key to the existing table when using Code-First Migrations

7.3.146 24-Apr-14

• The ADO.NET implementation of ASP.NET Identity 2.0 support is added
• The new \Web\ASP.NET Identity 2\Devart.Data.PostgreSql.Web.Identity.dll assembly (its revision number is 2) is added to the provider installation folder
• The new \Web\ASP.NET Identity 2\Install_identity_tables.sql and \Web\ASP.NET Identity 2\Uninstall_identity_tables.sql files are added to the provider installation folder
• The new \Web\ASP.NET Identity 2\Upgrade_identity_tables_from_v1_to_v2.sql file is added to the provider installation folder
• The new IUserEmailStore, IUserPhoneNumberStore, IUserTwoFactorStore, IUserLockoutStore interfaces are implemented in the UserStore class
• Fixed an issue with mapping the numeric database type in the Devart PostgreSql Source component in SSIS application
• Fixed an issue with mapping the numeric database type in SSIS application
• Fixed an issue with 'Load Test Editor'

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to wrong order of the insert/delete operations on SubmitChanges when the autogenerated primary keys are used
• Fixed an issue related to the incorrect script generation for column names (lower case) when working with the CreateDatabase()/DeleteDatabase() methods

Entity Developer

• Changed the behavior: now a property in the generated code is initialized basing on the default value in CSDL only (instead of default values in any of SSDL and CSDL; Entity Framework models)
• Fixed an issue related to the incorrect value setting for the "Has Stream" property when working with the WCF Data Services projects (Entity Framework models)

Entity Framework support

• The database server version is added to the generated Code-First Migrations script
• Fixed an issue with the explicitly named primary keys in Code-First Migrations, when the primary key is defined via the PrimaryKey() method of the CreateTable() operation
• Fixed an issue with generating SQL for EntitySQL ANYELEMENT

7.3.135 10-Apr-14

• The ADO.NET implementation of ASP.NET Identity support is improved
• The ICloneable interface is implemented in the IdentityUser and IdentityRole classes
• The User_Id column in the AspNetUserClaims table is renamed to UserId

Entity Framework support

• The UpdateDatabaseOperation operation in Code-First Migrations for Entity Framework 6.x is supported
• The RenameIndexOperation operation in Code-First Migrations for Entity Framework 6.1 is supported
• Multiple EntityContainers in the Code-First CreateDatabase()/CreateDatabaseScript()/DeleteDatabase() functionality are supported
• The Database.Delete(DbConnection) functionality is supported: all objects in the current schema (specified in Schema or set with Initialization Command connection string parameter) are removed if DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects
• The Database.Exists(DbConnection) functionality is supported: the method returns true if DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects and at least one table exists in the current schema (specified in Schema or set with Initialization Command connection string parameter)
• Determining correct datatypes of data retrieved by EntitySQL queries with UNION ALL and similar constructions is improved
• The compatibility with Hibernating Rhinos EntityFramework Profiler is improved
• Fixed an issue with throwing System.NullReferenceException when enumerating an ObjectResult returned by a stored procedure
• Fixed an issue related to the "failed to find conversion function from unknown to text" error when performing queries with multiple 'Include()'s

7.3.125 27-Mar-14

• Changed the behavior: the instance_id field of the wf_activity_info table in Workflow Tracking implementation is of varchar(100) type now
• Fixed an issue with parsing private key in the PKCS#8 format
• Fixed an issue with 'SSL Mode' parameter value not passed to a PgSqlAlerter object connection

LinqConnect (formerly known as LINQ to PostgreSQL)

• The JSON data type is supported
• Fixed an issue related to the incorrect detection of class type when working with the TPH inheritances and discriminators of the String/Decimal type

Entity Developer

• The override modifier for DbSet class properties generated by DbContext templates is added (Entity Framework models)
• Fixed an issue with setting nullable type for EnumType property by the Data Transfer Object template

Entity Framework support

• Entity Framework 6.1.0 RTM is supported
• Entity Framework 6.1.0 Tools for Visual Studio 2012 & 2013 are supported
• The use of the JSON data type in string canonical functions and comparison operators (equality and inequality) is supported
• The releasing of memory, which was allocated for commands and readers of ObjectContext / DbContext, is improved
• Fixed an issue related to the "UNION types json and character varying cannot be matched" error

7.3.115 06-Mar-14

• The ADO.NET implementation of ASP.NET Identity support is added
• The message of the exception, when an attempt to rollback a closed transaction is made, is improved
• Changed the behavior: if PgSqlTransaction has been already assigned to the PgSqlConnection object, all subsequent calls of the BeginTransaction method on the same PgSqlConnection object will return an existing PgSqlTransaction instance
• Fixed an issue with using non-default schema when creating the provisioning objects for Sync Framework support
• Fixed an issue with loading workflows with content based correlation handle, once they have unloaded to the database, in response to a WCF message

LinqConnect (formerly known as LINQ to PostgreSQL)

• The CommandTimeout property is added to the DataProvider class
• Fixed an issue related to the invalid generation of the foreign keys DDL for many-to-many associations when using CreateDatabase method
• Fixed an issue related to the "Cannot use "timestamp(6)" type value in "DateTimeOffset" type argument" error
• Fixed an issue with the query cache when performing several queries, having nullable parameters, sequentially

Entity Developer

• The information message about availability of NuGet Package Manager on the workstation is added in the Entity Developer version integrated into Visual Studio (Entity Framework models)
• Changed the behavior: now paths to assemblies with attributes (Model Settings -> Model -> Attributes) are saved and used as relative paths
• Fixed an issue with invalid code generation when different namespaces for context and entity classes are used in the VB.NET projects (LinqConnect models)
• Fixed an issue with generating the entities namespace in fluent mapping configuration classes (Entity Framework models)
• Fixed an issue with generating DatabaseGeneratedOption.Computed for non-EntityKey properties in fluent mapping (Entity Framework models)

Entity Framework support

• SharpMap 1.1 is supported
• NTS Topology Suite 1.13.2 is supported

7.2.103 18-Feb-14

• Fixed an issue with executing anonymous code blocks in PgSqlScript

Entity Developer

• More information messages, when validating EF6 models basing on the EntityFramework.dll functionality, are added (Entity Framework models)
• Fixed an issue with using Create Model Wizard for EF6 models (Entity Framework models)

7.2.100 13-Feb-14

• Fixed an issue related to the "Unexpected server response" error when working with Pooling=True

LinqConnect (formerly known as LINQ to PostgreSQL)

• Changed the behavior: now the script is generated with "ON DELETE NO ACTION" when using the CreateDatabase() method and the "Delete Rule" for the association is set to "NO ACTION"
• Changed the behavior: now the CreateDatabase() method uses the same algorithm for naming foreign keys as in Entity Developer
• Changed the behavior: now the cascade deletion of tables in DeleteDatabase() method is performed via the "DROP TABLE CASCADE" statement
• Fixed an issue with the compiled query cache when working with the DbLinqDataSource component when navigating through the pages of the DataGrid control
• Fixed an issue with the wrong SQL query generation for Contains(), StartsWith(), EndsWith() methods when the string pattern includes '[' or '^' symbols

Entity Developer

• The "WCF DataMember Attribute on Navigation Properties" property is added to the Data Transfer Object template for pointing the end (-s) where the attribute should be generated (Entity Framework models)
• Changed the behavior: the validation of EF6 models depends on the EntityFramework.dll functionality only (.NET Framework 4.5 is not required any more) (Entity Framework models)
• Fixed an issue related to the "Version string portion was too short or too long" error
• Fixed an issue with dropping the UpdateCheck property value from Always to Never when re-opening the model (LinqConnect models)
• Fixed an issue with parsing inheritances in *.edmx (Entity Framework models)

Entity Framework support

• The JSON data type is supported
• Fixed an issue with creating association basing on composite foreign key, when the column order in the corresponding primary key is different in Entity Data Model Wizard/LightSwitch/Entity Framework 6 Tools for PostgreSQL servers of 8.2 and higher versions
• Fixed an issue with "Update Model From Database" wizard in Entity Framework 6 Tools for Visual Studio 2012 and Visual Studio 2013

7.2.90 30-Jan-14

• Changed the behavior: IndexOutOfRangeException is generated now instead of InvalidOperationException when PgSqlDataReader.GetOrdinal(String name) finds nothing in the result set
• Fixed an issue with rolling back changes when using TransactionScope

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with handling complex types of the entity properties in the ServerDataTypeConvention class when working with fluent mapping
• Fixed an issue related to the "Object reference not set to an instance of an object" exception on CreateDatabase() method when working with associations and fluent mapping
• Fixed an issue with performing updates and deletes, when concurrency check is used for not-primary key columns, and the commands are combined to run in batches
• Fixed an issue related to re-materialization of objects of the same type when performing various SQL-queries via ExecuteQuery() method

Entity Developer

• Fixed an issue with retrieving metadata when connecting to PostgreSQL server 8.0
• Fixed an issue with creating association basing on composite foreign key, when the column order in the corresponding primary key is different

Entity Framework support

• Fixed an issue with generating IndexOutOfRangeException by the ObjectContext.ExecuteStoreQuery method when the result set of the SQL query does not include any mapped column of the entity being materialized
• Fixed an issue with removing foreign keys in Code-First functionality
• Fixed an issue with generating SQL statement for the class with a single Identity property

7.2.80 16-Jan-14

Entity Developer

• Fixed an issue with not including the namespace name in the XML mapping, when namespaces for entity classes and context class are different (LinqConnect models)
• Fixed an issue with creating models for Entity Framework 6 on the workstation without .NET Framework 4.5 installed (Entity Framework models)
• Fixed an issue with association mapping in the DbContext template (Entity Framework models)
• Fixed an issue with composite keys mapping in the DbContext template (Entity Framework models)

Entity Framework support

• Fixed an issue with changing the MigrationHistory table when migrating from EF4/EF5 to EF6, when config.Workarounds.DisableQuoting = True

7.2.65 26-Dec-13

• Fixed an issue with retrieving views in Business Intelligence Solutions projects

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with wrong order for creation tables with the many-to-many associations via the CreateDatabase() method
• Fixed an issue with the entity cache (EntityCacheMode.WeakReference)
• Fixed an issue related to working with the stored functions, that return results as "SETOF primitive_type"

Entity Developer

• The predefined templates (POCO Entity and LinqConnect) are improved: new template setting, "Generate Dummy Comments", is added (LinqConnect models)
• Fixed an issue related to detecting unique keys (LinqConnect models)
• Fixed an issue related to the "Custom tool error: Unknown namespace or alias (NamespaceName.NamespaceName)" error when setting return type of the method to complex type (Entity Framework models)

Entity Framework support

• Changed the behavior: Code-First Migrations generates DEFAULT values for new NOT NULL columns of Boolean, Guid, DateTime, TimeSpan types when adding them in the existing table
• Changed the behavior: Code-First Migrations does not generate the unicode attribute if it is not specified in the mapping explicitly

7.2.55 12-Dec-13

• Workflow Foundation is supported
• Fixed an issue with inserting quoted user-defined fields via WebSecurity.CreateUserAndAccount method of SimpleMembership provider

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with foreign keys not created for many-to-many associations via the CreateDatabase() method
• Fixed an issue related to the "The type initializer for 'DefaultXmlMappingProvider'" exception when working with the xml mapping and result sets
• Fixed an issue with the comparison of the entity key property with a nullable variable, which is equal to null

Entity Framework support

• Changed the behavior: the schema, specified in the Schema connection string parameter, is created in the database when config.DatabaseScript.Schema.DeleteDatabaseBehaviour is equal to DeleteDatabaseBehaviour.Schema or DeleteDatabaseBehaviour.Database

7.1.45 28-Nov-13

• Changed the behavior: now a transaction rollbacks on Connection.Close() if Transaction.Commit() was not called before closing the connection
• Fixed an issue with disabling some properties in Devart components in Visual Studio Express
• Fixed an issue with calling the RowUpdating event of PgSqlDataTable and PgSqlDataAdapter classes when no data is changed
• Fixed an issue with installing provider assemblies for the x64 version of SQL Server Integration Services

LinqConnect (formerly known as LINQ to PostgreSQL)

• The possibility to inherit from the data provider classes is added

Entity Developer

• The new "Provider Manifest Token" model property is implemented to identify the target server (Entity Framework models)
• Changed the behavior: the values of "Target Server" and "Server Version" can be reset via the Model Settings > Synchronization > Mapping dialog despite the fact whether connection is specified in Database Explorer or not

Entity Framework support

• The compatibility of Entity Framework provider for EF v1, v4, v5 with medium trust level environment is improved
• Fixed an issue related to the NRE on the CreateDatabaseScript() method, when the Code-First model is not configured completely

7.1.36 14-Nov-13

Entity Framework support

• The Entity SQL canonical function NewGuid is supported
• The config.QueryOptions.NewGuidGenerationMethod configuration option (by default SQL expression is used) is added to provide the possibility to set a way to generate new Guid

7.1.26 31-Oct-13

• Visual Studio 2013 is supported
• Changed the behavior: installation with the /VERYSILENT install parameter will uninstall the other version of the provider without any dialog if it is installed
• Fixed an issue with using ExtendedMembership provider in a multithreaded application
• Fixed an issue with the '-1' value of the MaxLength property for columns with character types, which are created by PgSqlDataAdapter

Entity Developer

• Entity Framework 6 is supported
• Fixed an issue with IntelliSense when working with T4 Editor in Visual Studio 2012

Entity Framework support

• The 6.0.0 and 6.0.1 versions of Entity Framework are supported
• Changed the behavior: Entity Data Model Wizard shows a more detailed error message in case of connecting to unsupported database or using incorrect provider manifest tokens

7.0.17 17-Oct-13

• Microsoft Sync Framework support is implemented
• The support of asynchronous backing up and restoring for PgSqlDump is implemented
• The following methods are added to PgSqlDump class for asynchronous backup and restore operations: BeginBackup, BeginBackupQuery, BeginRestore, EndBackup, EndBackupQuery, EndRestore
• The UseMultirowSyntax property, specifying whether to use the multirow VALUES syntax when generating INSERT statements, is added to the PgSqlDump class
• The CommitBatchSize property, specifying the max size in bytes of a single INSERT statement with multiple values in the script when using the multirow VALUES syntax, is added to the PgSqlDump class
• PgSqlTime type, representing the TIME server data type, is added
• PgSqlTimeTZ type, representing the TIME WITH TIMEZONE server data type, is added
• Fixed an issue with backing up the serial columns with PgSqlDump

LinqConnect (formerly known as LINQ to PostgreSQL)

• The Collate method of the SqlMethods class is implemented
• Fixed an issue with ignoring 'IsDbGenerated = True' when using Attach(TEntity entity, bool asModified) method
• Fixed an issue with the compiled query cache when query contains parameters with the same values

Entity Developer

• The predefined templates are improved: new template setting, "Use Compiled Query Cache", is added (LinqConnect models)
• Fixed an issue with "DevartEntityDeploy" task, which generates mapping files, in Visual Studio 2013 Release Candidate

Entity Framework support

• Changed the behavior: Code-First Migrations generates DEFAULT 0 for new NOT NULL columns of numeric types when adding them in the existing table
• Changed the behavior: Code-First Migrations generates DEFAULT '' for new NOT NULL columns of string types when adding them in the existing table
• Fixed an issue with performing queries via the ExecuteStoreQuery, SqlQuery methods in Entity Framework 6

6.8.333 23-Sep-13

• Visual Studio 2013 Release Candidate is supported

Entity Developer

• Fixed an issue with releasing memory after closing the Retrieve Data window
• Fixed an issue with the Overwrite.Merge template option
• Fixed an issue related to the "Value cannot be null" error when selecting "Regenerate storage and mapping" from the shortcut menu in Model Explorer in Visual Studio

Entity Framework support

• Changed the behavior: the strict FetchAll = True for created SQL commands is removed; now the behavior is determined by the connection string parameter "Default FetchAll"

6.8.322 05-Sep-13

• SSIS DataFlow Source and Destination components for PostgreSQL are implemented
• The overload for the PgSqlLargeObject.Open() method with the PgSqlLargeObjectOpenMode parameter is added
• Fixed an issue with NULL values in Data Viewer in SSIS
• Fixed an issue with dequeuing RAW message having length greater than 2000 characters
• Fixed an issue with NullReferenceException when deserializing PgSqlException after passing it between AppDomains
• Fixed an issue with an error occurring during opening a connection, and then this connection getting into the pool
• Fixed an issue with the Caption property of the DataGridView column with the Devart DataTable component

LinqConnect (formerly known as LINQ to PostgreSQL)

• The possibility to use the extension method AsQueryable() in LINQ queries is added
• The support for correct retrieving of the TimeSpan and DateTimeOffset values while materializing is added
• The support for the operators of equality(==) and inequality(!=) for the "inet" data type in LINQ queries is added
• Fixed an issue with eager loading
• Fixed an issue with the redundant opened sessions
• Fixed an issue with missing CreateCommand method in the DataProvider class
• Fixed an issue related to the ArgumentNullException on SubmitChanges method when trying to update a row with the same values

Entity Developer

• The "Close the window when the generation completes successfully" option in the Generation Process window is implemented in the standalone Entity Developer
• The "Rewrite connection string during regeneration" option (default value is True) of model settings is added to provide the possibility to turn off modifying connection string in *.config after model is saved first time (Entity Framework models)
• The design time support for model-defined functions is added (Entity Framework models)
• Changed the behavior: now connection string is configured with the name of the assembly, where the model is located, in case when the context class is located in another assembly (Entity Framework models)
• Fixed an issue with the Retrieve Data functionality of the model with the DbContext template, when its Fluent Mapping property is set to True (Entity Framework models)
• Fixed an issue related to the detection of Table Per Type inheritances as Table Per Concrete Type inheritances when opening an existing model (Entity Framework models)
• Fixed an issue with parsing *.edmx (Entity Framework models)
• Fixed an issue with generating "An item with the same key has already been added" error when using DbContext Template (Entity Framework models)
• Fixed an issue with DbContext template, when its MappingGenerationStrategy is set to UseConfigurationClasses, generating fluent mapping for an association with turned off generation of one navigation property (Entity Framework models)
• Fixed an issue with availability of the New Blank Template option of the Templates context menu in Model Explorer in the Entity Developer version integrated into Visual Studio
• Fixed an issue with generating invalid code when using MVC View Advanced template

Entity Framework support

• Entity Framework 6 Release Candidate 1 is supported
• SharpMap 1.0 RTM is supported
• NetTopologySuite 1.13.1 is supported
• Devart.Data.PostgreSql.Entity.Spatials.dll assembly is added
• Changed the behavior: the parameter, which participates in the IS NULL comparison, is cast to a particular type in the generated SQL query
• Fixed an issue with generating NRE when adding parameter to a command in IDbCommandInterceptor.ReaderExecuting in Entity Framework 6
• Fixed an issue with applying datetime and time data types when generating SQL with UNION statements, which correspond to multiple Include constructions in LINQ to Entities

6.7.301 08-Aug-13

• The "Default FetchAll" connection string parameter for defining default value of the FetchAll property of PgSqlCommand objects created on the connection is implemented
• The possibility of specifying negative large object OIDs via interface of the PgSqlLargeObject class is implemented
• The support of asynchronous backing up and restoring for PgSqlDump is implemented
• Fixed an issue with executing prepared statements via pgPool II
• Fixed an issue related to the "Unexpected server response" exception on ExecuteReader method when using it in cycle with Cancel method
• Fixed an issue with compatibility of Devart.Data.PostgreSql.Web.dll for .NET Framework 2 and 4 in Visual Studio 2010, that is automatically added to the project when adding the PgSqlDataSource component to the web form

Entity Developer

• The "Model Name As Files Prefix" property is implemented for the templates which generate classes for model entities
• The possibility of adding custom attributes to enum members is implemented
• Changed the behavior: the possibility to exclude the generation of keys (primary, foreign) in "Update Database From Model" and "Generate Database Script From Model " wizards is added
• Changed the behavior: the possibility to add one-to-one associations with nullable foreign key properties is added (LinqConnect models)
• Changed the behavior: now by default MVC Controller template generates files in the model folder, MVC View Advanced template creates files in the Views model subfolder
• Changed the behavior: the PostgreSQL limitation in 63 character for identifier names is taken into account when the SQL script is generated by Update Database From Model / Generate Database Script wizards
• Fixed an issue with breaking the parameters order in Generator Parameters Editor (LinqConnect models)
• Fixed an issue with an error during a compilation of the 'LinqConnect' template for VB.NET projects in Visual Studio 2008 (LinqConnect models)
• Fixed an issue with breaking the IdGenerator configuration after closing the model (LinqConnect models)
• Fixed an issue with generating code by Self-Tracking Entity template (Entity Framework models)
• Fixed an issue with parsing *.edmx

Entity Framework support

• The "Unprepared Execute" connection string parameter is supported by Entity Framework runtime
• Fixed an issue with converting data types when using Batch Updates

6.7.287 18-Jul-13

• SQL Server 2012 Reporting Services is supported
• Fixed an issue with the Cancel method of PgSqlCommand when using CommandBehavior.SequentialAccess
• Fixed an issue with incorrect registration PgSqlExtendedMembershipProvider in machine.config file

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the NRE on the CreateDatabase() method, when the navigation properties generation for one of the sides in one-to-one association is turned off
• Fixed an issue with wrong script generation on the CreateDatabase() method for one-to-one associations
• Fixed an issue with materialization when converting decimal values
• Fixed an issue related to the "Sequence contains no elements" exception when working with unmapped properties and PropertyChanging/PropertyChanged events
• Fixed an issue related to materializing structs in the "select new" clause
• Fixed an issue related to the "Method not found" exception when opening connection in LINQPad via LinqConnectDriver

Entity Developer

• Support for spatial data types in Entity Framework 5 and 6 is added
• Changed the behavior: a default value for the "Detect Table Per Type inheritances" option in Model settings is set to False
• Fixed an issue related to the wrong Source values for foreign key properties when adding associations with the selected "Add foreign key properties to the child class" checkbox
• Fixed an issue with applying RangeAttribute of the DataAnnotation validation framework for nullable properties
• Fixed an issue with parsing *.edmx (Entity Framework models)

Entity Framework support

• Support for spatial data types in Entity Framework 5 and 6 is added
• NetTopologySuite GIS library support in Entity Framework 5 and 6 is added
• PostGIS 'geometry' and 'geography' data type support in Entity Framework 5 and 6 is added
• Devart.Data.PostgreSql.Entity.dll assembly built with the 4.5 version of .NET Framework is added
• Devart.Data.PostgreSql.Entity.Migrations.dll assembly built with the 5.0 version of EntityFramework.dll is added
• The PgSqlSpatialFunctions class for working with PostGIS spatial functions in LINQ to Entities is added
• The config.Workarounds.UseInvariantProviderManifestToken configuration option (default value is False) is added to provide the possibility of returning the invariant string literal as the provider manifest token
• The config.SqlFormatting.Identation option is renamed to config.SqlFormatting.Indenting
• Fixed an issue with using delimiter when generating Code-First Migrations script via the ScriptUpdate method of the MigratorScriptingDecorator class in Entity Framework 6

6.6.276 03-Jul-13

• Fixed an issue with determining the DateTime.Kind value by the PgSqlDataReader.GetDateTime method when reading from the timestamp with / without time zone columns

Entity Developer

• The "Regenerate Storage and Mapping" option for regenerating model parts, specific to the database server, is added to the diagram shortcut menu
• Storage Entity Editor is improved: the capability to edit extended columns settings, such as facets, is added (Entity Framework models)
• Fixed an issue with adding a new property to the base abstract class in Table Per Hierarchy inheritance (Entity Framework models)

Entity Framework support

• Fixed an issue with a workability of configuration options set in the application config file when using Code-First Migrations via Package Manager Console of Visual Studio

6.6.267 20-Jun-13

• The CommitTimeout property of the PgSqlConnection object is implemented to determine timeout period for the Commit method
• Fixed an issue with the PgSqlDataSource component in design time
• Fixed an issue with retrieving the Guid type
• Fixed an issue with retrieving default value data for table columns when calling the PgSqlConnection.GetSchema("Columns") method
• Fixed an issue with generating typed Devart DataSet using a connection from *.config in the Visual Basic project

LinqConnect (formerly known as LINQ to PostgreSQL)

• The performance when working with the TPT-inheritance and retrieving descendants via OfType<> is improved
• Fixed an issue with the CreateDatabase() method when "Delete Rule" is set for the association (not empty and not "NO ACTION")
• Fixed an issue related to the "The non-nullable navigation property '...' was set to null in the entity object '...'" error when working with nullable composite foreign keys
• Fixed an issue related to working with the WCF Ria Domain Service template
• Fixed an issue with the TPT-inheritance and associations to the descendants of the inheritance
• Fixed an issue related to the "Violation of PRIMARY KEY constraint" error on SubmitChanges(), when DataContext has only one added entity for insertion with a custom key generator and DbGenerated=False for its primary key

Entity Developer

• Changed the behavior: DatabaseGeneratedOption is always generated for EntityKey properties when using fluent mapping (Entity Framework models)
• Fixed an issue with wrong code generation for nullable enum properties
• Fixed an issue with generating "Access Denied" error when using MVC templates
• Fixed an issue with a serialization of stored procedures mapping to CUD operations in an association (Entity Framework models)
• Fixed an issue with ordering parameters of a method when Update From Database Wizard adds/removes parameters to the method signature (Entity Framework models)
• Fixed an issue with parsing *.edmx which includes an association, which has different values in a navigation property name and a role at the same end (Entity Framework models)
• Fixed an issue with indentifying citext parameter when importing function in SSDL (Entity Framework models)

Entity Framework support

• The config.DatabaseScript.ForeignKey.Enabled option (default value is True) is added to turn on/off generation of foreign key constraints
• Fixed an issue with using methods which include Byte and SByte parameters

6.6.257 06-Jun-13

• Fixed an issue with throwing an exception during installation when the DbProviderFactories section is missing in the machine.config file

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with the nullable properties in composite foreign keys

Entity Developer

• Devart.Data.Linq.Binary type is added to the "Type Mapping Rule Editor" (LinqConnect models)
• Changed the behavior: auto-implemented properties are generated when DbContext template is used with ImplementINotifyPropertyChanged=False and ImplementINotifyPropertyChanging=False (Entity Framework models)
• Fixed an issue with referencing a custom assembly in T4 template
• Fixed an issue with processing non-latin symbols in the names of objects (Entity Framework models)
• Fixed an issue with a synchronization when adding new properties to the base abstract class in Table Per Hierarchy inheritance (Entity Framework models)
• Fixed an issue with parsing *.edmx which includes the class with a self-association (Entity Framework models)
• Fixed an issue with retrieving an association mapping when opening *.edmx (Entity Framework models)

Entity Framework support

• Entity Framework 6 Beta 1 is supported
• The Database value is added to the DeleteDatabaseBehaviour enumeration for creating/removing database in Code-First
• Changed the behavior: CreateDatabase()/Code-First with DeleteDatabaseBehaviour.Schema does not try to create a schema if it exists
• Fixed an issue using Batch Updates in a multithreaded application
• Fixed an issue with quoting non-latin symbols
• Fixed an issue with creating CHAR / VARCHAR datatypes without specified max length using CreateDatabase()/Code-First approach

6.6.252 30-May-13

• Fixed an issue with PgSqlArray of the UUID type with protocol 3
• Fixed an issue with WebSecurity.Login() used with wrong credentials

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with inserting dependent entity when the main entity has a key generator for the primary key property and DbGenerated is set to False
• Fixed an issue with duplicate columns in an ORDER BY statement when using eager loading for several tables
• Fixed an issue related to working with unmapped class members

Entity Developer

• The "WCF DataMember Attribute on Navigation Properties" property is added to the DbContext and POCO templates for pointing the end (-s) where the attribute should be generated
• Fixed an issue with placing tables names in the root of the "Choose change action" page of Update From Database Wizard
• Fixed an issue with generating NRE when setting the output of the template to the unloaded project
• Fixed an issue with adding many-to-many associations when one of the sides of the association is involved in the inheritance (LinqConnect models)

6.6.242 16-May-13

• Fixed an issue with the PgSqlDataReader.GetDateTimeOffset method when reading data of the timestamp with time zone type
• Fixed an issue with processing newline string characters in PgSqlLoader

LinqConnect (formerly known as LINQ to PostgreSQL)

• The possibility to disable query cache via the DataContext's 'EntityCachingMode' property is added
• Support for SERIAL and BIGSERIAL database types when using CreatedDatabase() method is added
• Fixed an issue with inheriting an entity class from an unmapped type
• Fixed an issue related to the 'Index was outside of the bounds of the array' error when using GroupBy in queries
• Fixed an issue with the materializer cache and AssociateWith method
• Fixed an issue with the CreatedDatabase() method for many-to-many associations
• Fixed an issue with AddDays() method with negative parameters
• Fixed an issue with inserting record with composite primary key

Entity Developer

• The Save and Refresh buttons for persisting and reloading changes to / from a database is added to the Retrieve Data grid
• POCO Entity template is improved: new template setting, "Property Change Notifiers", is added (LinqConnect models)
• Changed the behavior: a string default value for the property can be set without quotes in the Properties window
• Changed the behavior: the validation error is not generated when an abstract class is used in Table Per Type inheritance (Entity Framework models)
• Fixed an issue with wrong detecting many-to-many associations (LinqConnect models)
• Fixed an issue with obtaining metadata of procedure result set which returns table (Entity Framework models)
• Fixed an issue with mapping nested complex data types in the MSL part of the model in the synchronization mode (Entity Framework models)

Entity Framework support

• Fixed an issue with using geometric data types when EF engine generates UNION for CASEs

6.6.226 23-Apr-13

Entity Developer

• Fixed an issue with incorrect work of the Update Model From Database wizard for models containing stored procedures with parameters (Entity Framework models)

6.6.224 18-Apr-13

• Changed the behavior: provider's build action is installed on the target workstation, on which .NET Framework is available, without Visual Studio integration
• Fixed an issue with missing schema name prefix during backing up index objects with the PgSqlDump component
• Fixed an issue with database objects drag-and-drop from Server Explorer on DataSet Editor

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with query cache issues when working with one DataContext instance and different data providers
• Fixed an issue with method Any() when working with one DataContext instance and different data providers
• Fixed an issue related to the issue with the OnListChanged() event when EntitySet collection is changed

Entity Developer

• Fixed an issue with loading mapping rules for some datatypes under .NET Framework 4.5
• Fixed an issue with wrong database script generation for tables with several many-to-many associations (LinqConnect models)

Entity Framework support

• The datetimeoffset pseudo type of SSDL, which corresponds to System.DateTimeOffset, is implemented
• The error messages about long identifiers when using CreateDatabase/DropDatabase are improved
• Fixed an issue with SQL generation for the HasValue property of the Nullable variable in LINQ to Entities queries
• Fixed an issue with a workability of config.QueryOptions.CaseInsensitiveLike

6.6.217 04-Apr-13

• The "AllowDateTimeOffset" connection string parameter for returning the TimeStampTZ database value like System.DateTimeOffset by PgSqlDataReader is implemented
• Fixed an issue with initializing the PgSqlConnection object before passing it to the PgSqlCommand instance when generating code for typed Devart DataSet
• Fixed an issue with InvalidCastException in PgSqlDump.Backup for PostgreSQL server 8.3 and earlier
• Fixed an issue with defining delete statement in SqlStatementExecute event handler
• Fixed an issue with passing an array of the row type as a parameter value

LinqConnect (formerly known as LINQ to PostgreSQL)

• LINQPad integration is supported
• Fixed an issue related to the NullReferenceException on SubmitChanges() method when working with isVersion properties

Entity Developer

• A new MVC Controller template, generating a ASP.NET MVC controller with data access code, is added
• A new MVC View Advanced template, generating an ASP.NET MVC view based in Twitter Bootstrap, is added
• A new Data Transfer Object template for DTO classes generation is implemented
• A new Data Annotation Metadata template, generating Data Annotation metadata classes and decorating classes and properties with data annotation attributes for validation, presentation and defining metadata, is added
• A new WCF RIA Domain Service template, generating a WCF RIA Services domain service class for a Devart Entity Framework model is added
• A new WCF RIA Domain Service template, generating a WCF RIA Services domain service class for a Devart LinqConnect model is added
• Add Template dialog is improved
• The Namespace property of class, complex type, enum is implemented
• The Entity Container Namespace properties of the model is implemented (Entity Framework models)
• The support for enums declared in external assemblies is implemented
• The capability for setting special rules for generating default names of database objects when using the Model First approach is implemented (a new Advanced page is added to the Synchronization->Database Naming section of the Model Settings dialog)
• The capability to customize properties that are automatically added when creating a new entity, and options that are automatically set when creating a new property is added (a new Initialization page is added to the Model->General section of the Model Settings dialog)
• The Refresh option in the Attributes tab of the Model Settings window is implemented; it updates the list of available attributes types in the referenced assemblies
• The capability to modify custom attributes for several selected entities or properties at the same time is implemented
• Automatic adding of references to Entity Framework specific assemblies when adding a new Devart Entity model to a project is implemented
• The capability to cancel metadata reading in wizards and Database Explorer is added
• The "Recreate Database Tables" checkbox, which allows to drop and recreate database tables, is added to the "Update To Database" wizard
• New setting "Detect Table Per Type inheritances", which enables automatic detection of TPT inheritances, is added for Create Model Wizard and model
• The "Include Drop" checkbox for including DROP commands for database objects to the generated script is added to Generate Database Script Wizard
• A new shortcut menu command "Include Related", which allows making a copy of the related objects in the specified diagram, is added
• A new shortcut menu command "Add To Model with Related", which allows adding tables, related to the selected one, to the model, is added to the shortcut menu of tables in Database Explorer
• A new shortcut menu command "Add On Diagram With Related", which allows creating an object and all the objects related to it on a diagram, is added to the shortcut menu of classes, complex types, and enums in Model Explorer
• New "Simple" diagram skin is added for displaying a diagram in metro style
• The "Default Width" diagram property for specifying the default width for newly created diagram shapes (entities, complex types and enums) is added
• DbContext template is improved: a "WCF Data Contract Attributes" setting for generation of DataContract, KnownType, and DataMember attributes for classes and properties is added (Entity Framework models)
• DbContext template is improved: "Implement INotifyPropertyChanging" and "Implement INotifyPropertyChanged" template settings are added (Entity Framework models)
• DbContext template is improved: a new "Mapping Generation Strategy" property that determines the method of mapping generation is implemented (Entity Framework models)
• POCO template is improved: a new "WCF Data Contract Attributes" setting for generating DataContract, KnownType, and DataMember attributes for classes and properties is added (Entity Framework models)
• POCO template is improved: "Proxy Creation Enabled" setting is implemented (Entity Framework models)
• POCO template is improved: new template settings, "Implement INotifyPropertyChanging" and "Implement INotifyPropertyChanged", are added (Entity Framework models)
• Create Model Wizard is improved: it is now able to download and install the required 'EnityFramework' Nuget package for Entity Framework 6 models, and for models for Entity Framework 4 and 5 in case they use the DbContext template
• The Storage Column Editor dialog is improved: the possibility to specify different settings that were previously available only in the Properties docking window are implemented (Entity Framework models)
• Class Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
• Type Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
• The "Rewrite connection string during regeneration" checkbox of Model Settings is implemented to determine whether to overwrite the connection string in the project config file with the one, currently set in Entity Developer for the model, each time when regenerating code for the model (LinqConnect models)
• Changed the behavior: "Save connection string in App.Config as" checkbox in Model Settings dialog is renamed to "Use connection string from App.Config as" (LinqConnect models)
• Changed the behavior: now, when creating a new TPH discriminator column in Inheritance Editor, it has the string type by default
• Changed the behavior: the error is generated if the Abstract inheritance modifier is set for the class which is involved in the Table Per Type inheritance
• Changed the behavior: empty value is used in property editors instead of -1 for marking facets of class property without assigned value
• Changed the behavior: System.DateTime .NET structure is mapped to TIMESTAMP database type when using Model First approach (LinqConnect models)
• Fixed an issue with the database script generation for the 'Delete Rule' association property (LinqConnect models)
• Fixed an issue with closing connection in the generated method, which has multiple result sets (Entity Framework models)
• Fixed an issue with adding annotation:UseStrongSpatialTypes="false" automatically to CSDL of the model with Entity Framework version set to 5 or higher

Entity Framework support

• Fixed an issue with quoting collation in the ORDER BY clause of EntitySQL

6.5.202 14-Mar-13

• Fixed an issue with dropping an object when other objects depend on it during PgSqlDump.Restore()

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with DataLoadOptions.AssociateWith() when working with several DataContext objects
• Fixed an issue related to the "Specified cast is not valid" exception when working with auto-increment primary keys mapped to decimal entity property

Entity Developer

• Fixed an issue with obtaining DebuggerService when working with T4 Editor (LinqConnect models)

Entity Framework support

• Entity Framework 6 Alpha 3 is supported

6.5.192 28-Feb-13

• ExtendedMembership (SimpleMembership) provider support is added
• Fixed an issue with command generation for the PgSqlDataSource component

Entity Developer

• The possibility of setting enum values via predefined dropdown list in the Retrieve Data window is implemented
• Changed the behavior: the Guid property is mapped to the UUID type in the database when using the Model First approach (LinqConnect models)
• Fixed an issue related to the stored procedures with miltiple resultsets (LinqConnect models)

6.4.179 07-Feb-13

• Fixed an issue with using parameter value of the System.DateTimeOffset type

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to creation of a new instance of DataContext when using fluent mapping with the 'Database Independent = true' property
• Fixed an issue related to the "Cannot add query to cache. An item with the same key already exists" exception in multi-threading applications

Entity Developer

• Changed the behavior: the serializing property and corresponding methods are not generated when using 'Fluent Mapping'/'POCO Entity' templates and Unidirectional mode (LinqConnect models)
• Changed the behavior: warnings about tables/views without primary keys are written to Error List window when generating a model (Entity Framework models)
• Changed the behavior: the EntityKey attribute is not assigned to each property of the class if there is no primary key in the corresponding table/view (Entity Framework models)
• Changed the behavior: empty value is used in property editors instead of -1 for marking facets of Storage Column without assigned value (Entity Framework models)
• Fixed an issue with setting SERIAL/BIGSERIAL data types for auto generated properties, which are not primary keys, when performing "Generate Database Script from Model" and "Update Database From Model" wizards

6.4.164 17-Jan-13

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the "Cannot convert from 'string' to 'Devart.Data.Linq.Mapping.DeleteRule' " error when working with Fluent mapping

Entity Developer

• Fixed an issue with duplicate entries in the Base Class Condition and Derived Class Condition dropdowns of Inheritance Editor (Entity Framework models)

Entity Framework support

• Entity Framework 6 Alpha 2 is supported
• Devart.Data.PostgreSql.Entity.dll assembly compiled with EntityFramework.dll 6.0 and NET Framework 4.0 is added

6.3.146 20-Dec-12

• Fixed an issue with formatting the timestamp data when generating the script for user creation during PgSqlDump.Backup()
• Fixed an issue with formatting the string data with escape characters during PgSqlDump.Backup()
• Fixed an issue with generating invalid overload of the PgSqlDataTable constuctor when using Devart DataSet Wizard
• Fixed an issue, that occurred when editing an existing Dataset in DataSet Wizard and which was associated with incorrect processing of 'Select command text' for Data tables having DataSource set to TableAdapter

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the "Object does not match target type" exception when working with DbLinqDataSources and gridviews
• Fixed an issue with the implicitly converting strings to integer type in queries when working with VB.NET projects
• Fixed an issue related to the "Unsupported delete rule 'NO ACTION'" exception when creating DataContext
• Fixed an issue with update commands for dependent entities that participate in Table Per Type inheritance

Entity Developer

• Model Refactoring feature is implemented; it speeds up creating complex types and Table Per Type and Table Per Concrete Type inheritances from several model entities
• Create Storage and Mapping command, that allows automatically creating of the corresponding storage part object and defining mapping, is added to the shortcut menu of classes, properties, and associations (Entity Framework models)
• Select Storage Object command, that allows quick navigation to the corresponding storage part object, is added to the shortcut menu of classes, properties, associations, and methods (Entity Framework models)
• The possibility to delete the corresponding storage part objects automatically when deleting conceptual model objects is added (Entity Framework models)
• The functionality of ignoring columns in the database in the "Update To/From Database" wizards if they were omitted once before is implemented
• The Property Editor dialog is improved: fast access to the editor of the corresponding storage object and the possibility to specify different settings that were previously available only in the Properties docking window are implemented (Entity Framework models)
• The Inheritance Editor dialog is improved: specifying Discriminator column for Table Per Hierarchy inheritance in the editor is implemented (Entity Framework models)
• The Class Editor dialog is improved: fast access to the editor of the corresponding storage object is implemented (Entity Framework models)
• The Method Editor dialog is improved: fast access to the editor of the corresponding storage object is implemented (Entity Framework models)
• Warnings about objects that are not mapped are added
• The naming algorithm for the newly-created columns, which correspond to complex type's properties, when using the Model First approach is improved (Entity Framework models)
• A SHIFT+DELETE keyboard shortcut for deleting entity, complex type, or enum from diagram only is added
• An INSERT keyboard shortcut for creating a new entity, adding property to the selected entity/complex type or new member to enum is added
• The possibility to view notes, added through the "Documentation" property, for all the diagram objects via hints is implemented
• Hints for diagram objects are improved
• Changed the behavior: Configure Behaviour dialog is renamed to Stored Procedure Mapping; options for hiding inappropriate and mapped stored procedures are added (Entity Framework models)
• Changed the behavior: Table Editor dialog is renamed to Storage Entity Editor (Entity Framework models)
• Changed the behavior: Stored Procedure Editor dialog is renamed to Storage Procedure Editor (Entity Framework models)
• Changed the behavior: Configure Behaviour dialog is renamed to Stored Procedure Mapping (LinqConnect models)

Entity Framework support

• Fixed an issue with pointing out the schema name when generating index in Code-First Migrations

6.2.132 29-Nov-12

• Visual Studio 2005 support is discontinued
• Fixed an issue with using quoted schemas in DDEX

LinqConnect (formerly known as LINQ to PostgreSQL)

• The fluent mapping is improved: support of the ID generators for primary keys is added
• Fixed an issue with the "Specified cast is not valid" exception when searching for an entity by its key
• Fixed an issue with the failed updates to the database when using the Attach(TEntity,Boolean) method

Entity Developer

• The possibility to set different namespaces for the context and its entities when using the DbContext template is implemented (Entity Framework models)
• Fixed an issue with generating the using directives for redundant namespaces (Entity Framework models)
• Fixed an issue with renaming the navigation property when using the Update Model From Database wizard (LinqConnect models)

Entity Framework support

• Fixed an issue with retrieving metadata information about primary keys in ADO.NET Entity Data Model/LightSwitch when using database user with limited privileges
• Fixed an issue with the IgnoreSchemaName and IgnoreDboSchemaName options when working with EdmFunction

6.2.122 15-Nov-12

• The TimeZone property of the PgSqlLocalization class is implemented to adjust timezone of the corresponding .NET data types when converting them to/from the server data types
• Fixed an issue with writing the escape characters in PgSqlLoader component
• Fixed an issue with set transaction isolation level
• Fixed an issue with executing COMMIT after COMMIT PREPARED with a distributed transaction

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issues with using LinqConnect for Dynamic Data projects under .NET Framework 4.0 or higher are fixed

6.2.114 01-Nov-12

• Fixed an issue with sending the commit and rollback events for connections in the distributed transaction to dbMonitor
• Fixed an issue with the PgSqlLoader object doubling a single quote character

Entity Developer

• Fixed an issue with availability of the Yes/No/Cancel options when saving models created with previous versions of Entity Developer
• Fixed an issue with incorrect model creation and wrong generation of the associations and entity keys when working for users with limited privileges (Entity Framework models)

6.2.104 18-Oct-12

• The support of Range Types for PostgreSQL 9.2 is added
• PgSqlIntRange class for representing the int4range type is added
• PgSqlBigIntRange class for representing the int8range type is added
• PgSqlNumericRange class for representing the numrange type is added
• PgSqlTimeStampRange class for representing the tsrange type is added
• PgSqlTimeStampTZRange class for representing the tstzrange type is added
• PgSqlDataRange class for representing the datarange type is added
• Fixed an issue with the 'general' keyword in SQL queries
• Fixed an issue with the PgSqlScript.CommandTimeout property not changing its value when setting the DefaultCommandTimeout parameter of the connection string
• Fixed an issue with the new line character in the connection string

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with working with entities without INotifyPropertyChanging, INotifyPropertyChanged interfaces

Entity Developer

• Fixed an issue with disposing EntityCommand in the code generated for calling stored procedure (Entity Framework models)

Entity Framework support

• Fixed an issue with DropDatabase() and CreateDatabase(), when DeleteDatabaseBehaviour.ModelObjectsOnly is used, in EF v4.3 and higher
• Fixed an issue with DropDatabase() and CreateDatabase(), when IgnoreDboSchemaName option is enabled and DeleteDatabaseBehaviour.Schema is used, in EF v4.3 and higher

6.2.96 04-Oct-12

• Fixed an issue with deploying Analysis Services Project when using the x64 version of SQL Server Analysis Service

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue related to the "An item with the same key has already been added" exception when working with DevExpress GridView
• Fixed an issue with synchronization of the parent and child entities

Entity Developer

• Predefined template for generating Repositories and Unit of Work classes is added
• Integration with Visual Studio refactoring for renaming model objects is implemented
• The "Use Database Comments" option of Model Settings is implemented to determine whether comments for database objects, if supported by DBMS, will be used for model objects Documentation initialization and taken into account when executing model or database update operations
• The "Implement IClonable" option for the generated classes based on the model entities is added to all templates
• Changed the behavior: the "Save connection string in App.Config as" option is available for LinqConnect models in the standalone version Entity Developer (the entry in App.Config must be added manually afterwards)

Entity Framework support

• The config.CodeFirstOptions.TruncateLongDefaultNames configuration option (default value is False) is added to provide the possibility of truncating long default names of indexes, primary keys, and foreign keys generated by Code-First Migrations
• The validation of identifier name length in Code-First Migrations is implemented
• Fixed an issue with setting configuration options via the application config file
• Fixed an issue with setting the configuration options for Entity Framework v1

6.2.77 06-Sep-12

• Visual Studio 2012 is supported

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with getting entities from the cache by keys of type Int16
• Fixed an issue with getting entities directly from the cache for the command First (predicate) etc
• Fixed an issue with wrong parameters when loading dependent entities with two-level LoadOptions are set

Entity Developer

• Support for ADO.NET Entity Framework 5 is added
• The 'Entity Base' class property, which allows specifying the ancestor class/interface for a particular entity type, is implemented (LinqConnect models)
• Changed the behavior: only particular (not all) property characteristics are regenerated when using Update Model From Database wizard after the metadata of the corresponding column have been changed (LinqConnect models)

Entity Framework support

• ADO.NET Entity Framework 5 is supported
• Changed the behavior: Devart.Data.PostgreSql.Entity.Migrations.dll is built with the 4.4 version of EntityFramework.dll now
• Fixed an issue with using command delimiters when generating the Code-First Migrations script in Package Manager Console of Visual Studio

6.1.58 09-Aug-12

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with creating DataContext with complex types having no default mapping
• Fixed an issue with modifying the list of tracked entities when it is being enumerated
• Fixed an issue with clearing the collection of depending entities
• Fixed an issue with datetime literals as default COALESCE arguments

Entity Developer

• The possibility to unload assemblies from the main application domain by using separate application domain is implemented
• The possibility to disable such Database First Settings as type mapping rules is implemented
• The design time copy/cut/paste functionality for enum members is added
• Fixed an issue with generating the "This model has been modified outside of the editor. Do you want to reload it?" error when Entity Developer is integrated into TFS
• Fixed an issue with integration into TFS

Entity Framework support

• The config.QueryOptions.UseCSharpNullComparisonBehavior configuration option for checking for NULL when comparing a nullable property (column) or an expression with a variable (parameter) in LINQ to Entities is implemented (by default, false)

6.1.40 17-Jul-12

• Changed the behavior: when a connection is terminated, PgSqlAlerter waiting process is terminated too and an exception is thrown
• Fixed an issue with opening a connection when working with Reporting Services in Visual Studio

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with enumerating queries that have empty result sets
• Fixed an issue with materializing query results into invalid object properties
• The query cache bug with distinguishing compiled queries that have nullable parameters
• Fixed an issue with deleting many-to-many links of entity having multiple many-to-many associations

Entity Developer

• Changed the behavior: the warning, related to the missing property setter, is disabled (LinqConnect models)
• Changed the behavior: for the association, in which the many-side entity hasn't the primary key, the code and the mapping are not generated (LinqConnect models)
• Changed the behavior: the properties, that correspond autoincrement fields, are generated with a ReadOnly keyword in VB.NET (LinqConnect models)

Entity Framework support

• The support of the PostgreSQL full-text search functionality is implemented
• The PgSqlTextFunctions class for working with full-text search functions in LINQ to Entities is added
• The support of the TSVECTOR and TSQUERY data types is implemented
• The PgSqlCreateIndexConfiguration class for creating full-text indexes in CreateIndex operation in Code-First Migrations is added
• Creating indexes for FK columns in Code-First CreateDatabase functionality is implemented
• The config.DatabaseScript.ForeignKey.IndexCreation configuration option is added (default value is True)
• The SimilarTo overloaded methods are added to the PgSqlFunctions class to provide support of the SQL SIMILAR TO statement
• The possibility of setting configuration options via the application config file is implemented
• The Devart.Data.PostgreSql.Entity.xsd file is added to the installation in order to simplify setting and validating the application config file settings when using the XML Editor
• Code-First Migrations now supports specifying which schema (database) a table belongs to
• CASE generation is improved
• The config.Workarounds.IgnoreDboSchemaName configuration option is added. The option is automatically set to True, if Code-First (Migrations) EF v4.x/5.x is used
• Changed the behavior: in case of using Code-First (Migrations) EF v4.x/5.x the schema name 'dbo' will be ignored by default

6.0.25 21-Jun-12

• Fixed an issue with insertion of the PgSqlArray instance containing elements with values equal to 'null'

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with deleting the entity and its many-to-many bunches outside the batch

Entity Developer

• The "Pluralize collection navigation properties" option for the possibility to turn off the pluralization of the many-end names of associations is implemented
• The "sealed override" inheritance modifier for methods based on stored procedures and functions is added (LinqConnect models)
• Fixed an issue with copy/pasting entities having a common relation
• Fixed an issue with generating redundant column in SSDL when setting one-to-one association in the designer (Entity Framework models)
• Fixed an issue with generating the MSL mapping for one-to-one association (Entity Framework models)
• Fixed an issue with the displaying many-to-many associations in the Association Editor (LinqConnect models)
• Fixed an issue with specifying the custom tool for LinqConnect models being added to web sites (LinqConnect models)
• Fixed an issue with mapping generation for associations with the 'Delete On Null' rule enabled (LinqConnect models)
• Fixed an issue with mapping generation for entity types having multiple complex types (LinqConnect models)

6.0.17 07-Jun-12

• Visual Studio 2012 Release Candidate is supported
• The Initialization Command connection string parameter is implemented
• The MemCryptStorage class for storing SSL certificates in the application memory is implemented
• Changed the behavior: the 'sender' parameter in MonitorEventHandler is a connection and the MonitorEventArgs.ExtraInfo property is filled with the connection string
• Fixed an issue with returning DateTime with DateTimeKind.Unspecified by the PgSqlDataReader.GetDateTime method when reading from the timestamp without time zone column
• The minor bugs with the GetSchema method of the PgSqlConnection class are fixed

LinqConnect (formerly known as LINQ to PostgreSQL)

• The CreateDatabase bug with creating a table for an entity type with multiple complex type fields
• The CreateDatabase bug with creating a table for an entity type with no primary key

Entity Developer

• Fixed an issue with the failure to read the complex type's Access property value (Entity Framework models)
• Fixed an issue with saving *.edml when importing data from *.edmx (Entity Framework models)

Entity Framework support

• The config.CodeFirstOptions.RemoveSchemaFromDefaultConstraintName option for removing schema name from the default constraint name is implemented in Code-First Migrations (by default, true)
• The config.CodeFirstOptions.AddTableNameInDefaultIndexName option for adding a table name to the default index name is implemented in Code-First Migrations (by default, true)
• The config.CodeFirstOptions.DisableIndexQuoting option is implemented for a backward compatibility with migrations which use indexes, generated and applied in the 5.xx versions
• Fixed an issue with quoting indexes in Code-First Migrations
• Fixed an issue with HistoryTable in Code-First Migrations when using the DisableQuoting option
• Fixed an issue with adding a schema prefix to default constraint name (PK and FK) in Code-First Migrations

6.0.6 22-May-12

• Changed the behavior: the access modifier of the connectionString field of web provider classes is changed from private to protected
• Fixed an issue with retrieving correct decimal value from database when 'PgSqlCommand.UnpreparedExecute = true'
• Fixed an issue with using the Transaction Scope Local connection string parameter for connection within distributed transaction

LinqConnect (formerly known as LINQ to PostgreSQL)

• References to System.Data.Linq are removed; now LinqConnect uses only its own classes
• Upgrade wizard for upgrading projects to the new version of LinqConnect automatically is added
• The possibility to choose cache mode (classic mode for cases when DataContext is used as a unit of work, and self-cleaning mode for cases when DataContext is a long-lived object) is added
• The possibility to map stored procedure out parameters of the CURSOR type to IEnumerable parameters of the corresponding methods is added
• Tracking of complex object graphs with chains of parent-child objects is optimized
• Number of database calls required for managing objects with a many-to-many association is reduced
• Delete rule performance is improved
• Compilation performance is improved
• Materialization performance is improved
• Compiled query cache is improved

Entity Developer

• The sticker notes for adding comments to diagrams are implemented
• The possibility to add a stamp, specifying diagram author, company, version, copyrights, project name, and date, to a diagram is implemented
• New Collapse All and Expand All menu commands for collapsing and expanding diagram shapes are added
• Changed the behavior: context menu commands for working with diagram are grouped to the Diagram submenu of the context menu
• Changed the behaviorr: the possibility to change diagram shape color via the corresponding Shape -> Color context menu command is added
• Changed the behavior: when pasting a copied entity to a new diagram, a new entity is not created, the existing entity is added to this diagram
• Changed the behavior: when cutting an entity from the diagram, the entity is not cut from the model, only from the diagram
• Changed the behavior: "Update Model From Database" wizard places newly added properties to the base abstract class now instead of putting them into child classes where the mapping is (Entity Framework models)
• Changed the behavior: the Money data type is mapped to System.Decimal by default now when using Database First approach (Entity Framework models)
• Changed the behavior: the CSDL property is left unchanged when the corresponding SSDL property is regenerated (Entity Framework models)
• Changed the behavior: the association names are generated basing on the database FK names when using Database First approach (Entity Framework models)
• Fixed an issue with reading one-to-many associations from the *.edmx file (Entity Framework models)
• Fixed an issue with "DevartEntityDeploy" task when only .NET Framework 4 is installed (Entity Framework models)
• Fixed an issue with closing connection in the generated method of the context (Entity Framework models)
• Fixed an issue with generating code using DbContext template, when template's Fluent Mapping property is set to True and one of the navigation properties of an association is turned off (Entity Framework models)
• Fixed an issue with incorrect saving of method's extended properties (LinqConnect models)

Entity Framework support

• Entity Framework 5.0 Release Candidate is supported
• Changed the behavior: the Money data type is mapped to System.Decimal by default now when using Entity Data Model Wizard/Generate Database Wizard and Code-First CreateDatabase functionality
• Fixed an issue with creating MigrationHistory table (EF v4.3 and v5.0) when using protocol 3.0

5.80.350 26-Apr-12

• The IPv6 protocol is supported
• The PgSqlConnection.ClearAllPools(bool force) method is added
• Changed the behavior: the Money PostgreSQL data type is mapped to System.Decimal now
• Changed the behavior: the PgSqlDataReader.GetDateTime method returns DateTime with DateTimeKind.Local now
• Changed the behavior: the exception message when connecting to a non-existing database is "database ... does not exist" now
• Fixed an issue with decimal array as a parameter value of PgSqlType.Numeric
• Fixed an issue with multiple execution of stored procedures returning REF CURSORs
• Fixed an issue with generating the "Stream already closed!!!" error when retrieving invalid connection from the pool

Entity Developer

• The multiline popup editor for the Documentation.Summary property is implemented
• Fixed an issue with metadata processing in Visual Studio 11 Beta (Entity Framework models)

5.80.341 12-Apr-12

• Fixed an issue with the PgSqlDataReader.GetByte method when reading data from smallint column

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with the performance issues when generating complex queries

Entity Developer

• Changed the behavior: the Migrate option is added to the context menu of property in Model Explorer
• Changed the behavior: entities and enums on the designer surface are more resizable now
• Fixed an issue with creating LinqConnect models
• Fixed an issue with detecting many-to-many associations (Entity Framework models)

5.80.332 29-Mar-12

• The handling of empty options in the connection string is improved
• Fixed an issue with generating the "Connection must be opened" error when trying to commit/roll back transaction after expiration of command timeout

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with the generation of SQL queries including grouping by the whole entity

Entity Developer

• Fixed an issue with model saving after performing copy/paste of an element with a custom attribute
• Fixed an issue with incorrect generation of a create database script in the "Generate Database Script" wizard for Entity Framework models, which occurs when the Regenerate Storage checkbox is selected
• Fixed an issue with code generation for association basing on several EntityKey properties when using POCO Entity and Self-Tracking Entity Visual Basic templates (Entity Framework models)
• Fixed an issue with the "Update Model From Database" wizard showing isVersion columns as changed (LinqConnect models)

Entity Framework support

• Entity Framework 5.0 Beta 2 is supported
• Changed the behavior: Devart.Data.PostgreSql.Entity.Migrations.dll is built with the 4.3.1 version of EntityFramework.dll now
• Fixed an issue with using expression aliases in complex queries

5.80.325 15-Mar-12

• Visual Studio 11 Beta is supported
• The PgSqlParameter(String, String) constructor is removed to avoid ambiguity with the PgSqlParameter(String, object) overload
• Fixed an issue with transactions that require a long time for committing

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with column order in queries including the UNION clause
• Fixed an issue with InvalidOperationException on disposing data contexts

Entity Developer

• The copy/cut/paste functionality is added for objects of the conceptual part of a model
• The possibility to drag&drop properties between classes in Model Explorer is implemented
• The "HeaderTimestampVersionControlTag" generation template option is added for improving integration with version-control systems
• Fixed an issue with generating code when using stored procedures with multiple result set with the POCO Entity and Self-Tracking Entity templates (Entity Framework models)
• Fixed an issue with setting StoreGeneratedPattern to Identity for foreign key property of the child class when creating an association (Entity Framework models)
• Fixed an issue with generating mappings for many-to-many association of entity to itself

Entity Framework support

• Entity Framework 5.0 Beta 1 is supported
• SQL generation for .Any method in LINQ to Entities is improved

5.70.311 27-Feb-12

Entity Developer

• The validation of method parameters in LinqConnect models is added
• The context menu options for unchecking changed/added/dropped tables are implemented for the root nodes in the "Update To/From Database" wizards
• The possibility to rename the storage part of the model in Model Explorer is implemented (Entity Framework models)
• The diagram design is changed: an arrow (instead of a triangle) is used on the tip of an association now
• Fixed an issue with detecting FK constraints and associations
• Fixed an issue with setting comments for columns and tables in database

Entity Framework support

• Entity Framework 4.3 (Code First Migrations) is supported
• The conversion of .StartsWith, .Contains, .EndsWith to LIKE clause in the generated SQL for the case of expression-based condition is supported
• The Code-First Migrations behaviour is changed: if the nullable value of the property in migration is not set explicitly, the corresponding column will be created nullable
• The Edm.Reverse canonical function is supported for PostgreSQL servers of 9.1 and higher versions

5.70.302 09-Feb-12

• Fixed an issue with the Trim function in 'Query Builder'
• Fixed an issue with PgSqlDump.Backup(), when duplicating CREATE statements for some aggregate functions are generated

Entity Developer

• Fixed an issue with preserving the Validate Required property when saving the model
• Fixed an issue with Entity Developer tool windows being shown when debugging an application
• Fixed an issue with diagram representation in x64 environment
• Fixed an issue with parsing PgSqlConnection.ServerVersion for Beta editions of PostgreSQL server

5.70.293 27-Jan-12

• Fixed an issue with timezone retrieving by PgSqlDataReader.GetDateTimeOffset method

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with empty spaces in foreign key names generated by the CreateDatabase() method

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)
• Changed the behavior: database column comments are transfered to the Summary attribute of the Documentation property now
• Fixed an issue with resetting the Validate Required property after reopening model
• Fixed an issue with generating System.ComponentModel.DataAnnotations.KeyAttribute() for Primary Key columns
• Fixed an issue with a workability of documentation links on Start Page
• Fixed an issue with resetting the StoreGeneratedPattern attribute by the Update Model From Database wizard (Entity Framework models)

Entity Framework support

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

5.60.283 12-Jan-12

• Fixed an issue with performing an incorrect 'show bytea_output' query when activating a connection for PostgreSQL 8.4 and lower

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
• Changed the behavior: 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
• Changed the behavior: the Validate Max Length attribute is synchronized with the Max Length attribute of Property by default now
• Changed the behavior: the Validate Required attribute is synchronized with the Nullable attribute of Property by default now
• Changed the behavior: when selecting a property in the Model Explorer, the corresponding entity on the diagram does not expand if it is collapsed
• Fixed an issue with adding diagrams when the Notation parameter of the diagram "Property Details Level" is set to "Name And Type"
• Fixed an issue with changing the Type property simultaneously for several inheritances
• Fixed an issue with invalid Properties grid data refreshing for the selected attribute in the Attributes dialog
• Fixed an issue with formatting indents when generating code
• Fixed an issue with saving inheritance layout on the diagram
• Fixed an issue with incorrect model diagram saving after deleting a complex type from a diagram
• Fixed an issue when the names of constraints in the Store part of the model are not taken into account by Generate Database Script From Model wizard (Entity Framework models)
• Fixed an issue with Retrieve Data when using DbContext template (Entity Framework models)
• Fixed an issue with Table Per Hierarchy (TPH) when using abstract intermediate class between the base and derived classes (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
• Fixed an issue with using slashes in string parameters of the .Contains method

5.60.268 22-Dec-11

• Fixed an issue with setting the PrimaryKey attribute of DataTable.Constraints when editing an existing DataSet using DataSet Wizard

Entity Developer

• Fixed an issue with Visual Basic templates
• Fixed an issue with scanning the network, when setting the connection
• Fixed an issue with duplicating EntitySet attribute when using entity return type (Entity Framework models)

Entity Framework support

• Fixed an issue with generating CROSS JOIN statement when using LINQ to Entities
• Fixed an issue with config.DmlOptions.InsertNullBehaviour for non-EntityKey columns with initialized DefaultValue and StoreGeneratedPattern

5.60.258 08-Dec-11

• Fixed an issue with redundant backslashes in text parameters of unprepared commands

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with inserting both sides of a one-to-one relationship

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

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()
• Fixed an issue with generating SQL for EdmFunction

5.50.250 24-Nov-11

Entity Developer

• Fixed an issue related to Visual Studio crashes at query execution
• Fixed an issue with removing associations when updating the model

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
• Fixed an issue with bytea type when using protocol 2
• Fixed an issue with setting Port connection string parameter in Visual Studio connection editor to the value that is greater than 10000
• Fixed an issue with returning invalid connections to pool

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with updating explicitly attached entities

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)
• Fixed an issue with detecting whether Devart Entity Model is changed or not
• Fixed an issue with setting the Concealed Function property in Stored Procedure Editor
• Fixed an issue with creating an association between classes participating in a TPC inheritance hierarchy (Entity Framework models)
• Fixed an issue with the local settings used for the default value of DateTime fields (LinqConnect models)
• Fixed an issues with storage synchronization for TPC inheritance classes

Entity Framework support

• Fixed an issue with determining correct data types in columns of descendants in TPT and TPC hierarchies
• Fixed an issue with the TimeSpan parameters
• Fixed an issue with the Group By expression

5.50.237 19-Oct-11

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

LinqConnect (formerly known as LINQ to PostgreSQL)

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

Entity Developer

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

Entity Framework support

• Fixed an issue with config.Workarounds.DisableQuoting behaviour with checking DatabaseExists

5.50.228 29-Sep-11

• Fixed an issue with licensing WinForms projects in Delphi Prism
• Fixed an issue with workability of command timeout for prepared commands
• Fixed an issue with assigning the UnpreparedExecute option from connection string to the command

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with ordering queries with eager loading options
• Fixed an issue with caching queries performed via the ExecuteQuery method
• Fixed an issue with .Equals(null) conditions in LINQ queries

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
• Fixed an issue with saving a new solution provided that the Visual Studio option for 'Projects and Solutions -> Save new projects when created' is unchecked
• Fixed an issue with pluralization algorithm 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
• Fixed an issue with default mapping for PostgreSQL UUID columns in LinqConnect models
• Fixed an issue with incorrect determining of association multiplicity (redundant 'many-to-many') in LinqConnect models
• Fixed an issue with setting Extended Properties for RelationProperty

Entity Framework support

• Fixed an issue with executing Function Imports with enabled BatchUpdates
• Fixed an issue with Entity Data Model Wizard when creating a model
• Fixed an issue when PgSqlEntityProviderWorkaroundConfig.IgnoreSchemaName does not affect stored procedures

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

LinqConnect (formerly known as LINQ to PostgreSQL)

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

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
• Fixed an issue with saving custom attribute properties with default values in .edml files
• Fixed an issue with changing property names ("Index was outside the bounds of the array")
• Fixed an issue with an incorrect generation of the private variables names in Entity Framework models

Entity Framework support

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

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

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with deleting dependent entities when the 'main' one is modified
• Fixed an issue with update commands for Table Per Type inheritance

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
• Fixed an issue with wrong error placing in Model Explorer in Entity Framework models
• Fixed an issue with regeneration of the ed:Guid attribute of navigation properties after Update From Database wizard completes (Entity Framework models)

Entity Framework support

• The processing of LINQ expressions which work with literals is improved
• Fixed an issue with functions returning set of record
• Fixed an issue with insert into Identity single-column table

5.30.185 07-Jul-11

• SSPI authentication is supported
• Fixed an issue with multi value parameters in SQL Server Reporting Services
• Fixed an issue with securityTrimmingEnabled option of Site Map provider

LinqConnect (formerly known as LINQ to PostgreSQL)

• Fixed an issue with the 'Cannot remove an entity that has not been attached' error when using compiled queries

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)
• Fixed an issue with default value quotation in Entity Framework models
• Fixed an issue with Primary Key naming in case of many-to-many associations in Model First (LinqConnect models)

Entity Framework support

• Entity Framework 4.2 June 2011 CTP is supported
• Fixed an issue with Save All for the Read Only model files in Entity Framework models

5.30.172 15-Jun-11

LinqConnect (formerly known as LINQ to PostgreSQL)

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

Entity Developer

• Fixed an issue with Extended Properties handling
• Fixed an issue with setting the multiplicity of updated constraint in Entity Framework models

Entity Framework support

• The PgSqlFunctions.ILike support is added
• The update functionality for default values is improved
• Fixed an issue with ordering in subqueries
• Fixed an issue with Default Value and the Identity columns

5.30.165 01-Jun-11

• Fixed an issue with license check in ILMerged assembly
• Fixed an issue with PgSqlLoader when loading data with literal carriage return
• Fixed an issue with generating Insert/Update/Delete commands via TableAdapter Configuration Wizard

LinqConnect (formerly known as LINQ to PostgreSQL)

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

Entity Developer

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

Entity Framework support

• Processing of Edm.StartsWith, Edm.Contains, and Edm.EndsWith is improved
• Fixed an issue with the EndsWith method

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
• Fixed an issue with handled FormatExceptions when fetching data of the 'serial' data type
• Fixed an issue with Membership provider compatibility between .NET Framework 2.0 and 4.0
• Fixed an issue with launching Devart documentation via Start menu

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
• Fixed an issue with incorrect operation order during SubmitChanges() calls
• Fixed an issue with ArgumentExceptions thrown in background threads
• Fixed an issue with using public properties when refreshing or materializing an entity
• Fixed an issue with grouping a collection by a whole entity

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
• Fixed an issue with code generation for the 'Delete Rule' association property in LinqConnect models
• Fixed an issue with generation of attach/detach methods for many-to-many associations in LinqConnect models
• Fixed an issue with external mapping for LinqConnect models
• Fixed an issue with default values set via a function for string fields in LinqConnect models
• Fixed an issue with the "Access" combobox of the Association editor in LinqConnect models
• Fixed an issue with procedures that differ only by name in Database Explorer (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
• Fixed an issue with Entity Framework configurability

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 checkbox

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

 

 

---

© 2002-2025 Devart. All rights reserved.