New features in the Entity Framework support!

Devart · Post by **Devart** » Thu 21 Nov 2019 15:26

Dear users,

We are glad to announce the new features that are available in the Entity Framework support in the latest version:

The config.DatabaseScript.PrimaryKey.IndexTablespace configuration option is added to specify the tablespace for implicit PK indices created via the Code-First approach (Oracle)
Support for changing NULL/NOT NULL constraint for LOB columns in the AlterColumn operation of EF Core Code-First Migrations is added (Oracle)
The SQL generation in case of config.QueryOptions.UseCSharpNullComparisonBehavior=true in EF1/EF4/EF5/EF6 is improved (MySQL, Oracle, PostgreSQL, SQLite, DB2)
The bug with using Scaffold-DbContext in EF Core 3 is fixed (MySQL, Oracle, PostgreSQL, SQLite)
The bug with the redundant empty ORDER BY clause in a subquery, when paging is used, in EF Core 3 is fixed (MySQL, Oracle, PostgreSQL, SQLite)
The bug with generating invalid SQL when calling members of owned type in EF Core 2 is fixed (MySQL, Oracle, PostgreSQL, SQLite, DB2)
The bug with throwing "ORA-12704: character set mismatch" in case of UNION ALL over OUTER APPLY/CROSS APPLY in EF1/EF4/EF5/EF6 is fixed (Oracle)
The bug with using .Contains within .Select of LINQ query in EF Core 2 is fixed (MySQL, Oracle, PostgreSQL, SQLite, DB2)