We are glad to announce the new features that are available in the Entity Framework support in the latest version:
- Entity Framework 6.2 is supported
- The SQL generation for subselects, when using Distinct(), in EF1/EF4/EF5/EF6 is optimized (MySQL, Oracle, PostgreSQL, SQLite, DB2)
- The identity columns in PostgreSQL 10 are supported in Entity Data Model Wizard (classic EF) and in Scaffold-DbContext (EF Core) (PostgreSQL)
- The config.DatabaseScript.Schema.EnsureSchemaBehaviour option is added for controlling behaviour of the EnsureSchema operation in EF Core (PostgreSQL)
- The Code-First Migrations functionality in EF Core is improved:
- the operations InsertData / UpdateData / DeleteData (introduced in EF Core 2), AlterSequence are supported (Oracle)
- the operations InsertData / UpdateData / DeleteData (introduced in EF Core 2), EnsureSchema (creates database if not exists), DropSchema (removes database) are supported (MySQL)
- the operations InsertData / UpdateData / DeleteData (introduced in EF Core 2), EnsureSchema (creates schema if not exists), DropSchema (removes schema), CreateSequence, AlterSequence, RestartSequence are supported (PostgreSQL)
- the operations InsertData / UpdateData / DeleteData (introduced in EF Core 2) are supported (SQLite)
- the operations InsertData / UpdateData / DeleteData (introduced in EF Core 2), CreateSequence, AlterSequence, RestartSequence, DropSequence are supported (DB2)
- The bug with using multiple .Include() in EF Core 2 is fixed
- The bug with processing conditions in LINQ queries with joins in EF Core is fixed
- The bug with using collections in a .Contains() method in EF Core 2 is fixed (MySQL, Oracle, PostgreSQL, SQLite, DB2)
- The bug with JOIN conditions in SQL generated from LINQ query in EF1/EF4/EF5/EF6 is fixed (MySQL, Oracle, PostgreSQL, SQLite, DB2)
- The bug with using UseOracle(DbConnection) extension method of DbContextOptionsBuilder in EF Core is fixed (Oracle)
- The bug with using UseMySql(DbConnection) extension method of DbContextOptionsBuilder in EF Core is fixed (MySQL)
- The bug with using UsePostgreSql(DbConnection) extension method of DbContextOptionsBuilder in EF Core is fixed (PostgreSQL)
- The bug with using UseSQLite(DbConnection) extension method of DbContextOptionsBuilder in EF Core is fixed (SQLite)
- The bug with using UseDB2(DbConnection) extension method of DbContextOptionsBuilder in EF Core is fixed (DB2)
- The bug with Database.ExecuteSqlCommand(), when the second parameter passed is a collection of the OracleParameter objects, in EF Core is fixed (Oracle)
- The bug with generating SQL aliases in EF Core 2 is fixed (Oracle)
- The bug with invoking Database.EnsureDeleted(), when pooling for the corresponding connection is turned on, in EF Core is fixed (SQLite)
- The bug with using Add-Migration in Package Manager Console for adding code-based Code-First Migrations in EF Core 2 is fixed (MySQL, DB2)
http://www.devart.com/dotconnect/entityframework.html