New features in the Entity Framework support!

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Locked
Devart
Site Admin
Posts: 3280
Joined: Tue 26 Oct 2004 13:51

New features in the Entity Framework support!

Post by Devart » Fri 24 Nov 2017 05:53

Dear users,

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

Locked