How is the Entity Framework NET

Over 80 new features in Entity Framework Core 5.0

The version of the OR-Mapper released on November 10th contains numerous innovations.

The Entity Framework Core 5.0, now published on NuGet.org, is the successor to Entity Framework Core 3.1, which was released in December 2019. Version 4.0 was left out in alignment with .NET 5.0. Unlike .NET Core 3.1 (predecessor of .NET 5.0), Entity Framework Core has not lost the "Core" in its name in order to continue to clearly distinguish itself from the classic Entity Framework (current version 6.4).

Not for classic .NET framework

Entity Framework Core 5.0 does not only run on .NET 5.0, but on all platforms that offer .NET Standard 2.1 (e.g. .NET Core 3.1 and current Xamarin versions). The classic .NET framework is therefore excluded, since it only implements .NET Standard 2.0 in the latest version 4.8.

This means that developers who have previously used Entity Framework Core 1.0 to 3.1 on the classic .NET Framework are now at a dead end. As for .NET Core 3.1, support for Entity Framework Core 3.1 is only available until December 3, 2022.

betterCode () presents: .NET 5.0 - The online event on December 3rd, 2020

Here's what you can learn:

  • From .NET Framework to .NET Core to .NET 5.0: What does this mean for the migration and how big is the effort?
  • What's new in .NET 5.0?
  • New features: Get to know ASP.NET Core 5.0 and Blazor 5.0
  • The most important language innovations in C # 9
  • Mobile development with .NET 5
  • OR mapping with Entity Framework Core 5.0
  • WinUI 3 as an alternative to WPF and UWP
  • Outlook on .NET 6.0

Lots of new features

Entity Framework Core 5.0 offers over 80 innovations (cf. 15-part tweet series by Arthur Vickers). In a nutshell, the following significant improvements result:

  • Abstraction of N: M relationships (no explicit .NET class required for intermediate tables)
  • Table-per-type mapping (TPT) as an alternative to table-per-hierarchy (TPH)
  • Mapping of the .NET data types and to character string columns
  • Extension of the Fluent API, for example precision for decimal numbers with and fill factor for SQL Server indices with, persistent calculated columns with and as a setting for sorting and comparing. Another new feature is that tables can also be excluded from the schema migrations.
  • New annotation, and as an alternative to the Fluent API
  • Extensions to the command line commands
  • Eager loading with filter (Filtered Include)
  • Split the queries when eager loading with and
  • Other scalar database functions
  • Simple display of the SQL command belonging to a LINQ query with and as well as in the Visual Studio Debugger via Debugger View
  • Simplified configuration of SQL logging with
  • Detailed error messages with
  • Eliminate duplicate objects in no-tracking queries with or
  • Developers can use to reset the state of a context.
  • There are the new methods and for obtaining context instances.
  • Savepoints and transaction IDs are now supported for transactions.
  • For the first time it is possible for the OR mapper to use a database view for reading the data but a table for writing to a single entity class.
  • Table-valued functions can now not only be called with, developers can also easily provide wrapper methods in the context class.
  • Microsoft has added events that are triggered when saving:, and. Developers can influence the storage process at the same time.
  • With Indexer Properties based on C # indexers, software developers can add columns to existing entity types and also create completely new dynamic entity types with database mapping at runtime.
  • Operators of an application can now call up the OR mapper's event counters for diagnosis.

Holger Schwichtenberg

Dr. Holger Schwichtenberg is Chief Technology Expert at MAXIMAGO, which offers innovation and experience-driven software development, including in highly critical security-related areas. He is also head of the expert network www.IT-Visions.de, which, with 38 renowned experts, supports numerous medium-sized and large companies with advice and training in the development and operation of software.

Read CV ยป