Devart is glad to announce the release of the new version of dotConnect for PostgreSQL, enhanced database connectivity solution, built over the ADO.NET architecture, that supports Entity Framework and LinqConnect ORM solutions.
New version of dotConnect for PostgreSQL offers you support for Entity Framework Spatials and SQL Server 2012 Reporting Services support.
Entity Framework Spatials Support
dotConnect for PostgreSQL 6.7 introduces Entity Framework Spatials support for Entity Framework 5 and 6. dotConnect for PostgreSQL supports the following spatial services:
- NetTopologySuite spatial service
- Well-Known Text (WKT) spatial service
- Extended Well-Known Text (EWKT) spatial service
- Well-Known Binary (WKB) spatial service
You can read more about new features of Entity Framework Spatials support in our Enhanced Entity Framework Spatials support for Oracle, MySQL and PostgreSQL blog article.
SQL Server 2012 Reporting Services Support
New version of dotConnect for PostgreSQL now can be used in Reporting Services projects for the latest version of SQL Server. Now our users can benefit from Power View in Microsoft Excel 2013 and Power View in Microsoft SharePoint 2013, SharePoint 2013 and SharePoint 2010 integration, data alerts and other new SQL Server 2012 Reporting Services features.
Here is the complete list of dotConnect for PostgreSQL 6.7.287 features:
- SQL Server 2012 Reporting Services is supported
- The bug with the Cancel method of PgSqlCommand when using CommandBehavior.SequentialAccess is fixed
- The bug with incorrect registration PgSqlExtendedMembershipProvider in machine.config file is fixed
- The bug related to the NRE on the CreateDatabase() method, when the navigation properties generation for one of the sides in one-to-one association is turned off, is fixed
- The bug with wrong script generation on the CreateDatabase() method for one-to-one associations is fixed
- The bug with materialization when converting decimal values is fixed
- The bug related to the "Sequence contains no elements" exception when working with unmapped properties and PropertyChanging/PropertyChanged events is fixed
- The bug related to materializing structs in the "select new" clause is fixed
- The bug related to the "Method not found" exception when opening connection in LINQPad via LinqConnectDriver is fixed
- Support for spatial data types in Entity Framework 5 and 6 is added
- The behaviour is changed: a default value for the "Detect Table Per Type inheritances" option in Model settings is set to False
- The bug related to the wrong Source values for foreign key properties when adding associations with the selected "Add foreign key properties to the child class" check box is fixed
- The bug with applying RangeAttribute of the DataAnnotation validation framework for nullable properties is fixed
- The bug with parsing *.edmx is fixed (Entity Framework models)
- Support for spatial data types in Entity Framework 5 and 6 is added
- NetTopologySuite GIS library support in Entity Framework 5 and 6 is added
- PostGIS 'geometry' and 'geography' data type support in Entity Framework 5 and 6 is added
- Devart.Data.PostgreSql.Entity.dll assembly built with the 4.5 version of .NET Framework is added
- Devart.Data.PostgreSql.Entity.Migrations.dll assembly built with the 5.0 version of EntityFramework.dll is added
- The PgSqlSpatialFunctions class for working with PostGIS spatial functions in LINQ to Entities is added
- The config.Workarounds.UseInvariantProviderManifestToken configuration option (default value is False) is added to provide the possibility of returning the invariant string literal as the provider manifest token
- The config.SqlFormatting.Identation option is renamed to config.SqlFormatting.Indenting
- The bug with using delimiter when generating Code-First Migrations script via the ScriptUpdate method of the MigratorScriptingDecorator class in Entity Framework 6 is fixed
http://www.devart.com/dotconnect/postgresql/