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