New features in the Entity Framework support!

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Locked
Devart
Site Admin
Posts: 3276
Joined: Tue 26 Oct 2004 13:51

New features in the Entity Framework support!

Post by Devart » Fri 09 Dec 2016 14:01

Dear users,

We are glad to announce the new features that are available in the Entity Framework support in the latest version:
  • 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 (MySQL, Oracle, PostgreSQL, DB2)
  • The OracleJsonFunctions class is implemented in EF4/EF5/EF6 to use JSON functions and operators in LINQ to Entities queries (Oracle)
  • The PgSqlJsonFunctions and PgSqlJsonbFunctions classes are implemented in EF4/EF5/EF6 to use JSON/JSONB functions and operators in LINQ to Entities queries (PostgreSQL)
  • The MySqlJsonFunctions class is implemented in EF4/EF5/EF6 to use JSON functions in LINQ to Entities queries (MySQL)
  • The JSON datetype is supported in EF mapping (MySQL)
  • Signed versions of NetTopologySuite GIS library are supported in EF5/EF6 (MySQL, Oracle, PostgreSQL)
  • NetTopologySuite 1.14 is supported in EF5/EF6 (MySQL, Oracle, PostgreSQL)
  • GeoAPI 1.7.4 is supported in EF5/EF6 (MySQL, Oracle, PostgreSQL)
  • The NetTopologySuiteSigned and NetTopologySuiteUnsigned members are added to the SpatialServiceType enum in EF5/EF6 (MySQL, Oracle, PostgreSQL)
  • The new config.DatabaseScript.Column.StringColumnCustomCollationName option is implemented for setting user-defined function for comparing string columns (SQLite)
  • The config.DatabaseScript.Schema.DeleteDatabaseBehaviour option is supported in EF Core (MySQL, Oracle, PostgreSQL, DB2)
  • The behaviour is changed: the functionality of SpatialServiceType.NetTopologySuiteSigned is moved to Devart.Data.Oracle.Entity.EF5.dll / Devart.Data.Oracle.Entity.EF6.dll (Oracle)
  • The behaviour is changed: the functionality of SpatialServiceType.NetTopologySuiteSigned is moved to Devart.Data.MySql.Entity.EF5.dll / Devart.Data.MySql.Entity.EF6.dll (MySQL)
  • The behaviour is changed: the functionality of SpatialServiceType.NetTopologySuiteSigned is moved to Devart.Data.PostgreSql.Entity.EF5.dll / Devart.Data.PostgreSql.Entity.EF6.dll (PostgreSQL)
  • The behaviour is changed: now by default System.DateTimeOffset is mapped to the datetime MySQL data type using CreateDatabase()/Code-First approach (MySQL)
  • The behaviour is changed: the SQL statement CREATE/DROP SCHEMA is generated with the IF NOT EXISTS/IF EXISTS clause now (PostgreSQL)
  • The behaviour is changed: the errors thrown by executing SQL statement CREATE/DROP USER are ignored now (Oracle)
  • The behaviour is changed: the errors thrown by executing SQL statement DROP SCHEMA are ignored now (DB2)
  • The bug with comparison in LINQ query when config.QueryOptions.UseCSharpNullComparisonBehavior=true is fixed (MySQL, Oracle, PostgreSQL, SQLite, DB2)
  • The bug with shortening PK, FK, IX, UX names in the Code-First CreateDatabase/CreateDatabaseScript functionality when config.CodeFirstOptions.TruncateLongDefaultNames=True is fixed (MySQL, Oracle, PostgreSQL, DB2)
  • The bug with generating incorrect data types for 'tinytext', 'text', 'mediumtext' columns set via attribute / fluent mapping in the Code-First CreateDatabase/CreateDatabaseScript functionality is fixed (MySQL)
  • The bugs with logical expressions in EF Core are fixed (MySQL, Oracle, PostgreSQL, SQLite, DB2)
  • The bug with boolean literal constants in the generated SQL statements in EF Core is fixed (Cloud providers)
  • The bug with adding all available objects to the model (instead of the selected ones) by EDM Wizard is fixed (Oracle)
  • The bug with setting binary data types via Code-First mapping in EF4/EF5/EF6 is fixed (MySQL)
  • The bug with requesting extra privileges when preparing stored procedure is fixed (MySQL)
  • The bug with creating database objects in the same schema by several EF6 contexts in Code-First approach is fixed (Oracle)
  • The bug with returning DbProviderServices in EF1 / EF4 is fixed (Salesforce)
Devart development team
http://www.devart.com/dotconnect/entityframework.html

Locked