dotConnect for PostgreSQL

dotConnect for PostgreSQL History

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

New features in dotConnect for PostgreSQL 8.1

The current build is 8.3.21 from 06-Jun-2024

Visual Studio 2022 version 17.5 Preview is supported
.NET 7 compatibility
PostgreSQL 15 is supported

Entity Framework:

Entity Framework Core 7.0.2 is supported
Entity Framework Core 6.0.13 is supported
Entity Framework Core 3.1.32 is supported

New features in dotConnect for PostgreSQL 8.0

.NET 6 compatibility.
macOS 11 Arm64 (or "Apple Silicon" or "Apple M1") support.
Windows 11 is supported.
Visual Studio 2022 version 17.2 is supported.
Visual Studio 2022 version 17.3 Preview is supported.

Entity Framework:

Entity Framework Core 6.0.5 is supported.
Entity Framework Core 5.0.17 is supported.
Entity Framework Core 3.1.25 is supported.

Entity Developer:

64-bit version of standalone Entity Developer application is added.
64-bit version of console Entity Developer application is added.

New features in dotConnect for PostgreSQL 7.24

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

Entity Developer

The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code
The behavior is changed: Devart.Data.MySql.Entity.EF5.dll compiled with .NET Framework 4.7 is used now in EF5 models

Entity Framework

The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.EF5.dll assembly compiled with .NET Framework 4.7 is added
The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Migrations.EF5.dll assembly compiled with .NET Framework 4.7 is added
The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Spatials.EF5.dll assembly compiled with .NET Framework 4.7 is added

New features in dotConnect for PostgreSQL 7.23

Entity Developer

The model validation is improved: the errors are generated for all entities with QueryType=True in EF Core Model when EF Core version=EF Core 1 in Model Settings

Entity Framework

Entity Framework Core 6.0.1 is supported
Entity Framework Core 5.0.13 is supported
Entity Framework Core 3.1.22 is supported
The config.SpatialOptions settings are supported in EF Core
NetTopologySuite 2.4.0 is supported in EF Core 3, EF Core 5, and EF Core 6

New features in dotConnect for PostgreSQL 7.22

The new features of PostgreSQL Server 14 are supported:

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

Entity Framework

Entity Framework Core 5.0.12 is supported
Entity Framework Core 3.1.21 is supported

New features in dotConnect for PostgreSQL 7.21

Entity Developer

The new property Validation Framework is implemented in the Data Transfer Object template for generating DataAnnotations attributes
The Uri data type is supported in EF Core Mode
The new option "Save connection to" is implemented in Model Settings of EF Core Model to provide the ability to store the connection string in "Model file", "Entity Developer storage", "Environment variable"
The new option "Enum Output" is added to the EF Core template to specify output for the generated enums
The new property Generate UnitOfWork Repository Properties (by default, True) is implemented in the Repository and Unit Of Work template of EF Core Model for accessing the collections of entities
The representation of one-to-one association with non-nullable properties on both ends is changed from 1 -> 1 to 0..1 -> 1 on a diagram in EF Core Model

Entity Framework

Entity Framework Core 5.0.10 is supported
Entity Framework Core 5.0.11 is supported
Entity Framework Core 3.1.19 is supported
Entity Framework Core 3.1.20 is supported
The SQL translation of the following class members used in LINQ query is supported 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

The SQL translation of the following class members used in LINQ query is supported 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

Mapping of System.Decimal to PostgreSQL DECIMAL with specified precision and scale in EF Core 5 is supported
Mapping of the PostgreSQL HSTORE data type to Dictionary, SortedDictionary, ImmutableDictionary, ImmutableSortedDictionary is supported in EF Core 3 and EF Core 5
The HasFilter extension on IndexBuilder in EF Core Migrations is supported in EF Core 3 and EF Core 5
Mapping of internet/intranet data type System.Uri to PostgreSQL TEXT is supported in EF Core 3 and EF Core 5
Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to PostgreSQL INET and MACADDR/MACADDR8 is supported in EF Core 5
The implementation of config.CodeFirstOptions.TruncateLongDefaultNames in EF6 .NET Standard compliant assemblies is improved: the generated names are constant, independent on a current domain and workstation
The definition of System.ICloneable is removed from .NET Framework assembly \Entity\EFCore3\Devart.Data.PostgreSql.Entity.EFCore.dll

New features in dotConnect for PostgreSQL 7.20

Visual Studio 2019 version 16.11 Preview 2.0 is supported
The new command line option /disablegac that disables adding assemblies to GAC is added
Using SslStream to create SSL connections for .NET Standard (.NET Core) Projects is implemented
Additional mode of parameter substitution in the query in the SSIS Data Flow Source component: substitution as is, without escaping

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
The new methods IsNotDistinctFrom() and IsDistinctFrom() are added to the Devart.Data.Linq.SqlMethods class

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
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
The new hotkey Alt+E is implemented in Property Editor for opening Column Editor in EF Core Model
.NET 6.0 is added 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
The behavior is changed: 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

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
The behavior is changed 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
The behavior is changed in Entity Developer embedded into Visual Studio: lower versions in the EF Core version property of Model Settings are not hidden any more
The behavior is changed in EF Core Model: QueryType=True is set now for all classes without PK
The behavior of the Regenerate Storage and Mapping functionality in EF Core Model is changed: 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
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
The new extended property Use Generic DbContextOptions Constructor Argument is added to model properties of EF Core Model
The new extended property Do Not Generate Constructor With DbContextOptions Argument is added to model properties of EF Core Model

Entity Framework

Entity Framework Core 5.0 is supported
Entity Framework Core 5.0.1 is supported
Entity Framework Core 5.0.2 is supported
Entity Framework Core 5.0.3 is supported
Entity Framework Core 5.0.4 is supported
Entity Framework Core 5.0.6 is supported
Entity Framework Core 5.0.7 is supported
Entity Framework Core 5.0.8 is supported
Entity Framework Core 3.1.10 is supported
Entity Framework Core 3.1.11 is supported
Entity Framework Core 3.1.12 is supported
Entity Framework Core 3.1.13 is supported
Entity Framework Core 3.1.15 is supported
Entity Framework Core 3.1.16 is supported
Entity Framework Core 3.1.17 is supported
The EF6 provider registration used with .NET Framework 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
The new metadata to describe autoincremental columns via annotations in EF Core Code-First Migrations are implemented
The behavior is changed: EF Core 3 assemblies available via NuGet package are compiled for .NET Standard 2.0 instead of .NET Standard 2.1
The behavior is changed: EF Core 2 assemblies are no longer available via NuGet package but created in the provider installation folder

New features in dotConnect for PostgreSQL 7.19

PostgreSQL 13 is supported
The behavior is changed: metadata returned by the GetSchema("Tables") and GetSchema("Columns") methods of PgSqlConnection are supplemented now with the list of Foreign tables and columns correspondingly

Entity Framework

Entity Framework Core 3.1.9 is supported

New features in dotConnect for PostgreSQL 7.18

Visual Studio 2019 version 16.8 Preview is supported
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

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
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

Entity Framework

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

New features in dotConnect for PostgreSQL 7.17

SQL Server Integration Services 2019 (SSIS 2019) is supported
The PgSqlDataTable and PgSqlDataSet classes are supported in .NET Standard 2.0
The behavior is changed: pool is automatically cleared when AppDomain is being closed
The behavior is changed: ReadOnly=true is no longer set for all columns in PgSqlDataTable.Columns when the query joins several tables

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
The overloads of Contains(), StartsWith(), EndsWith(), IndexOf(), Equals() methods, that accept StringComparison as an argument, are supported
The overload of Compare() method, that accepts StringComparison as an argument, is 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 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
.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
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

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 behavior is changed: 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 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
The behavior for the new EF, EF Core models is changed: Primitive Default Value Generation is set to Literal now instead of LiteralOrExpression
The behavior is changed: the names of system types are generated without "System." prefix now in EF Core models; for example, it is DateTime instead of System.DateTime
The behavior is changed: only one confirmation for executing a stored procedure is requested by Entity Developer when dragging the stored procedure from Database Explorer to Model Explorer or diagram surface
The behavior is changed: 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
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

Entity Framework 6.4.4 is supported
Entity Framework Core 3.1.1 is supported
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
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

New features in dotConnect for PostgreSQL 7.16

Entity Framework

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

New features in dotConnect for PostgreSQL 7.15

PostgreSQL 12 is supported
The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Manager
The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Editor

Entity Developer

The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported
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 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
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

Entity Framework

Entity Framework Core 3.0 is supported
Entity Framework 6.3 is supported
Entity Framework Core 2.2.6 is supported
The lock for Microsoft.EntityFrameworkCore dependency is added to the NuGet package Devart.Data.PostgreSql.EFCore
The SQL generation in case of config.QueryOptions.UseCSharpNullComparisonBehavior=true in EF1/EF4/EF5/EF6 is improved

New features in dotConnect for PostgreSQL 7.14

The integration with Visual Studio 2019 is improved: now the installation detects both 2019 Release and 2019 Preview versions

Entity Developer

Entity Framework 6.3 Preview 9 is supported for projects with target framework .NET Core 3 or .NET Standard 2.1
The behaviour is changed: a plural form of names ending with "s" now has a longer version (for example, status -> statuses)

Entity Framework

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

New features in dotConnect for PostgreSQL 7.13

Visual Studio 2019 is supported
Deprecated design-time Synchronous API calls are no longer used with Visual Studio 2019 and Visual Studio 2017
The behaviour is changed: now PgSqlDataAdapter performs inserts in a batch with protocol 3 when the UpdateBatchSize property is used and UnpreparedExecute is true for InsertCommand

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

Entity Framework

Entity Framework Core 2.2.4 is supported
The performance of Entity Data Model Wizard when retrieving foreign keys metadata is improved

New features in dotConnect for PostgreSQL 7.12

Visual Studio 2019 Release Candidate 4 is supported
PostgreSQL 11 is supported

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

Entity Developer

The multiple select functionality in EF Core Model is improved: now it allows setting PrimaryKey, ValueGenerated, Concurrency for several properties simultaneously

Entity Framework

Entity Framework Core 2.2.1 is supported
Entity Framework Core 2.2.3 is supported
The new extension method Database.IsPostgreSql() in EF Core 2 is implemented
The translation of single-char literal into SQL statement in EF Core 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

New features in dotConnect for PostgreSQL 7.11

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
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

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
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.

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
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>
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 is fixed 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

Entity Framework

Entity Framework Core 2.1.1 is supported
Entity Framework Core 2.1.2 is supported
Entity Framework Core 2.1.3 is supported
Entity Framework Core 2.1.4 is supported
The new static method SetDefault is added to the EntitySpatialServices class in EF5/EF6
The bit-wise functions OR, AND in EF Core are supported
The PgSqlFunctions.Unaccent method is implemented to provide accent insensitive search
The misleading "The current provider does not support ambient transactions." warning, generated by TransactionScope in EF Core 2.1, is disabled
The behavior is changed: the default value of config.QueryOptions.UseCSharpNullComparisonBehavior is true now in EF Core
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

New features in dotConnect for PostgreSQL 7.10

.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
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
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
The behaviour is changed: the License Key connection string parameter value is not sent to the dbMonitor instance when "Persist Security Info=false;"

LinqConnect (formerly known as LINQ to PostgreSQL)

.NET Standard 2.0 is supported
.NET Core 2.0 is supported
The performance of generating complex queries is improved
The generation of CROSS JOIN LATERAL and LEFT JOIN LATERAL when connecting to PostgreSQL Server 9.3 or higher is supported
The XmlMappingSource.FromResource method is supported in .NET Standard provider assemblies
A destructor for DataContext is added
The behavior is changed: all existing overloads of the method DataContext.Query() are replaced with DataContext.Query<TResult>(String,params Object[])
The behavior is changed: the License Key connection string parameter value is not sent to the LinqMonitor instance when "Persist Security Info=false;"

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
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
The ModelNameAsFilesPrefix property is implemented in the RepositoryAndUnitOfWork template
The behaviour is changed: a base class in TPT Inheritance is allowed to be abstract now (LinqConnect models)
Support for ASP.NET Core MVC is added to the MVC Controller template (Entity Framework models)
Support for ASP.NET Core MVC is added to the Data Annotations Metadata template (Entity Framework models)
Identity columns in PostgreSQL 10 are supported
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 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)
The process of synchronizing methods and parameters with database stored procedures in EF Core Model is improved (Entity Framework models)
The code generation for async method calls in the EF Core template is improved (Entity Framework models)

Entity Framework

Entity Framework Core 1.1.3 is supported
Entity Framework Core 1.1.4 is supported
Entity Framework Core 1.1.5 is supported
Entity Framework Core 2.0 is supported
Entity Framework Core 2.0.1 is supported
Entity Framework Core 2.0.2 is supported
Entity Framework Core 2.0.3 is supported
Entity Framework 6.2 is supported
The macaddr8 data type introduced in PostgreSQL 10 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 DeleteDatabaseBehaviour.Database value of the config.DatabaseScript.Schema.DeleteDatabaseBehaviour option in EF Core 2 is supported
The generation of the idempotent script in EF Core 2 Code-First Migrations for PostgreSQL 9.0 and higher is supported
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

New features in dotConnect for PostgreSQL 7.9

.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
The behaviour is changed: now a new GUID is generated for the MachineKeys container name when loading the application
The behaviour is changed: now the MachineKeys container is immediately removed after establishing a connection to the server, instead of waiting for the end of the process execution
The compatibility with Visual Studio 2017 Updates is improved

Entity Developer

The .NET Core projects in Visual Studio 2017 are supported
The possibility to use command interception for EF6 commands executed within batch updates is implemented
The new Raw SQL Query class property and SQL method property with the corresponding editors are implemented in Entity Framework Core
The Snake case in both Model and Database naming rules is supported via the new "Add underscore" option
The behaviour is changed: IsRequired(false / true) for navigation properties is always generated in EF Core fluent mapping now

Entity Framework

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 compatibility with ASP.NET Core Identity is improved

New features in dotConnect for PostgreSQL 7.8

Visual Studio 2017 is supported

LinqConnect (formerly known as LINQ to PostgreSQL)

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

Entity Framework

Entity Framework Core 1.1.1 is supported

New features in dotConnect for PostgreSQL 7.7

Visual Studio 2017 Release Candidate 4 is supported
PostgreSQL 9.6 is supported
The 'Do not install assemblies in the GAC' check box that allows disabling placing the provider assemblies to the GAC is added to the Install Wizard
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
The "Force IPv4" connection string parameter is added to PgSqlConnection for specifying whether to use only the IPv4 network protocol
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)

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
The behaviour is changed: 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

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
The AddUniqueConstraintOperation and DropUniqueConstraintOperation operations are supported in EF Core Code-First Migrations
The translation of collection's Contains method in LINQ query to SQL statement in EF Core is supported
The behaviour is changed: the functionality of SpatialServiceType.NetTopologySuiteSigned is moved to Devart.Data.PostgreSql.Entity.EF5.dll / Devart.Data.PostgreSql.Entity.EF6.dll
The behaviour is changed: the SQL statement CREATE/DROP SCHEMA is generated with the IF NOT EXISTS/IF EXISTS clause now

New features in dotConnect for PostgreSQL 7.6

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
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

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
The generation of static methods by the EntityObject template is supported via the new property Direct Call of EntityMethod (Entity Framework models)
The behaviour is changed: the ObservableCollection navigation properties are initialized now in a default class constructor (Entity Framework models)

Entity Framework

Entity Framework Core 1.0.1 is supported
The config.DatabaseScript.Table.Tablespace configuration option is added to specify the tablespace for tables created via the Code-First approach
The PgSqlConventionSetBuilder class is implemented in the Entity Framework Core 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
The DatabaseFacade.GetPgSqlConnection() extension method, which returns PgSqlConnection, is implemented in EF Core
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

New features in dotConnect for PostgreSQL 7.5

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
The new RestoreProgress event is added to the PgSqlDump class

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

Entity Framework Core RC2 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
Upgrade Wizard is improved for upgrading projects with the Entity Framework functionality

New features in dotConnect for PostgreSQL 7.4

Visual Studio 2015 is supported
PostgreSQL 9.5 is supported

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
The Parent property is added to the IInheritanceConfiguration interface

Entity Developer

The Use ObservableCollection property of the DbContext template is implemented (Entity Framework models)
The behaviour is changed: now the 1:1 and 1:0..1 associations are displayed differently on the diagram (LinqConnect models)

Entity Framework

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)

New features in dotConnect for PostgreSQL 7.3

Visual Studio 2015 Release Candidate is supported
The ADO.NET implementation of ASP.NET Identity support is added
- The ICloneable interface is implemented in the IdentityUser and IdentityRole classes
- The User_Id column in the AspNetUserClaims table is renamed to UserId
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<TIdentityUser, TKey>, IUserPhoneNumberStore<TIdentityUser, TKey>, IUserTwoFactorStore<TIdentityUser, TKey>, IUserLockoutStore<TIdentityUser, TKey> interfaces are implemented in the UserStore class
- 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 new IQueryableUserStore interface is implemented in the UserStore class
- The new IQueryableRoleStore interface is implemented in the RoleStore class
PgSqlUtils class is added
The PgSqlScript.Cancel() method is added to stop query execution
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
The functions with return type TABLE are added to the list of the functions in the DataSet wizard as a data source
The message of the exception, when an attempt to rollback a closed transaction is made, is improved
The Enterprise Library 6 support is added; all previous versions of Enterprise Library are no longer maintained
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
The enableExpiredSessionAutoDeletion and expiredSessionAutoDeletionInterval options for deleting expired sessions are added to the session-state store provider definition in the web.config file
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
The 'IgnoreUnnamedParameters' connection string parameter that disables unnamed parameters in queries, executed via the connection, is added
SSL renegotiation is supported
The PgSqlStatementExecute event is added to the PgSqlScript class
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
The behaviour is changed: now "DROP IF EXISTS" statements will be added to backup script for PostgreSQL server 8.2 and higher when PgSqlDump.IncludeDrop is used
The behaviour is changed: now the "SET AUTOCOMMIT = TRUE" command is not executed any more when a connection to a PostgreSQL server 7.4 or higher is opened
The behaviour is changed: now the statement for deleting defaults for columns before dropping a table with these columns is removed
The behaviour is changed: 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
The behaviour is changed: the instance_id field of the wf_activity_info table in Workflow Tracking implementation is of varchar(100) type now
The behaviour is changed: the PgSqlMonitor now hides information about the password connection string parameter
The behaviour is changed: UTC_TIMESTAMP() is used now in WF Services scripts for the DATETIME columns

LinqConnect (formerly known as LINQ to PostgreSQL)

The CommandTimeout property is added to the DataProvider class
The OpenConnection() method is added to the DataContext class
The JSON data type is supported
The JSONB data type is supported
The dependency on the System.Windows.Forms.dll assembly is removed

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)
The override modifier for DbSet class properties generated by DbContext templates is added (Entity Framework models)
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)
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)
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)
The support of ID generators for primary keys in the Fluent Mapping template is added (LinqConnect models)
The possibility of setting default values for enum properties is implemented (LinqConnect models)
The behaviour is changed: now partial configuration classes are generated when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseConfigurationClasses options (Entity Framework models)
The behaviour is changed: now paths to assemblies with attributes (Model Settings -> Model -> Attributes) are saved and used as relative paths
The behaviour is changed: 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)
The behaviour is changed: now the default value for the 'File Per Class' option of the DbContext template is True (Entity Framework models)
The behaviour is changed: 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
The behaviour is changed: now the default values are not set for string properties, that correspond to fields with the default values like expressions (Entity Framework models)
The behaviour is changed: Create Model Wizard / Update From Database import the timestamp columns with precision
The behaviour is changed: now Update To Database / Generate Database Script take into account precision of the timestamp columns

Entity Framework

SharpMap 1.1 is supported
NTS Topology Suite 1.13.2 is supported
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 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)
The generation of LEFT JOIN LATERAL and CROSS JOIN LATERAL is supported for PostgreSQL 9.3
The JSONB data type is supported
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
The database server version is added to the generated Code-First Migrations script
The releasing of memory, which was allocated for commands and readers of ObjectContext / DbContext, is improved
The config.SpatialOptions.PrecisionModel configuration option is added to specify the NetTopologySuite precision model scale factors
The performance of generating SQL for Enumerable.Contains in LINQ queries is improved by supporting a new expression type, DbInExpression, in Entity Framework 6
The behaviour is changed: now a semicolon (;) after the very last statement is generated in the Code-First CreateDatabaseScript() functionality
The behaviour is changed: 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
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
The behaviour is changed: 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
The behaviour is changed: now Entity Data Model Wizard/Designer imports the timestamp columns with precision
The behaviour is changed: now the Code-First CreateDatabase() functionality generates the timestamp columns with precision
The behaviour is changed: now Entity Data Model Wizard/Designer takes into account precision of the timestamp columns in Model First approach

12-December-13 New features in dotConnect for PostgreSQL 7.2

Workflow Foundation is supported
The behaviour is changed: IndexOutOfRangeException is generated now instead of InvalidOperationException when PgSqlDataReader.GetOrdinal(String name) finds nothing in the result set

LinqConnect (formerly known as LINQ to PostgreSQL)

The behaviour is changed: 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"
The behaviour is changed: now the CreateDatabase() method uses the same algorithm for naming foreign keys as in Entity Developer
The behaviour is changed: now the cascade deletion of tables in DeleteDatabase() method is performed via the "DROP TABLE CASCADE" statement

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)
The predefined templates (POCO Entity and LinqConnect) are improved: new template setting, "Generate Dummy Comments", is added (LinqConnect models)
More information messages, when validating EF6 models basing on the EntityFramework.dll functionality, are added (Entity Framework models)
The behaviour is changed: the validation of EF6 models depends on the EntityFramework.dll functionality only (.NET Framework 4.5 is not required any more) (Entity Framework models)

Entity Framework

The JSON data type is supported
The behaviour is changed: 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
The behaviour is changed: Code-First Migrations generates DEFAULT values for new NOT NULL columns of Boolean, Guid, DateTime, TimeSpan types when adding them in the existing table
The behaviour is changed: Code-First Migrations does not generate the unicode attribute if it is not specified in the mapping explicitly

31-October-13 New features in dotConnect for PostgreSQL 7.1

Visual Studio 2013 is supported
The behaviour is changed: installation with the /VERYSILENT install parameter will uninstall the other version of the provider without any dialog box if it is installed
The behaviour is changed: now a transaction rollbacks on Connection.Close() if Transaction.Commit() was not called before closing the connection

LinqConnect (formerly known as LINQ to PostgreSQL)

The possibility to inherit from the data provider classes is added

Entity Developer

Entity Framework 6 is supported
The new "Provider Manifest Token" model property is implemented to identify the target server (Entity Framework models)
The behaviour is changed: 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

The 6.0.0 and 6.0.1 versions of Entity Framework are supported
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
The compatibility of Entity Framework provider for EF v1, v4, v5 with medium trust level environment is improved
The behaviour is changed: Entity Data Model Wizard shows a more detailed error message in case of connecting to unsupported database or using incorrect provider manifest tokens

17-October-13 New features in dotConnect for PostgreSQL 7.0

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

LinqConnect (formerly known as LINQ to PostgreSQL)

The Collate method of the SqlMethods class is implemented

Entity Developer

The predefined templates are improved: new template setting, "Use Compiled Query Cache", is added (LinqConnect models)

Entity Framework

The behaviour is changed: Code-First Migrations generates DEFAULT 0 for new NOT NULL columns of numeric types when adding them in the existing table
The behaviour is changed: Code-First Migrations generates DEFAULT '' for new NOT NULL columns of string types when adding them in the existing table

05-September-13 New features in dotConnect for PostgreSQL 6.8

Visual Studio 2013 Release Candidate is supported
SSIS DataFlow Source and Destination components for PostgreSQL are implemented
The overload for the PgSqlLargeObject.Open() method with the PgSqlLargeObjectOpenMode parameter is added

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

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)
The behaviour is changed: 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)

Entity Framework

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
The behavior is changed: the strict FetchAll = True for created SQL commands is removed; now the behavior is determined by the connection string parameter "Default FetchAll"

18-July-13 New features in dotConnect for PostgreSQL 6.7

SQL Server 2012 Reporting Services is supported
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

Entity Developer

Support for spatial data types in Entity Framework 5 and 6 is added
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
The behaviour is changed: a default value for the "Detect Table Per Type inheritances" option in Model settings is set to False
The behaviour is changed: the possibility to exclude the generation of keys (primary, foreign) in "Update Database From Model" and "Generate Database Script From Model " wizards is added
The behaviour is changed: the possibility to add one-to-one associations with nullable foreign key properties is added (LinqConnect models)
The behaviour is changed: now by default MVC Controller template generates files in the model folder, MVC View Advanced template creates files in the Views model subfolder
The behaviour is changed: 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

Entity Framework

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 "Unprepared Execute" connection string parameter is supported by Entity Framework runtime
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

04-April-13 New features in dotConnect for PostgreSQL 6.6

The "AllowDateTimeOffset" connection string parameter for returning the TimeStampTZ database value like System.DateTimeOffset by PgSqlDataReader is implemented
The CommitTimeout property of the PgSqlConnection object is implemented to determine timeout period for the Commit method
The behaviour is changed: provider's build action is installed on the target workstation, on which .NET Framework is available, without Visual Studio integration

LinqConnect (formerly known as LINQ to PostgreSQL)

LINQPad integration is supported
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
The performance when working with the TPT-inheritance and retrieving descendants via OfType<> is improved

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 box 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 box)
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 box)
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" check box, 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" check box 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
The Save and Refresh buttons for persisting and reloading changes to / from a database is added to the Retrieve Data grid
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
Devart.Data.Linq.Binary type is added to the "Type Mapping Rule Editor" (LinqConnect models)
The "Rewrite connection string during regeneration" check box 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)
The "Regenerate Storage and Mapping" option for regenerating model parts, specific to the database server, is added to the diagram shortcut menu
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)
POCO Entity template is improved: new template setting, "Property Change Notifiers", is added (LinqConnect 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 box 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
Storage Entity Editor is improved: the capability to edit extended columns settings, such as facets, is added (Entity Framework models)
The behaviour is changed: "Save connection string in App.Config as" check box in Model Settings dialog box is renamed to "Use connection string from App.Config as" (LinqConnect models)
The behaviour is changed: now, when creating a new TPH discriminator column in Inheritance Editor, it has the string type by default
The behaviour is changed: the error is generated if the Abstract inheritance modifier is set for the class which is involved in the Table Per Type inheritance
The behaviour is changed: empty value is used in property editors instead of -1 for marking facets of class property without assigned value
The behaviour is changed: System.DateTime .NET structure is mapped to TIMESTAMP database type when using Model First approach (LinqConnect models)
The behaviour is changed: a string default value for the property can be set without quotes in the Properties window
The behaviour is changed: the validation error is not generated when an abstract class is used in Table Per Type inheritance (Entity Framework models)
The behaviour is changed: auto-implemented properties are generated when DbContext template is used with ImplementINotifyPropertyChanged=False and ImplementINotifyPropertyChanging=False (Entity Framework models)
The behaviour is changed: DatabaseGeneratedOption is always generated for EntityKey properties when using fluent mapping (Entity Framework models)

Entity Framework

Entity Framework 6 Beta 1 is supported
The Database value is added to the DeleteDatabaseBehaviour enumeration for creating/removing database in Code-First
The datetimeoffset pseudo type of SSDL, which corresponds to System.DateTimeOffset, is implemented
The config.DatabaseScript.ForeignKey.Enabled option (default value is True) is added to turn on/off generation of foreign key constraints
The error messages about long identifiers when using CreateDatabase/DropDatabase are improved
The behaviour is changed: CreateDatabase()/Code-First with DeleteDatabaseBehaviour.Schema does not try to create a schema if it exists

28-February-13 New features in dotConnect for PostgreSQL 6.5

ExtendedMembership (SimpleMembership) provider support is added

Entity Developer

The possibility of setting enum values via predefined dropdown list in the Retrieve Data window is implemented
The behaviour is changed: the Guid property is mapped to the UUID type in the database when using the Model First approach (LinqConnect models)

Entity Framework

Entity Framework 6 Alpha 3 is supported

17-January-13 New features in dotConnect for PostgreSQL 6.4

Entity Developer

The behaviour is changed: the serializing property and corresponding methods are not generated when using 'Fluent Mapping'/'POCO Entity' templates and Unidirectional mode (LinqConnect models)
The behaviour is changed: warnings about tables/views without primary keys are written to Error List window when generating a model (Entity Framework models)
The behaviour is changed: 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)
The behaviour is changed: empty value is used in property editors instead of -1 for marking facets of Storage Column without assigned value (Entity Framework models)

Entity Framework

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

20-December-12 New features in dotConnect for PostgreSQL 6.3

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
The behaviour is changed: Configure Behaviour dialog is renamed to Stored Procedure Mapping; options for hiding inappropriate and mapped stored procedures are added (Entity Framework models)
The behaviour is changed: Table Editor dialog is renamed to Storage Entity Editor (Entity Framework models)
The behaviour is changed: Stored Procedure Editor dialog is renamed to Storage Procedure Editor (Entity Framework models)
The behaviour is changed: Configure Behaviour dialog is renamed to Stored Procedure Mapping (LinqConnect models)

06-September-12 New features in dotConnect for PostgreSQL 6.2

Visual Studio 2012 is supported
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
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

LinqConnect (formerly known as LINQ to PostgreSQL)

The fluent mapping is improved: support of the ID generators for primary keys is added

Entity Developer

Support for ADO.NET Entity Framework 5 is added
Predefined template for generating Repositories and Unit of Work classes is added
Integration with Visual Studio refactoring for renaming model objects is implemented
The possibility to set different namespaces for the context and its entities when using the DbContext template is implemented (Entity Framework models)
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
The 'Entity Base' class property, which allows specifying the ancestor class/interface for a particular entity type, is implemented (LinqConnect models)
The behaviour is changed: 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)
The behaviour is changed: 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

The support of the PostgreSQL full-text search functionality is implemented
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
The behaviour is changed: Devart.Data.PostgreSql.Entity.Migrations.dll is built with the 4.4 version of EntityFramework.dll now

17-July-12 New features in dotConnect for PostgreSQL 6.1

The behaviour is changed: when a connection is terminated, PgSqlAlerter waiting process is terminated too and an exception is thrown

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
The behaviour is changed: the warning, related to the missing property setter, is disabled (LinqConnect models)
The behaviour is changed: for the association, in which the many-side entity hasn't the primary key, the code and the mapping are not generated (LinqConnect models)
The behaviour is changed: the properties, that correspond autoincrement fields, are generated with a ReadOnly keyword in VB.NET (LinqConnect models)

Entity Framework

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 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)
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
The behaviour is changed: in case of using Code-First (Migrations) EF v4.x/5.x the schema name 'dbo' will be ignored by default

22-May-12 New features in dotConnect for PostgreSQL 6.0

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
The behaviour is changed: the 'sender' parameter in MonitorEventHandler is a connection and the MonitorEventArgs.ExtraInfo property is filled with the connection string
The behaviour is changed: the access modifier of the connectionString field of web provider classes is changed from private to protected

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
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)
The behaviour is changed: context menu commands for working with diagram are grouped to the Diagram submenu of the context menu
The behaviour is changedr: the possibility to change diagram shape color via the corresponding Shape -> Color context menu command is added
The behaviour is changed: when pasting a copied entity to a new diagram, a new entity is not created, the existing entity is added to this diagram
The behaviour is changed: when cutting an entity from the diagram, the entity is not cut from the model, only from the diagram
The behaviour is changed: "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)
The behaviour is changed: the Money data type is mapped to System.Decimal by default now when using Database First approach (Entity Framework models)

Entity Framework

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
The behaviour is changed: 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

15-Mar-12 New features in dotConnect for PostgreSQL 5.80

Visual Studio 11 Beta is supported
The IPv6 protocol is supported
The PgSqlConnection.ClearAllPools(bool force) method is added
The behaviour is changed: the Money PostgreSQL data type is mapped to System.Decimal now
The behaviour is changed: the PgSqlDataReader.GetDateTime method returns DateTime with DateTimeKind.Local now
The behaviour is changed: the exception message when connecting to a non-existing database is "database ... does not exist" now
The handling of empty options in the connection string is improved
The PgSqlParameter(String, String) constructor is removed to avoid ambiguity with the PgSqlParameter(String, object) overload

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
The multiline popup editor for the Documentation.Summary property is implemented
The behaviour is changed: the Migrate option is added to the context menu of property in Model Explorer
The behaviour is changed: entities and enums on the designer surface are more resizable now

Entity Framework

Entity Framework 5.0 Beta 2 is supported
SQL generation for .Any method in LINQ to Entities is improved
The behaviour is changed: Devart.Data.PostgreSql.Entity.Migrations.dll is built with the 4.3.1 version of EntityFramework.dll now

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

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

Entity Framework

Entity Framework 4.3 (Code First Migrations) is supported
The validation of identifier name length in Code-First Migrations is implemented
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

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

Entity Developer

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

Entity Framework

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

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

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

LinqConnect (formerly known as LINQ to PostgreSQL)

Fluent Mapping support is added

Entity Developer

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

Entity Framework

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

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

DbTransactionBase class is added
TransactionStateChanging and TransactionStateChanged events are added to the DbConnectionBase class
Policy file for the Devart.Data.PostgreSql.Entity assembly is added
SSPI authentication is supported
The License Information Wizard is improved: it now generates licenses for projects that have Entity Framework models or refer to Devart.Data.PostgreSql.Web, but have no direct references to Devart.Data.PostgreSql.dll
The support of events which occur when connections are taken and returned to pool for processing PgSqlMonitor.TraceEvent is added
The PgSqlDump.BlockSize property is implemented to control the size of data block when making dump of large object
The "Use schema name" and "Use catalog name" check boxes are added to DataSet Wizard

LinqConnect (formerly known as LINQ to PostgreSQL)

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

Entity Developer

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

Entity Framework

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

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

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

LinqConnect (formerly known as LINQ to PostgreSQL)

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

Entity Developer

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

Entity Framework

Entity Framework 4.1 RTW supported

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

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

LinqConnect (formerly known as LINQ to PostgreSQL)

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

Entity Developer

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

Entity Framework

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

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

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

LinqConnect (formerly known as LINQ to PostgreSQL)

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

Entity Developer

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

Entity Framework

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

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

Supported Visual Studio 2010
Install Wizard improved (ability to automatically uninstall previous version added)
ADO.NET Data Services v1.5 CTP2 supported
Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors
Changed queries for retrieving metadata to match the escape symbols rules for PostgreSQL 8.4

LINQ to PostgreSQL

Added support for XML type
Added support for specific dynamic expressions

Entity Framework

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

Entity Developer

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

20-Nov-09 New features in dotConnect for PostgreSQL 4.65

Integration with improved dbMonitor added
Implemented Ping method in PgSqlConnection class
Added orderid column for Site Map provider for custom map node ordering
Added some DataSet Wizard design-time improvements
Changed default behaviour of DataSet generation: if index is set as an expression, this index will be ignored

LINQ to PostgreSQL

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

Entity Developer

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

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

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

LINQ to PostgreSQL

Added support of the String.IsNullOrEmpty() method

Entity Developer 2.20

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

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

Added PgSqlAlerter class to handle LISTEN/NOTIFY commands
Supported binary mode in PgSqlLoader
New database object types supported in PgSqlDump
Added PgSqlArray class to support PostgreSQL ARRAY data type
Added support for SSL connections
Added PgSqlLargeObject class to support PostgreSQL large objects

LINQ to PostgreSQL

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

Entity Developer 2.00

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

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

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

Entity Framework support

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

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

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

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

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

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

Added DB server-based data paging for web applications
PgSqlDataSource design time improvements
ASP.NET demo pack added
PgSqlSelectStatement.TryParse method added
DataLink.DataSource property can refer to another DataLink component

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

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

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

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

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

Supported Visual Studio codename Orcas Beta 1
Supported .NET Entity Framework
Added support for x64 architecture
Enhanced command builder with generation of row refresh statements
Added DbCommand.GetRecordCount() method to determine rows count of a request
Added INullable interface for provider specific types
Added capability to store connection strings in application settings
Extended drag'n'drop capabilities in DataSet Manager
Add-in menu moved to Visual Studio package
Demo projects reorganized
Added CRM (Customer Relationship Management) demo project
Added Ping demo project for Mobile Edition

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

Application development enhancement

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

.NET 2 features

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

Other features

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

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

Windows Vista support added

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

Implemented advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SqlDataSource
ASP.NET 2.0 providers added: Membership Provider, Profile Provider, Role Provider, Session State Provider
DataSet Wizard added
Enterprise Library Data Access Application Block support added
Mono support added
Borland Delphi 2006 support added
EnterpriseDB Postgre SQL Server supported
Provider invariant name changed
Added streaming support for PgSqlScript
Added list of Frequently Asked Questions

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Support for Borland Delphi 8 added

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

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

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

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

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