Today we are excited to share with you the plan for Entity Framework Core 6.0.
This plan brings together input from many stakeholders and outlines where and how we intend to invest for the Entity Framework (EF Core) 6.0 release. This plan is not set-in-stone and will evolve as we work on the release based on what we learn. This learning includes feedback from people like you, so please let us know what you think!
IMPORTANT This plan is not a commitment. It is a starting point that will evolve as we learn more. Some things not currently planned for 6.0 may get pulled in. Some things currently planned for 6.0 may get punted out.
General information
EF Core 6.0 is the next release after EF Core 5.0 and is currently scheduled for November 2021 at the same time as .NET 6. EF Core 6.0 will align with .NET 6 as a long-term support (LTS) release.
EF Core 6.0 will likely target .NET 6 when released. It is unlikely to support any .NET Standard version. It will not run on .NET Framework. See the future of .NET Standard for more information.
Themes
Highly requested features
As always, a major input into the planning process comes from the voting (👍) for features on GitHub. For EF Core 6.0 we plan to work on the following highly requested features:
- SQL Server temporal tables
- Allow temporal tables to be created via Migrations, as well as allowing access to historical data through LINQ queries.
- JSON columns
- Introduce common patterns for JSON support that can be implemented by any database provider.
- JSON column support will be implemented for SQL Server and SQLite. (Note that the PostgreSQL and MySQL providers already support JSON columns.)
ColumnAttribute.Order- Allow arbitrary ordering of columns when creating a table with Migrations or
EnsureCreated.
- Allow arbitrary ordering of columns when creating a table with Migrations or
Performance
While EF Core is generally faster than EF6, there are still areas where significant improvements in performance are possible. We plan to tackle several of these areas in EF Core 6.0, while also improving our perf infrastructure and testing.
- Performance infrastructure and new tests
- Improve the infrastructure for performance tests as well as adding new tests and fixing low-hanging fruit.
- Compiled models
- Compiled models will improve startup performance, as well as having generally better performance when accessing the model.
- TechEmpower Fortunes
- We plan to match Dapper performance on the TechEmpower Fortunes benchmark. (This is a significant challenge which will likely not be fully achieved. Nevertheless, we will get as close as we can.)
- Linker/AOT
- We will continue investigating in making EF Core work better with linkers and AOT. We do not expect to fully close the gap in the 6.0 timeframe, but we hope to make significant progress.
Migrations and deployment
Following on from the investigations done for EF Core 5.0, we plan to introduce improved support for managing migrations and deploying databases. This includes two major areas:
- Migrations bundles
- Migrations bundles will provide a simple, robust mechanism for deploying EF Core migrations.
- Managing migrations
- We plan to improve the tools and project/assembly management for EF Core migrations.
Improve existing features and fix bugs
- EF6 query parity
- We plan to close the query gap to EF6 and make supported EF Core queries a true superset of supported EF6 queries.
- Value objects
- We plan to introduce a better experience focused on the needs of value objects in domain-driven design.
- This approach will be based on value converters rather than owned entities which have proved not to be a good fit.
- Cosmos database provider
- We are actively gathering feedback on which improvements to make to the Cosmos provider in EF Core 6.0; please make sure to vote (👍) for the Cosmos features that you need.
- Expose model building conventions to applications
- Model building conventions are currently controlled by the database provider. In EF Core 6.0, we intend to allow applications to hook into and change these conventions.
- Zero bug balance (ZBB)
- We plan to fix all outstanding non-blocked bugs during the EF Core 6.0 timeframe.
- Miscellaneous smaller features
- Split query for non-navigation collections
- Detect simple join tables in reverse engineering and create many-to-many relationships
- Complete full/free-text search on SQLite and SQL Server
- SQL Server Spatial Indexes
- Mechanism/API to specify a default conversion for any property of a given type in the model
- Use the new batching API from ADO.NET
.NET integration
The EF Core team also works on several related but independent .NET Data technologies. In particular, we plan to work on:
- Enhancements to
System.Data- Implementation of the new batching API
- Continued work with other .NET teams and the community to understand and evolve ADO.NET
- Standardize on
DiagnosticSourcefor tracing inSystem.Datacomponents
- Enhancements to
Microsoft.Data.Sqlite- Connection pooling
- Prepared statements
- Nullable reference types
- We will annotate the EF Core code to use nullable reference types.
Experiments and investigations
The EF team is planning to invest time during the EF Core 6.0 timeframe experimenting and investigating in two areas. This is a learning process and as such no concrete deliverables are planned for the 6.0 release.
- SqlServer.Core
- An experiment in collaboration with the community to determine what potential there is modern .NET features in a highly performant SQL Server driver.
- GraphQL
- We plan to investigate the space and collaborate with the community to find ways to improve the experience of using GraphQL with .NET.
Find out more
This post is a brief summary of the full EF Core 6.0 Plan. Please see the full plan for more information.
Suggestions
Your feedback on planning is important. The best way to indicate the importance of an issue is to vote (👍) for that issue on GitHub. This data will then feed into the planning process for the next release.
In addition, please comment on this post if you believe we are missing something that is critical for EF Core 6.0, or are focusing on the wrong areas.
Thank you for the informative post,
Are there any plans for squashing the migrations automatically?
How about support for mapping a VARBINARY column as a Stream? We are currently having to fall back to using ADO.NET SqlDataReader to accomplish this. Support in EF Core directly would be great.
Hope to see more support for Hot Chocolate!, it really works well with EF, is extensible and so easy to get started, has many ways to approach something that it does not force the dev to write code in a manner that don’t like, with the GraphQL .NET Client that are working on, it really raises the desire to use GraphQL in .NET.
Good job to the EF team and blessings!
Hello.
Are you planning to implement Entity splitting support (http://github.com/dotnet/efcore/issues/620) in EF Core 6.0?
It is vital for EF6 feature parity.
Hi Jeremy;
I'd would like to add my second suggestion.
As SPA apps becoming more populate with great UX, one important and desired feature that users want to see, is "Real Time" data update. Google's Firestore offers that out of the box with their SDK. They offer hooks in the client side, where when data is changed on the server side, the hook gets triggered and offers fresh data to client that was changed and if...
Mapping stored procedures to CRUD operations?
Probably the wrong place for this question….
Will we ever get support for C# Stored Procs in Azure SQL? This seems like something that would enable EF Core to communicate directly with procs running in the Database and would be blindingly fast. You could create a proc with a persistent bidirectional socket to a DbContext that would allow for streaming data on demand in Desktop applications.
So the requests for Visual Studio tooling keeps being ignored, back to EF 6.
Telling us that payed for Visual Studio Professional for such features, to go look around alternatives is no answer.
EFCorePowerTools ?
There is one very big feature I miss. The changetracker should have weak references to entities that are unchanged or detached. That way you would not need so shortlived dbcontext’s because you get rid of the memory leaks. It has been a very big issue since the start. The other thing is better support for bulk update queries directly on DbSets to also update tracked entities. Default should be nontracking on queries.
Disappointing plan. Nothing I want to see
Seems like more like maintenance.
Leading into LTS I wouldn’t expect a lot of new stuff.