New features in the Entity Framework support!

Devart · Post by **Devart** » Thu 29 Nov 2018 12:29

Dear users,

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

The PgSqlFunctions.Unaccent method is implemented to provide accent insensitive search (PostgreSQL)
The bug with quoting the table alias, that includes an invalid character, in the SQL query generated by EF Core is fixed (MySQL, Oracle, PostgreSQL, SQLite, DB2)
The bug with generating a subquery within the IN clause in EF Core 2 is fixe (MySQL, Oracle, PostgreSQL, SQLite, DB2)
The bug with generating a subselect within the CASE clause in EF Core 2 is fixed (MySQL, Oracle, PostgreSQL, SQLite, DB2)
The bug with comparing columns, that use a value converter, to parameters and constants in EF Core 2 is fixed (MySQL, Oracle, PostgreSQL, SQLite, DB2)
The bug with quoting the zero date default value in the generated SQL by CreateDatabase() in EF4/EF5/EF6 is fixed (MySQL)
The bug with loosing precision of DateTimeOffset properties in EF6 / EF Core Code-First is fixed (MySQL)
The bug with loading both Devart.Data.MySql.Entity.EF4.dll and Devart.Data.MySql.Entity.EF5.dll in the process of EF4 application is fixed (MySQL)
The bug with throwing "ORA-00936: missing expression" in EF Core is fixed (Oracle)
The bug with using parentheses in binary expressions in EF Core is fixed (Oracle)
The bug with loading both Devart.Data.Oracle.Entity.EF4.dll and Devart.Data.Oracle.Entity.EF5.dll in the process of EF4 application is fixed (Oracle)
The bug with loading both Devart.Data.PostgreSql.Entity.EF4.dll and Devart.Data.PostgreSql.Entity.EF5.dll in the process of EF4 application is fixed (PostgreSQL)