Devart is glad to announce the release of the new version of dotConnect for MySQL, enhanced database connectivity solution, built over the ADO.NET architecture, that supports Entity Framework and LinqConnect ORM solutions.
New version of dotConnect for MySQL offers you support for Entity Framework Spatials and SQL Server 2012 Reporting Services support.
Entity Framework Spatials Support
dotConnect for MySQL 7.7 introduces Entity Framework Spatials support for Entity Framework 5 and 6. MySQL provides only basic spatial functionality, however it can be sufficient for some tasks. dotConnect for MySQL provides the best possible support for existing MySQL spatial features and additionally implements the calculation of distances on the surface of a spheroid, which is not supported in MySQL out-of-the-box. dotConnect for MySQL supports the MBR-based MySQL functions in Entity SQL and LINQ to Entities.
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 MySQL 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 MySQL 7.7.287 features:
- SQL Server 2012 Reporting Services is supported
- The bug with column order in DataTable, which is populated by the Fill method of the MySqlDataAdapter object, 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
- MySQL spatial 'geometry' data type support in Entity Framework 5 and 6 is added
- Devart.Data.MySql.Entity.dll assembly built with the 4.5 version of .NET Framework is added
- Devart.Data.MySql.Entity.Migrations.dll assembly built with the 5.0 version of EntityFramework.dll is added
- The MySqlSpatialFunctions class for working with MySQL spatial functions in LINQ to Entities is added
- The Database value is added to the DeleteDatabaseBehaviour enumeration for creating/removing database, which is specified in the Database connection string parameter, when using CreateDatabase()/DropDatabase() functionality
- 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/mysql/