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)
http://www.devart.com/dotconnect/entityframework.html