New features in the Entity Framework support!

Devart · Post by **Devart** » Fri 10 Aug 2018 07:52

Dear users,

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

The new static method SetDefault is added to the EntitySpatialServices class in EF5/EF6 (MySQL, Oracle, PostgreSQL)
The performance in case of the CROSS APPLY/OUTER APPLY operations is improved: only one database query is sent to the server now instead of many SELECTs with executing part of operations locally (Oracle, PostgreSQL)
The behavior is changed: the default value of config.QueryOptions.UseCSharpNullComparisonBehavior is true now in EF Core
The bug with SQL generation for comparing column with parameter in EF Core 2 is fixed
The bug with using the RenameIndex operation, when index name exceeds a max length allowed by the server and has to be transformed to a shorter name, in EF Core Code-First Migrations is fixed (MySQL, Oracle, PostgreSQL, DB2)
The bug with incorrect generation of shortened PK/FK/IX/UX names in EF Core when using .NET Standard provider assemblies is fixed (MySQL, Oracle, PostgreSQL, SQLite, DB2)
The bug with the IS NULL clause in SELECT projection in EF Core is fixed (Oracle)
The bug with quoting a stored function name, when the FunctionName argument of the DbFunction attribute includes package and/or schema names, in EF Core 2 is fixed (Oracle)
The bug with using ORDER BY to sort by constant or parameter instead of column in EF Core is fixed (Oracle)