.NET Data Biweekly Updates (2022)

[ajcvickers]

Biweekly status updates for 2022

For 2023, see Latest news and progress on .NET 8 and EF8

For previous years, see:

• 2021
• 2020
• 2019

[ajcvickers]

January 13, 2022

Expand to see status from this week...

Highlights

• The plan for EF7 is published to our docs!
  • As always, feedback is greatly appreciated
• .NET Blog: A Comprehensive Guide to Port from EF6 to EF Core
  • How to port from EDMX/Code First/Database First
  • Detailed cases to consider
• EF Core 6.0.1 is on NuGet
  • 6.0.2 scheduled for February

Latest Community Standup: The EF7 Plan

The plan for EF7 has been published. In this episode, the EF Core/.NET Data team reviews the details of the plan and answers live questions about the roadmap.

The .NET Data Community Standups are live-streamed every other Wednesday to Twitch, YouTube, and Twitter. This is your opportunity to interact with the .NET Data team and community. All past episodes are available on YouTube.

Comment on GitHub with ideas for guests, demos, or anything else you want to see.

EF Core 7.0

EF Core 7.0 (EF7) will be the next release after EF Core 6.0. It will be released alongside .NET 7 in November 2022.

The EF Core 7.0 Plan is available publicly in our documentation. As always, feedback is greatly appreciated. This plan is not set-in-stone; we expect it will evolve throughout the release cycle as we learn.

Each high-level area for EF Core 7.0 is linked in the table below together with its current high-level status.

EF Core 7.0 Theme	Feature	Status
Highly requested features	JSON columns	Planned
	Bulk updates	Planned
	Lifecycle hooks	Planned
	Table-per-concrete-type (TPC) mapping	In-progress
	Map CUD operations to stored procedures	Planned
	Value objects	Planned
	Support value generation when using value converters	Planned
	Raw SQL queries for unmapped types	Planned
	Database scaffolding templates	Planned
.NET platforms and ecosystem	Distributed transactions	Planned
	EF Core tooling	Planned
	EF Core and graphical user interfaces	Planned
	SqlServer.Core (Woodstar)	Planned
	Azure Cosmos DB provider	Planned
	Migrations experience	Planned
	Trimming	In-progress
	Evolve System.Linq.Expression	Planned
	Translate new LINQ operators	Planned
	Open telemetry for ADO.NET providers	Planned
	Enhancements to System.Data	Planned
	Research data access for cloud-native	Planned
Clear path forward from EF6	Issue #214: Expose model building conventions to applications	Planned
	Issue #245: Map inserts, updates, and deletes (CUD operations) to stored procedures	Planned
	Issue #620: Entity splitting support	Planned
	Issue #3170: TPC inheritance mapping pattern	In-progress
	Issue #3864: Support unidirectional many-to-many relationships through shadow navigations	Planned
	Issue #4038: Code templates for scaffolding entity types and DbContext from an existing database	Planned
	Issue #10753: Support raw SQL queries without defining an entity type for the result	Planned
	Issue #11003: KeyAttribute support for composite primary key	Planned
	Issue #11624: Support raw SQL Queries for basic types like Guid, DateTime and int	Planned
	Issue #15911: Implement ObjectMaterialized event	Planned
	Issue #17653: Support for GroupBy entityType	Planned
	Issue #19929: Support GroupBy when it is final operator	Planned
	Issue #19930: Support GroupJoin when it is final query operator	Planned
	issue #26626: Use EF6 as an oracle for procedural testing of EF Core queries	Planned
Performance	Performance of database inserts and updates	Planned
	TechEmpower composite score	In-progress

Burndown for EF Core 7.0

This is the burndown chart the team uses internally to track progress towards EF Core 7.0.

• The gray bar at the top represents all the issues already fixed for EF7.
  • The "Closed" category includes only issues that have been fixed and then closed, not issues closed for any other reason.
  • The "Fixed" category includes issues that have been fixed, but where the change has not yet been merged to the "main" branch.
• As always, we are aiming to be feature-complete by the beginning of September.

EF Core 6.0.1

The latest patch release of EF Core 6.0 is available on NuGet now. This is a patch release of EF Core 6.0 containing only important bug fixes:

• DateTime with z suffix is not respected when reading entities
• 'The object has been removed from the model.' when building model
• EF Core 6.0 regression when using HasDefaultSchema() with ToTable(null)
• Variable names must be unique within a query batch or stored procedure
• Stack overflow when using circular composite key dependencies
• SqliteConnectionFactory.cs is not thread-safe
• EF Core 6.0 InvalidOperationException: The object has been removed from the model
• Subquery.Contains throws when the type of item is value type
• Query with n:m relation adds non-existent column
• InvalidOperationException "sequence contains no matching element" in TableReferenceExpression.get_Table
• Update from 5.0.1 to 6.0breaks all SqliteConnection
• Scaffolder throws error if junction table foreign key columns have identical names
• EFCore 6 - NullReferenceException upon EnsureDeleted
• Non-nullable value comparer can't be applied on nullable type
• Exception in SQL server query in EF Core 6, looks related to HasQueryFilter(), worked in EF Core 5
• RC2 Sqlite provider no longer clears temporary files on exit
• The dotnet ef dbcontext scaffold command does not print all expected logs

EF Core 5.0.13

EF Core 5.0.13 is available on NuGet now. This is a patch release of EF Core 5.0 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.12.

EF Core 3.1.22

EF Core 3.1.22 is available on NuGet now. This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.21.

Pull requests merged since the last update

Community contributions

• @yecril71pl: WithMany doc: fix the sample expression
• @vslee: fix typo in 7.0 plan.md
• @okyrylchuk: Fix CosmosModelConfigurationSample
• @aileen-r: Fix minor typo: code-first/migrations/team.md
• @virzak: Fix command execution on wrong table
• @Maniizzle: Clean OnConfiguring Method
• @kostat: Update EntityLinq library description
• @AshkanAbd: Update supported versions of EFCore for EFCore.SoftDelete package

Many thanks to all our contributors!

EF Core

• Documentation
  • Fix spelling in LoggingDefinitions.LogSaveChangesCanceled
  • EF6 to EF Core porting guide
  • Update scaffolding.md
  • Document good pagination practices
  • Add a workaround for IDesignTimeDbContextFactory with UseModel breaking change
  • Fix grammar typo on value conversions page
  • Document UseQueryTrackingBehavior
  • Update index.md
  • Move DbContext Pooling from Miscellaneous TOC to DbContext config
  • Documentation on provider specification tests
  • Amend split query note on EF Core versions
  • Document IExecutionStrategy lifetime breaking change
  • Document Cosmos throughput configuration
  • Fix broken links in porting guide
  • Fix some xrefs
• Query
  • No test left behind: Ef6GroupByTest
  • Static analysis: protect against mutating fields in hash calculations
  • Fix cancellation test flakiness
  • Grinding the gears of war
  • (6.0.2) Add DynamicDependency on System.Math for trimming
  • (6.0.2) Query: Assign proper type to CollectionResultExpression
  • (6.0.2) Lift GroupByAggregate when correlation predicate matches
  • (6.0.2) Query: Update column expression correctly when lifting joins from group by aggregate subquery
  • (6.0.2) Avoid stackoverflow in lifting group by aggregate term
  • (6.0.2) Put parentheses around IS NULL for non-bool operands
  • Fix baselines for IS NULL change
• Miscellaneous
  • Enable strict compilation
  • Add Xunit.Abstractions to implicit usings
  • Call sync connection close instead of async
  • Update NuGet packages
• Migrations
  • Use conventions and model snapshot in the migration tests
  • (6.0.2) Bundles: Allow argument separator (--)
  • Use the default schema for migration data operations
• Model building
  • (6.0.2) Stop prefixing check constraints
  • Remove quirk for #27059
• Proxies
  • (6.0.2) Avoid proxying Clone methods on record types
  • Remove quirk for #26602
• SaveChanges
  • Tweak SaveChangesAsync_accepts_changes_with_ConfigureAwait_true_22841
  • Don't issue a warning when replacing an optional dependent with non-null values
• Change tracking
  • Add Property/Reference/etc overloads that take IProperty/INavigation
• Trimming/AOT
  • Stop using GetRequired* reflection wrappers to enable trimming
• Tools
  • Use App.config on .NET Core

Microsoft.Data.Sqlite

• Test on .NET Framework

Builds to use

• The daily builds are the most up-to-date available.
  • The daily builds now contain all issues merged for 6.0.x patch releases, as well as new code to be released in EF7 preview 1.
• LTS: EF Core 6.0.1
• Supported: EF Core 5.0.13
• Supported: EF Core 3.1.22

Releases

See GitHub Releases and EF Core releases and planning (Roadmap) in our documentation for full details.

Weekly/biweekly updates from previous years

• 2021
• 2020
• 2019

Feedback

Comments are disabled on this issue to reduce noise. Please use the related discussion issue for any comments on these status updates.

[ajcvickers]

January 27, 2022

Expand to see status from this week...

Highlights

• Extensive new documentation on testing EF Core applications
  • Testing with your production database system
  • Testing with a database test double (e.g. SQLite)
  • Mocking and repository patterns
• EF7 work progressing:
  • New feature merged: Index sort order
  • TPC and JSON column work in progress
  • Making SQLite/WASM eaier in progress
• Unicorns Kickin`: The Entity Framework Rap

Latest Community Standup: Testing EF Core Apps

What’s the best way to run automated tests on an application that uses Entity Framework Core? In this episode, Jon P Smith (@thereformedprog), author of the book “Entity Framework Core in Action” covers three ways to create automated tests for your code and looks at the EF Core test “pain points” and how to get around them.

The .NET Data Community Standups are live-streamed every other Wednesday to Twitch, YouTube, and Twitter. This is your opportunity to interact with the .NET Data team and community. All past episodes are available on YouTube.

Comment on GitHub with ideas for guests, demos, or anything else you want to see.

EF Core 7.0

EF Core 7.0 (EF7) will be the next release after EF Core 6.0. It will be released alongside .NET 7 in November 2022.

The EF Core 7.0 Plan is available publicly in our documentation. As always, feedback is greatly appreciated. This plan is not set-in-stone; we expect it will evolve throughout the release cycle as we learn.

Each high-level area for EF Core 7.0 is linked in the table below together with its current high-level status.

EF Core 7.0 Theme	Feature	Status
Highly requested features	JSON columns	In-progress
	Bulk updates	In-design
	Lifecycle hooks	Planned
	Table-per-concrete-type (TPC) mapping	In-progress
	Map CUD operations to stored procedures	Planned
	Value objects	Planned
	Support value generation when using value converters	Planned
	Value objects	Planned
	Raw SQL queries for unmapped types	Planned
	Database scaffolding templates	Planned
.NET platforms and ecosystem	Distributed transactions	Planned
	EF Core tooling	Planned
	EF Core and graphical user interfaces	Planned
	SqlServer.Core (Woodstar)	Planned
	Azure Cosmos DB provider	Planned
	Migrations experience	Planned
	Trimming	In-progress
	Evolve System.Linq.Expression	Planned
	Translate new LINQ operators	Planned
	Open telemetry for ADO.NET providers	Planned
	Enhancements to System.Data	Planned
	Research data access for cloud-native	Planned
Clear path forward from EF6	Issue #214: Expose model building conventions to applications	Planned
	Issue #245: Map inserts, updates, and deletes (CUD operations) to stored procedures	Planned
	Issue #620: Entity splitting support	Planned
	Issue #3170: TPC inheritance mapping pattern	Planned
	Issue #3864: Support unidirectional many-to-many relationships through shadow navigations	Planned
	Issue #4038: Code templates for scaffolding entity types and DbContext from an existing database	Planned
	Issue #10753: Support raw SQL queries without defining an entity type for the result	Planned
	Issue #11003: KeyAttribute support for composite primary key	Planned
	Issue #11624: Support raw SQL Queries for basic types like Guid, DateTime and int	Planned
	Issue #15911: Implement ObjectMaterialized event	Planned
	Issue #17653: Support for GroupBy entityType	Planned
	Issue #19929: Support GroupBy when it is final operator	Planned
	Issue #19930: Support GroupJoin when it is final query operator	Planned
	issue #26626: Use EF6 as an oracle for procedural testing of EF Core queries	Planned
Performance	Performance of database inserts and updates	Planned
	TechEmpower composite score	In-progress

Burndown for EF Core 7.0

This is the burndown chart the team uses internally to track progress towards EF Core 7.0.

• The gray bar at the top represents all the issues already fixed for EF7.
  • The "Closed" category includes only issues that have been fixed and then closed, not issues closed for any other reason.
  • The "Fixed" category includes issues that have been fixed, but where the change has not yet been merged to the "main" branch.
• As always, we are aiming to be feature-complete by the beginning of September.

EF Core 6.0.1

The latest patch release of EF Core 6.0 is available on NuGet now. This is a patch release of EF Core 6.0 containing only important bug fixes:

• DateTime with z suffix is not respected when reading entities
• 'The object has been removed from the model.' when building model
• EF Core 6.0 regression when using HasDefaultSchema() with ToTable(null)
• Variable names must be unique within a query batch or stored procedure
• Stack overflow when using circular composite key dependencies
• SqliteConnectionFactory.cs is not thread-safe
• EF Core 6.0 InvalidOperationException: The object has been removed from the model
• Subquery.Contains throws when the type of item is value type
• Query with n:m relation adds non-existent column
• InvalidOperationException "sequence contains no matching element" in TableReferenceExpression.get_Table
• Update from 5.0.1 to 6.0breaks all SqliteConnection
• Scaffolder throws error if junction table foreign key columns have identical names
• EFCore 6 - NullReferenceException upon EnsureDeleted
• Non-nullable value comparer can't be applied on nullable type
• Exception in SQL server query in EF Core 6, looks related to HasQueryFilter(), worked in EF Core 5
• RC2 Sqlite provider no longer clears temporary files on exit
• The dotnet ef dbcontext scaffold command does not print all expected logs

EF Core 5.0.13

EF Core 5.0.13 is available on NuGet now. This is a patch release of EF Core 5.0 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.12.

EF Core 3.1.22

EF Core 3.1.22 is available on NuGet now. This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.21.

Pull requests merged since the last update

Community contributions

• @cocowalla: fix: #27138, stream with 64-bit PK
• @Marusyk: Add overload to SqlServerDbContextOptionsBuilder.EnableRetryOnFailure with errorNumbersToAdd without forcing maxRetryCount and maxRetryDelay
• @kaypee90: [Fixes grammatical error in EF Core Advanced Performance Topics Doc, under Compiled queries]
• @Azayzel: Update Spelling
• @v-haiboz: Task#536167:[Refresh link]Replace bookmarks in repo

Many thanks to all our contributors!

EF Core

• Query
  • There's no escape from those cold north winds
  • Update NorthwindMiscellaneousQueryCosmosTest.cs
  • (6.0.2) Match joined tables properly when lifting for group by aggregate
  • Don't skip any parameter in projection
  • Mark SelectExpression as immutable after projection has been applied
  • Fix non-deterministic tests that fail on postgres
  • Convert query tests to conditional theory
• Dependencies
  • Reverting SqlClient package upgrade to fix build
  • Update to SqlClient 4.0
  • Bump Microsoft.AspNetCore.OData from 8.0.4 to 8.0.6
  • Bump SQLitePCLRaw to 2.0.8-pre20220111224339
  • Start flowing Microsoft.Data.SqlClient again
  • Bump Microsoft.Data.SqlClient from 4.0.0 to 4.0.1
• Documentation
  • Fix typos in PropertyAccessMode
  • Some provider writer instructions on SQL baselines
  • Fix some API links
  • Improve testing docs
• Miscellaneous
  • Remove nullability errors
  • Remove quirks
• Temporal tables
  • Temporal table support for owned and table splitting scenarios
  • Fix to #26676 - EF Core 6 - IsTemporal adds an unnecessary migration when DefaultSchema is configured at the DbContext Level
• Model building
  • Add support for index sort order (descending)
• Change tracking
  • Correct TrackGraph nullability

Builds to use

• The daily builds are the most up-to-date available.
  • The daily builds now contain all issues merged for 6.0.x patch releases, as well as new code to be released in EF7 preview 1.
• LTS: EF Core 6.0.1
• Supported: EF Core 5.0.13
• Supported: EF Core 3.1.22

Releases

See GitHub Releases and EF Core releases and planning (Roadmap) in our documentation for full details.

Weekly/biweekly updates from previous years

• 2021
• 2020
• 2019

Feedback

Comments are disabled on this issue to reduce noise. Please use the related discussion issue for any comments on these status updates.

[ajcvickers]

February 28, 2022

Expand to see status from this week...

Highlights

• EF Core 7.0 (EF7) preview 1 is on NuGet now
  • Preview 1 does not contain any big new features. However, preview 1 does contain 29 bug fixes and 30 smaller enhancements. See the GitHub release page for more information.
• EF Core 6.0.2 is on NuGet now with 15 important bug fixes. See the GitHub release page for more information.

Apologies for the short break in biweekly updates. Barring unforeseen circumstances, we are now back to our regular cadence.

Latest Community Standup: Celebrating 20 Years of .NET: Entity Framework

As .NET celebrates its 20th birthday, Entity Framework approaches its 10-year anniversary of going open source. The Entity Framework team celebrates these milestones by inviting back the engineers and program managers who helped shipped previous versions to share their stories, demos, and anecdotes. Join Tim Laverty, Rowan Miller, Danny Simmons, Diego Vega, Andrew Peters, Julie Lerman, and the team for this special edition of the .NET Data community standup.

The .NET Data Community Standups are live-streamed every other Wednesday to Twitch, YouTube, and Twitter. This is your opportunity to interact with the .NET Data team and community. All past episodes are available on YouTube.

Comment on GitHub with ideas for guests, demos, or anything else you want to see.

EF Core 7.0

EF Core 7.0 (EF7) will be the next release after EF Core 6.0. It will be released alongside .NET 7 in November 2022.

The EF Core 7.0 Plan is available publicly in our documentation. As always, feedback is greatly appreciated. This plan is not set-in-stone; we expect it will evolve throughout the release cycle as we learn.

Each high-level area for EF Core 7.0 is linked in the table below together with its current high-level status.

EF Core 7.0 Theme	Feature	Status
Highly requested features	JSON columns	In-progress
	Bulk updates	In-design
	Lifecycle hooks	Planned
	Table-per-concrete-type (TPC) mapping	In-progress
	Map CUD operations to stored procedures	Planned
	Value objects	Planned
	Support value generation when using value converters	Planned
	Value objects	Planned
	Raw SQL queries for unmapped types	Planned
	Database scaffolding templates	In-progress
.NET platforms and ecosystem	Distributed transactions	Planned
	EF Core tooling	Planned
	EF Core and graphical user interfaces	Planned
	SqlServer.Core (Woodstar)	Planned
	Azure Cosmos DB provider	Planned
	Migrations experience	Planned
	Trimming	In-progress
	Evolve System.Linq.Expression	Planned
	Translate new LINQ operators	Planned
	Open telemetry for ADO.NET providers	Planned
	Enhancements to System.Data	Planned
	Research data access for cloud-native	Planned
Clear path forward from EF6	Issue #214: Expose model building conventions to applications	Planned
	Issue #245: Map inserts, updates, and deletes (CUD operations) to stored procedures	Planned
	Issue #620: Entity splitting support	Planned
	Issue #3170: TPC inheritance mapping pattern	Planned
	Issue #3864: Support unidirectional many-to-many relationships through shadow navigations	Planned
	Issue #4038: Code templates for scaffolding entity types and DbContext from an existing database	Planned
	Issue #10753: Support raw SQL queries without defining an entity type for the result	Planned
	Issue #11003: KeyAttribute support for composite primary key	Planned
	Issue #11624: Support raw SQL Queries for basic types like Guid, DateTime and int	Planned
	Issue #15911: Implement ObjectMaterialized event	Planned
	Issue #17653: Support for GroupBy entityType	Planned
	Issue #19929: Support GroupBy when it is final operator	Planned
	Issue #19930: Support GroupJoin when it is final query operator	Planned
	issue #26626: Use EF6 as an oracle for procedural testing of EF Core queries	Planned
Performance	Performance of database inserts and updates	Planned
	TechEmpower composite score	In-progress

EF Core 7.0 (EF7) preview 1

EF Core 7.0 (EF7) preview 1 is available from NuGet

Preview 1 does not contain any big new features. However, preview 1 does contain 29 bug fixes and the 30 smaller enhancements, including:

• Support for index ordering (ASC/DESC)
• Support "non-rooted" query expressions in compiled queries
• Property/Reference/etc overloads that take IProperty/INavigation
• Distinguish cancellation from failure to allow different logging strategies
• Lift table from subquery when joining if no additional operations
• DiagnosticSuppressor for CS8618 for DbSet properties
• Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring
• Robust and extensible SQL precedence/parentheses mechanism
• Translation for string.IndexOf(string, int)
• Support SqlNullabilityProcessor and COALESCE with more than two arguments
• Support Contains when using a IReadOnlySet
• Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay

See GitHub for all issues resolved in preview 1.

Burndown for EF Core 7.0

This is the burndown chart the team uses internally to track progress towards EF Core 7.0.

• The gray bar at the top represents all the issues already fixed for EF7.
  • The "Closed" category includes only issues that have been fixed and then closed, not issues closed for any other reason.
  • The "Fixed" category includes issues that have been fixed, but where the change has not yet been merged to the "main" branch.
• As always, we are aiming to be feature-complete by the beginning of September.

EF Core 6.0.2

The latest patch release of EF Core 6.0 is available on NuGet now. This is a patch release of EF Core 6.0 containing only important bug fixes:

• Exception when creating new migration after updating from 6.0-rc.1 to 6.0-rc.2 or 6.0-rtm
• efcore6 produces wrong SELECT SQL when Where/OrderBy clauses are applied to Owned properties followed by .Take
• Proxies using Records with a base class broken since .NET 6
• Parentheses put around IS NULL only if operand is of type boolean
• Self-referencing entity circular dependency happening just on EF Core 6.0
• Many To Many Exception when adding and removing same entity
• RelationalConnection.Close calls async function
• Circular dependency while creating tables with DatabaseFacade.EnsureCreated on EF Core 6
• EF Core Migration Bundles: no way to passthrough custom args to generated efbundle
• Did the naming convention change for HasCheckConstraint in v.6? Is this a breaking change?
• Generated JOIN for multiple MIN is wrong
• StackOverflowException in nested GroupBy query
• When trimming, queries fail because of missing System.Math
• GroupBy with outer reference not translating properly, causing data loss
• EF 6.0.0 and 6.0.1: sub-lists are no longer loaded

EF Core 5.0.14

EF Core 5.0.14 is available on NuGet now. This is a patch release of EF Core 5.0 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.13.

EF Core 3.1.22

EF Core 3.1.22 is available on NuGet now. This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.21.

Pull requests merged since the last update

Community contributions

• @leniency: (6.0.3) Fix for the optimizer when an entity has a collection property that references itself
• @Casper-Olsen: Update breaking-changes.md
• @ojraqueno: Update user-defined-function-mapping.md
• @khellang: EntityFrameworkCore.Sqlite.NodaTime - Add EF Core 6 to list of supported versions
• @Thomas-X: Fix small typo
• @jessegood: Updated Collations and Case Sensitivity

Many thanks to all our contributors!

EF Core

• Query
  • (6.0.3) Convert single result subquery comparison to null to Any operation
  • (6.0.3) Fix to #27072 - Suboptimal SQL generation for query with optional navigation, its collection navigation and lateral join
  • (6.0.3) Match correct predicate structure to convert apply to join
• Dependencies
  • Bump Microsoft.AspNetCore.OData from 8.0.6 to 8.0.7
  • Bump Microsoft.Data.SqlClient from 4.0.1 to 4.1.0
  • Bump Microsoft.Azure.Cosmos from 3.23.0 to 3.25.0
• Documentation
  • Fix efcore-docs links
  • Warnings for deterministic ordering
  • Fix/remove broken links
  • Update existing-database.md
  • Make the Linter happy
  • Update existing-database.md
  • Entity Framework Support Policies
• Migrations
  • Add in migrations
  • Allow migration tests to specify migrations options
• Miscellaneous
  • Remove quirks
  • Remove quirks
  • Unlink of file '.dotnet/dotnet.exe' failed. Should I try again? (y/n)
  • Correct checked-in merge conflict
• Temporal tables
• DbContext
  • (6.0.3) Store ApplicationServiceProvider in a WeakReference
• Change tracking
  • (6.0.3) Revert change to delete dependent when optional FK with cascade delete is set to null
• Scaffolding
  • (6.0.3) RevEng: Don't use nameof syntax

Builds to use

• The daily builds are the most up-to-date available.
  • The daily builds now contain all issues merged for 6.0.x patch releases, as well as new code to be released in EF7 preview 1.
• LTS: EF Core 6.0.2
• Supported: EF Core 5.0.14
• Supported: EF Core 3.1.22

Releases

See GitHub Releases and EF Core releases and planning (Roadmap) in our documentation for full details.

Weekly/biweekly updates from previous years

• 2021
• 2020
• 2019

Feedback

Comments are disabled on this issue to reduce noise. Please use the related discussion issue for any comments on these status updates.

[ajcvickers]

March 17, 2022

Expand to see status from this week...

Highlights

Releases

• EF Core 7.0 (EF7) preview 2 is on NuGet now.
• EF Core 6.0.3 is on NuGet now.

See the GitHub releases page for more information.

EF7 features merged to daily builds

• Attribute mapping for composite primary keys
• Scaffolding using T4 text templates
• Metadata support for TPC inheritance mapping

New documentation

• Support multi-tenant databases
• Azure Cosmos DB Provider - Planetary Docs sample
• Support policies for EF1, EF4, EF4.x EF5, EF6, and EF Core

Community Standup: GraphQL and OData--An In-Depth Discussion

The creator of the GraphQL library HotChocolate, Michael Staib (@michael_staib), and Microsoft engineer and OData expert Hassan Habib (@HassanRezkHabib) discuss the various capabilities of GraphQL and OData and how they empower developers to go beyond REST. Watch the full recording on YouTube.

Coming next week: Good pagination practices in SQL and EF Core

The .NET Data Community Standups are live-streamed every other Wednesday to Twitch, YouTube, and Twitter. Comment on GitHub with ideas for guests, demos, or anything else you want to see.

EF Core 7.0

EF Core 7.0 (EF7) will be the next release after EF Core 6.0. It will be released alongside .NET 7 in November 2022.

The EF Core 7.0 Plan is available publicly in our documentation. As always, feedback is greatly appreciated. This plan is not set-in-stone; we expect it will evolve throughout the release cycle as we learn.

Each high-level area for EF Core 7.0 is linked in the table below together with its current high-level status.

EF Core 7.0 Theme	Feature	Status
Highly requested features	JSON columns	In-progress
	Bulk updates	In-design
	Lifecycle hooks	Planned
	Table-per-concrete-type (TPC) mapping	In-progress
	Map CUD operations to stored procedures	Planned
	Support value generation when using value converters	In-progress
	Value objects	Planned
	Raw SQL queries for unmapped types	Planned
	Database scaffolding templates	In-progress
.NET platforms and ecosystem	Distributed transactions	Planned
	EF Core tooling	Planned
	EF Core and graphical user interfaces	Planned
	SqlServer.Core (Woodstar)	Planned
	Azure Cosmos DB provider	Planned
	Migrations experience	Planned
	Trimming	In-progress
	Evolve System.Linq.Expression	Planned
	Translate new LINQ operators	Planned
	Open telemetry for ADO.NET providers	Planned
	Enhancements to System.Data	Planned
	Research data access for cloud-native	Planned
Clear path forward from EF6	Issue #214: Expose model building conventions to applications	Planned
	Issue #245: Map inserts, updates, and deletes (CUD operations) to stored procedures	Planned
	Issue #620: Entity splitting support	Planned
	Issue #3170: TPC inheritance mapping pattern	In-progress
	Issue #3864: Support unidirectional many-to-many relationships through shadow navigations	Planned
	Issue #4038: Code templates for scaffolding entity types and DbContext from an existing database	In-progress
	Issue #10753: Support raw SQL queries without defining an entity type for the result	Planned
	Issue #11003: KeyAttribute support for composite primary key	Complete
	Issue #11624: Support raw SQL Queries for basic types like Guid, DateTime and int	Planned
	Issue #15911: Implement ObjectMaterialized event	Planned
	Issue #17653: Support for GroupBy entityType	Planned
	Issue #19929: Support GroupBy when it is final operator	Planned
	Issue #19930: Support GroupJoin when it is final query operator	Planned
	issue #26626: Use EF6 as an oracle for procedural testing of EF Core queries	Planned
Performance	Performance of database inserts and updates	In-progress
	TechEmpower composite score	In-progress

EF Core 7.0 (EF7) preview 2

EF Core 7.0 (EF7) preview 2 is available from NuGet

Previews 1 and 2 do not contain any big new features. However, these previews do contain 30 bug fixes and the 33 smaller enhancements, including:

• Temporal tables support for owned entities and other table splitting scenarios
• Support for index ordering (ASC/DESC)
• Support "non-rooted" query expressions in compiled queries
• Property/Reference/etc overloads that take IProperty/INavigation
• Distinguish cancellation from failure to allow different logging strategies
• Lift table from subquery when joining if no additional operations
• DiagnosticSuppressor for CS8618 for DbSet properties
• Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring
• Robust and extensible SQL precedence/parentheses mechanism
• Translation for string.IndexOf(string, int)
• Support SqlNullabilityProcessor and COALESCE with more than two arguments
• Support Contains when using a IReadOnlySet
• Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay

See GitHub for all issues resolved in preview 1 and preview 2.

Burndown for EF Core 7.0

This is the burndown chart the team uses internally to track progress towards EF Core 7.0.

• The gray bar at the top represents all the issues already fixed for EF7.
  • The "Closed" category includes only issues that have been fixed and then closed, not issues closed for any other reason.
  • The "Fixed" category includes issues that have been fixed, but where the change has not yet been merged to the "main" branch.
• As always, we are aiming to be feature-complete by the beginning of September.

EF Core 6.0.3

The latest patch release of EF Core 6.0 is available on NuGet now. This is a patch release of EF Core 6.0 containing only important bug fixes:

• FirstOrDefault after custom projection == null cannot be translated
• DbContext scaffolding creates reference error CS0120 in nameof() for InverseProperty in certain conditions
• EF core 6 selecting null values despite where clause asking for not null
• Query: Rownumber conversion needs better logic to figure out partitions
• Suboptimal SQL generation for query with optional navigation, its collection navigation and lateral join
• Aggregates on multiple child tables produces invalid SQL
• ServiceProviderCache keeps initially created IServiceProvider indefinitely
• Setting a Nullable Foreign Key property to Null triggers cascade delete
• Optimize hangs and stops responding

In addition, the following issues were fixed in the 6.0.1 and 6.0.2 releases:

• Exception when creating new migration after updating from 6.0-rc.1 to 6.0-rc.2 or 6.0-rtm
• efcore6 produces wrong SELECT SQL when Where/OrderBy clauses are applied to Owned properties followed by .Take
• Proxies using Records with a base class broken since .NET 6
• Parentheses put around IS NULL only if operand is of type boolean
• Self-referencing entity circular dependency happening just on EF Core 6.0
• Many To Many Exception when adding and removing same entity
• RelationalConnection.Close calls async function
• Circular dependency while creating tables with DatabaseFacade.EnsureCreated on EF Core 6
• EF Core Migration Bundles: no way to passthrough custom args to generated efbundle
• Did the naming convention change for HasCheckConstraint in v.6? Is this a breaking change?
• Generated JOIN for multiple MIN is wrong
• StackOverflowException in nested GroupBy query
• When trimming, queries fail because of missing System.Math
• GroupBy with outer reference not translating properly, causing data loss
• EF 6.0.0 and 6.0.1: sub-lists are no longer loaded
• DateTime with z suffix is not respected when reading entities
• 'The object has been removed from the model.' when building model
• EF Core 6.0 regression when using HasDefaultSchema() with ToTable(null)
• Variable names must be unique within a query batch or stored procedure
• Stack overflow when using circular composite key dependencies
• SqliteConnectionFactory.cs is not thread-safe
• EF Core 6.0 InvalidOperationException: The object has been removed from the model
• Subquery.Contains throws when the type of item is value type
• Query with n:m relation adds non-existent column
• InvalidOperationException "sequence contains no matching element" in TableReferenceExpression.get_Table
• Update from 5.0.1 to 6.0breaks all SqliteConnection
• Scaffolder throws error if junction table foreign key columns have identical names
• EFCore 6 - NullReferenceException upon EnsureDeleted
• Non-nullable value comparer can't be applied on nullable type
• Exception in SQL server query in EF Core 6, looks related to HasQueryFilter(), worked in EF Core 5
• RC2 Sqlite provider no longer clears temporary files on exit
• The dotnet ef dbcontext scaffold command does not print all expected logs

EF Core 5.0.15

EF Core 5.0.15 is available on NuGet now. This is a patch release of EF Core 5.0 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.14.

EF Core 3.1.23

EF Core 3.1.23 is available on NuGet now. This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.22.

Pull requests merged since the last update

Community contributions

• @WeihanLi: Remove DisableImplicitNamespaceImports config
• @ShreyasJejurkar: feat (codespaces) - Add initial support for codespaces
• @jmartens: Fix: Ordered list in example class definitions
• @Vadimyan: Fix a link to Including & Excluding Properties in Backing Fields|Basic configuration section
• @Vadimyan: Change "in lieu of" to a more common similar phrase

Many thanks to all our contributors!

EF Core

• Documentation
  • Fix doc link type
  • Fix testing sample links
  • Document that value-converted types aren't support in raw SQL
  • Correct schema in basic sequence sample
  • Document ToInMemoryQuery and re-introduce sample code
  • Add docs on stateful context pool
  • Move .gitignore back to root
  • Use file-scoped namespaces everywhere in samples
  • Add multitenancy
• Miscellaneous
  • Remove quirks
  • Be consistent about using ConditionalFact and ConditionalTheory
  • Tiny workaround for analyzer issue
  • Remove quirks
  • Add default interface implementations to interceptors
• Model building
  • Map check constraints only to the tables for which they are declared
  • Store name information on TableBuilder
  • Attribute for configuring composite primary keys
  • Add metadata support for TPC
• Scaffolding
  • Enable text templates
  • Fix scaffolding of reference navigations with NRT
  • Use "CodeTemplates" directory
• Migrations
  • (6.0.4) EF Core 6.0 temporal tables - migration rollback doesn't work
  • Renaming and dropping columns with Temporal Tables generates faulty migration
  • Fix SQL Server memory-optimized + temporal tables
• Dependencies
  • Bump Humanizer.Core from 2.13.14 to 2.14.1
  • Bump Microsoft.AspNetCore.OData from 8.0.7 to 8.0.8
  • Bump Microsoft.Azure.Cosmos from 3.25.0 to 3.26.0
• SaveChanges
  • Stop wrapping single changes in transactions where possible
  • Generate temp values for key properties contained in optional FKs
• Query
  • (6.0.4) Collection_navigation_equal_to_null_for_subquery fails after merging from release/6.0
  • Fix automated SQL baseline rewriting
• Change tracking
  • Stop deleting orphans for optional relationships configured for cascade deletes

Microsoft.Data.Sqlite

• (6.0.4) Don't modify collection while enumerating inside ReclaimLeakedConnections

Builds to use

• The daily builds are the most up-to-date available.
  • The daily builds now contain all issues merged for 6.0.x patch releases, as well as new code to be released in EF7 preview 1.
• LTS: EF Core 6.0.3
• Supported: EF Core 5.0.15
• Supported: EF Core 3.1.23

Releases

See GitHub Releases and EF Core releases and planning (Roadmap) in our documentation for full details.

Weekly/biweekly updates from previous years

• 2021
• 2020
• 2019

Feedback

Comments are disabled on this issue to reduce noise. Please use the related discussion issue for any comments on these status updates.

[ajcvickers]

March 31, 2022

Expand to see status from this week...

Highlights

Work on EF7 is progressing well:

• Multiple PRs merged for SaveChanges performance
• Migrations for TPC inheritance mapping merged
• Support for UTF8 strings in SQL Server

Proof of concept: Generate Mermaid entity-relationship diagrams from an EF Core model directly into a .NET Interactive Notebook in VS Code, starting with just a database.

Community Standup: GraphQL and OData--An In-Depth Discussion

The creator of the GraphQL library HotChocolate, Michael Staib (@michael_staib), and Microsoft engineer and OData expert Hassan Habib (@HassanRezkHabib) discuss the various capabilities of GraphQL and OData and how they empower developers to go beyond REST. Watch the full recording on YouTube.

The .NET Data Community Standups are live-streamed every other Wednesday to Twitch, YouTube, and Twitter. Comment on GitHub with ideas for guests, demos, or anything else you want to see.

EF Core 7.0

EF Core 7.0 (EF7) will be the next release after EF Core 6.0. It will be released alongside .NET 7 in November 2022.

The EF Core 7.0 Plan is available publicly in our documentation. As always, feedback is greatly appreciated. This plan is not set-in-stone; we expect it will evolve throughout the release cycle as we learn.

Each high-level area for EF Core 7.0 is linked in the table below together with its current high-level status.

EF Core 7.0 Theme	Feature	Status
Highly requested features	JSON columns	In-progress
	Bulk updates	In-design
	Lifecycle hooks	Planned
	Table-per-concrete-type (TPC) mapping	In-progress
	Map CUD operations to stored procedures	Planned
	Support value generation when using value converters	In-progress
	Value objects	Planned
	Raw SQL queries for unmapped types	Planned
	Database scaffolding templates	In-progress
.NET platforms and ecosystem	Distributed transactions	Planned
	EF Core tooling	Planned
	EF Core and graphical user interfaces	Planned
	SqlServer.Core (Woodstar)	Planned
	Azure Cosmos DB provider	Planned
	Migrations experience	Planned
	Trimming	In-progress
	Evolve System.Linq.Expression	Planned
	Translate new LINQ operators	Planned
	Open telemetry for ADO.NET providers	Planned
	Enhancements to System.Data	Planned
	Research data access for cloud-native	Planned
Clear path forward from EF6	Issue #214: Expose model building conventions to applications	Planned
	Issue #245: Map inserts, updates, and deletes (CUD operations) to stored procedures	Planned
	Issue #620: Entity splitting support	Planned
	Issue #3170: TPC inheritance mapping pattern	In-progress
	Issue #3864: Support unidirectional many-to-many relationships through shadow navigations	Planned
	Issue #4038: Code templates for scaffolding entity types and DbContext from an existing database	In-progress
	Issue #10753: Support raw SQL queries without defining an entity type for the result	Planned
	Issue #11003: KeyAttribute support for composite primary key	Complete
	Issue #11624: Support raw SQL Queries for basic types like Guid, DateTime and int	Planned
	Issue #15911: Implement ObjectMaterialized event	Planned
	Issue #17653: Support for GroupBy entityType	Planned
	Issue #19929: Support GroupBy when it is final operator	Planned
	Issue #19930: Support GroupJoin when it is final query operator	Planned
	issue #26626: Use EF6 as an oracle for procedural testing of EF Core queries	Planned
Performance	Performance of database inserts and updates	In-progress
	TechEmpower composite score	In-progress

EF Core 7.0 (EF7) preview 2

EF Core 7.0 (EF7) preview 2 is available from NuGet

Previews 1 and 2 do not contain any big new features. However, these previews do contain 30 bug fixes and the 33 smaller enhancements, including:

• Temporal tables support for owned entities and other table splitting scenarios
• Support for index ordering (ASC/DESC)
• Support "non-rooted" query expressions in compiled queries
• Property/Reference/etc overloads that take IProperty/INavigation
• Distinguish cancellation from failure to allow different logging strategies
• Lift table from subquery when joining if no additional operations
• DiagnosticSuppressor for CS8618 for DbSet properties
• Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring
• Robust and extensible SQL precedence/parentheses mechanism
• Translation for string.IndexOf(string, int)
• Support SqlNullabilityProcessor and COALESCE with more than two arguments
• Support Contains when using a IReadOnlySet
• Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay

See GitHub for all issues resolved in preview 1 and preview 2.

Burndown for EF Core 7.0

This is the burndown chart the team uses internally to track progress towards EF Core 7.0.

• The gray bar at the top represents all the issues already fixed for EF7.
  • The "Closed" category includes only issues that have been fixed and then closed, not issues closed for any other reason.
  • The "Fixed" category includes issues that have been fixed, but where the change has not yet been merged to the "main" branch.
• As always, we are aiming to be feature-complete by the beginning of September.

EF Core 6.0.3

The latest patch release of EF Core 6.0 is available on NuGet now. This is a patch release of EF Core 6.0 containing only important bug fixes:

• FirstOrDefault after custom projection == null cannot be translated
• DbContext scaffolding creates reference error CS0120 in nameof() for InverseProperty in certain conditions
• EF core 6 selecting null values despite where clause asking for not null
• Query: Rownumber conversion needs better logic to figure out partitions
• Suboptimal SQL generation for query with optional navigation, its collection navigation and lateral join
• Aggregates on multiple child tables produces invalid SQL
• ServiceProviderCache keeps initially created IServiceProvider indefinitely
• Setting a Nullable Foreign Key property to Null triggers cascade delete
• Optimize hangs and stops responding

In addition, the following issues were fixed in the 6.0.1 and 6.0.2 releases:

• Exception when creating new migration after updating from 6.0-rc.1 to 6.0-rc.2 or 6.0-rtm
• efcore6 produces wrong SELECT SQL when Where/OrderBy clauses are applied to Owned properties followed by .Take
• Proxies using Records with a base class broken since .NET 6
• Parentheses put around IS NULL only if operand is of type boolean
• Self-referencing entity circular dependency happening just on EF Core 6.0
• Many To Many Exception when adding and removing same entity
• RelationalConnection.Close calls async function
• Circular dependency while creating tables with DatabaseFacade.EnsureCreated on EF Core 6
• EF Core Migration Bundles: no way to passthrough custom args to generated efbundle
• Did the naming convention change for HasCheckConstraint in v.6? Is this a breaking change?
• Generated JOIN for multiple MIN is wrong
• StackOverflowException in nested GroupBy query
• When trimming, queries fail because of missing System.Math
• GroupBy with outer reference not translating properly, causing data loss
• EF 6.0.0 and 6.0.1: sub-lists are no longer loaded
• DateTime with z suffix is not respected when reading entities
• 'The object has been removed from the model.' when building model
• EF Core 6.0 regression when using HasDefaultSchema() with ToTable(null)
• Variable names must be unique within a query batch or stored procedure
• Stack overflow when using circular composite key dependencies
• SqliteConnectionFactory.cs is not thread-safe
• EF Core 6.0 InvalidOperationException: The object has been removed from the model
• Subquery.Contains throws when the type of item is value type
• Query with n:m relation adds non-existent column
• InvalidOperationException "sequence contains no matching element" in TableReferenceExpression.get_Table
• Update from 5.0.1 to 6.0breaks all SqliteConnection
• Scaffolder throws error if junction table foreign key columns have identical names
• EFCore 6 - NullReferenceException upon EnsureDeleted
• Non-nullable value comparer can't be applied on nullable type
• Exception in SQL server query in EF Core 6, looks related to HasQueryFilter(), worked in EF Core 5
• RC2 Sqlite provider no longer clears temporary files on exit
• The dotnet ef dbcontext scaffold command does not print all expected logs

EF Core 5.0.15

EF Core 5.0.15 is available on NuGet now. This is a patch release of EF Core 5.0 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.14.

EF Core 3.1.23

EF Core 3.1.23 is available on NuGet now. This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.22.

Pull requests merged since the last update

Community contributions

• @AraHaan: Update tool to roll forward to latest major version of runtime installed.
• @patrickklaeren: Fix missing Simple Logging region
• @erhanalankus: Fix Grammar
• @erhanalankus: Fix Typo

Many thanks to all our contributors!

EF Core

• SaveChanges
  • Improve SQL Server insertion logic and other update pipeline optimizations
  • Use RETURNING/OUTPUT clause for UPDATE/DELETE
  • Refactor ReaderModificationCommandBatch
  • Reimplement MaxBatchSize as a pre-check
• Documentation
  • Config changes to reflect the default branch from master to main. Please merge to complete the default branch renaming job.
  • Update some provider versions to 6.0
  • Update comments on NRT being on/off by default
• Dependencies
  • Bump NetTopologySuite.IO.SqlServerBytes from 2.0.0 to 2.1.0
  • Bump Microsoft.Azure.Cosmos from 3.26.0 to 3.26.1
• Miscellaneous
  • Revert "feat (codespaces) - Add initial support for codespaces
• Migrations
  • Add TPC support for migrations
• Change tracking
  • Ensure FK properties have nullable-appropriate value comparers
• SQL Server
  • Support SQL Server UTF8 strings
• Cosmos
  • Ignore a failing Cosmos test to unblock builds

Microsoft.Data.Sqlite

• (6.0.4) Don't modify collection while enumerating inside ReclaimLeakedConnections

Builds to use

• The daily builds are the most up-to-date available.
  • The daily builds now contain all issues merged for 6.0.x patch releases, as well as new code to be released in EF7 preview 1.
• LTS: EF Core 6.0.3
• Supported: EF Core 5.0.15
• Supported: EF Core 3.1.23

Releases

See GitHub Releases and EF Core releases and planning (Roadmap) in our documentation for full details.

Weekly/biweekly updates from previous years

• 2021
• 2020
• 2019

Feedback

Comments are disabled on this issue to reduce noise. Please use the related discussion issue for any comments on these status updates.

[ajcvickers]

April 18, 2022

Expand to see status from this week...

Highlights

Releases

• EF Core 7.0 (EF7) preview 3 is on NuGet now
  • Attribute mapping for composite primary keys
  • UTF8 strings with SQL Server
  • SaveChanges performance enhancements
• EF Core 6.0.4 is on NuGet now

See the GitHub releases page for more information.

EF7 features merged to daily builds

• Value generation supported for simple types wrapped in value objects
• TPC support for SaveChanges

Community Standup: Database-first with T4 Templates in EF7: Early look

Prefer null setters? Property initializers? Constructor initialization? What about auto-generating database diagrams that render in markdown using Mermaid? Learn how to take control of your database scaffolding in this early look at an EF7 feature that's hot off the press. Watch the full recording on YouTube.

The .NET Data Community Standups are live-streamed every other Wednesday to Twitch, YouTube, and Twitter. Comment on GitHub with ideas for guests, demos, or anything else you want to see.

EF Core 7.0

EF Core 7.0 (EF7) will be the next release after EF Core 6.0. It will be released alongside .NET 7 in November 2022.

The EF Core 7.0 Plan is available publicly in our documentation. As always, feedback is greatly appreciated. This plan is not set-in-stone; we expect it will evolve throughout the release cycle as we learn.

Each high-level area for EF Core 7.0 is linked in the table below together with its current high-level status.

EF Core 7.0 Theme	Feature	Status
Highly requested features	JSON columns	In-progress
	Bulk updates	In-design
	Lifecycle hooks	Planned
	Table-per-concrete-type (TPC) mapping	In-progress
	Map CUD operations to stored procedures	Planned
	Support value generation when using value converters	Complete
	Value objects	Planned
	Raw SQL queries for unmapped types	Planned
	Database scaffolding templates	In-progress
.NET platforms and ecosystem	Distributed transactions	Planned
	EF Core tooling	Planned
	EF Core and graphical user interfaces	Planned
	SqlServer.Core (Woodstar)	Planned
	Azure Cosmos DB provider	Planned
	Migrations experience	Planned
	Trimming	In-progress
	Evolve System.Linq.Expression	Planned
	Translate new LINQ operators	Planned
	Open telemetry for ADO.NET providers	Planned
	Enhancements to System.Data	Planned
	Research data access for cloud-native	Planned
Clear path forward from EF6	Issue #214: Expose model building conventions to applications	Planned
	Issue #245: Map inserts, updates, and deletes (CUD operations) to stored procedures	Planned
	Issue #620: Entity splitting support	Planned
	Issue #3170: TPC inheritance mapping pattern	In-progress
	Issue #3864: Support unidirectional many-to-many relationships through shadow navigations	Planned
	Issue #4038: Code templates for scaffolding entity types and DbContext from an existing database	In-progress
	Issue #10753: Support raw SQL queries without defining an entity type for the result	Planned
	Issue #11003: KeyAttribute support for composite primary key	Complete
	Issue #11624: Support raw SQL Queries for basic types like Guid, DateTime and int	Planned
	Issue #15911: Implement ObjectMaterialized event	Planned
	Issue #17653: Support for GroupBy entityType	Planned
	Issue #19929: Support GroupBy when it is final operator	Planned
	Issue #19930: Support GroupJoin when it is final query operator	Planned
	issue #26626: Use EF6 as an oracle for procedural testing of EF Core queries	Planned
Performance	Performance of database inserts and updates	In-progress
	TechEmpower composite score	In-progress

EF Core 7.0 (EF7) preview 3

EF Core 7.0 (EF7) preview 3 is available from NuGet

Previews 1, 2, and 3 do not contain any big new features. However, these previews do contain 38 bug fixes and 46 smaller enhancements, including:

• Attribute (Data Annotations) mapping for composite primary keys
• SQL Server UTF8 collations
• Stop wrapping single changes in transactions where possible
• Use RETURNING/OUTPUT clause for UPDATE/DELETE
• SQLite SaveChanges: Use RETURNING clause
• SQL Server: Optimize SQL Server OUTPUT clause usage when retrieving database-generated values
• Stop automatically deleting orphans for optional relationships with cascade delete configured
• Empty default interface implementations for all interceptor interface methods
• Temporal tables support for owned entities and other table splitting scenarios
• Support for index ordering (ASC/DESC)
• Support "non-rooted" query expressions in compiled queries
• Property/Reference/etc overloads that take IProperty/INavigation
• Distinguish cancellation from failure to allow different logging strategies
• Lift table from subquery when joining if no additional operations
• DiagnosticSuppressor for CS8618 for DbSet properties
• Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring
• Robust and extensible SQL precedence/parentheses mechanism
• Translation for string.IndexOf(string, int)
• Support SqlNullabilityProcessor and COALESCE with more than two arguments
• Support Contains when using a IReadOnlySet
• Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay

See GitHub for all issues resolved in preview 1, preview 2, and preview 3.

Burndown for EF Core 7.0

This is the burndown chart the team uses internally to track progress towards EF Core 7.0.

• The gray bar at the top represents all the issues already fixed for EF7.
  • The "Closed" category includes only issues that have been fixed and then closed, not issues closed for any other reason.
  • The "Fixed" category includes issues that have been fixed, but where the change has not yet been merged to the "main" branch.
• As always, we are aiming to be feature-complete by the beginning of September.

EF Core 6.0.4

The latest patch release of EF Core 6.0 is available on NuGet now. This is a patch release of EF Core 6.0 containing only important bug fixes:

• Exception from SQLite provider when application is shutting down
• Collection_navigation_equal_to_null_for_subquery fails after merging from release/6.0
• EF Core 6.0 temporal tables - migration rollback doesn't work
• InvalidOperationException on save after upgrading from 5 to 6

In addition, the following issues were fixed in the 6.0.1, 6.0.2, and 6.0.3 releases:

• FirstOrDefault after custom projection == null cannot be translated
• DbContext scaffolding creates reference error CS0120 in nameof() for InverseProperty in certain conditions
• EF core 6 selecting null values despite where clause asking for not null
• Query: Rownumber conversion needs better logic to figure out partitions
• Suboptimal SQL generation for query with optional navigation, its collection navigation and lateral join
• Aggregates on multiple child tables produces invalid SQL
• ServiceProviderCache keeps initially created IServiceProvider indefinitely
• Setting a Nullable Foreign Key property to Null triggers cascade delete
• Optimize hangs and stops responding
• Exception when creating new migration after updating from 6.0-rc.1 to 6.0-rc.2 or 6.0-rtm
• efcore6 produces wrong SELECT SQL when Where/OrderBy clauses are applied to Owned properties followed by .Take
• Proxies using Records with a base class broken since .NET 6
• Parentheses put around IS NULL only if operand is of type boolean
• Self-referencing entity circular dependency happening just on EF Core 6.0
• Many To Many Exception when adding and removing same entity
• RelationalConnection.Close calls async function
• Circular dependency while creating tables with DatabaseFacade.EnsureCreated on EF Core 6
• EF Core Migration Bundles: no way to passthrough custom args to generated efbundle
• Did the naming convention change for HasCheckConstraint in v.6? Is this a breaking change?
• Generated JOIN for multiple MIN is wrong
• StackOverflowException in nested GroupBy query
• When trimming, queries fail because of missing System.Math
• GroupBy with outer reference not translating properly, causing data loss
• EF 6.0.0 and 6.0.1: sub-lists are no longer loaded
• DateTime with z suffix is not respected when reading entities
• 'The object has been removed from the model.' when building model
• EF Core 6.0 regression when using HasDefaultSchema() with ToTable(null)
• Variable names must be unique within a query batch or stored procedure
• Stack overflow when using circular composite key dependencies
• SqliteConnectionFactory.cs is not thread-safe
• EF Core 6.0 InvalidOperationException: The object has been removed from the model
• Subquery.Contains throws when the type of item is value type
• Query with n:m relation adds non-existent column
• InvalidOperationException "sequence contains no matching element" in TableReferenceExpression.get_Table
• Update from 5.0.1 to 6.0breaks all SqliteConnection
• Scaffolder throws error if junction table foreign key columns have identical names
• EFCore 6 - NullReferenceException upon EnsureDeleted
• Non-nullable value comparer can't be applied on nullable type
• Exception in SQL server query in EF Core 6, looks related to HasQueryFilter(), worked in EF Core 5
• RC2 Sqlite provider no longer clears temporary files on exit
• The dotnet ef dbcontext scaffold command does not print all expected logs

EF Core 5.0.16

EF Core 5.0.16 is available on NuGet now. This is a patch release of EF Core 5.0 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.15.

EF Core 3.1.24

EF Core 3.1.24 is available on NuGet now. This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.23.

Pull requests merged since the last update

Community contributions

• @AraHaan: Remove needless package references in EFCore
• @charliemerrell: Update tracking.md
• @erhanalankus: Add What MARS abbreviation stands for
• @erhanalankus: Fix Typo
• @erhanalankus: Fix Typos

Many thanks to all our contributors!

EF Core

• Documentation
  • Update comments on NRT being on/off by default
  • Some using declarations
  • Add front matter to Planetary Docs sample
  • Update teams.md
• Query
  • (6.0.5) Assign proper type to collection result expression (part 2)
  • Introduce UpdateQueryExpression on ShapedQueryExpression
• SaveChanges
  • Add TPC support to update pipeline
• Dependencies
  • (6.0.5) Update Grpc.AspNetCore dependency
• Miscellaneous
  • Remove quirks
• Type mapping
  • Support value generation for converted types
• Cosmos
  • (6.0.4) Ignore a failing Cosmos test to unblock builds

Builds to use

• The daily builds are the most up-to-date available.
  • The daily builds now contain all issues merged for 6.0.x patch releases, as well as new code to be released in EF7 preview 1.
• LTS: EF Core 6.0.4
• Supported: EF Core 5.0.16
• Supported: EF Core 3.1.24

Releases

See GitHub Releases and EF Core releases and planning (Roadmap) in our documentation for full details.

Weekly/biweekly updates from previous years

• 2021
• 2020
• 2019

Feedback

Comments are disabled on this issue to reduce noise. Please use the related discussion issue for any comments on these status updates.

[ajcvickers]

April 28, 2022

Expand to see status from this week...

Highlights

Learning videos

• Excellent new video series from Cam Soper focused on introducing EF Core to new developers.
• Earlier today was the Let's Learn .NET: Data event. We built a Web API using EF Core from scratch. If you missed it live, then catch it on-demand.

EF7 Progress

• Work on lifecycle hooks (events and interceptors) is now underway
• Further performance improvements for SaveChanges have been merged

EF7 Cuts

A combination of factors have resulted in a reduction in available resources for EF7. This means we have had to cut or scope some planned work. This includes:

• Evolve System.Linq.Expression has been cut for now.
• Translate new LINQ operators has been cut for now.
• Open telemetry for ADO.NET providers has been cut for now.
• Improvements to Migrations experience have been significantly scoped.

In addition, some smaller enhancements have also been cut. For a complete list, see issues labeled with punted-for-7.0 in the EF GitHub repo.

Community Standup: Performance Improvements to the EF7 Update Pipeline

Join the Entity Framework team as we review optimizations to the update pipeline (SaveChanges) to improve performance. Also includes answers to many performance questions asked during the live show.

The .NET Data Community Standups are live-streamed every other Wednesday to Twitch, YouTube, and Twitter. Comment on GitHub with ideas for guests, demos, or anything else you want to see.

EF Core 7.0

EF Core 7.0 (EF7) will be the next release after EF Core 6.0. It will be released alongside .NET 7 in November 2022.

The EF Core 7.0 Plan is available publicly in our documentation. As always, feedback is greatly appreciated. This plan is not set-in-stone; we expect it will evolve throughout the release cycle as we learn.

Each high-level area for EF Core 7.0 is linked in the table below together with its current high-level status.

EF Core 7.0 Theme	Feature	Status
Highly requested features	JSON columns	In-progress
	Bulk updates	In-design
	Lifecycle hooks	In-progress
	Table-per-concrete-type (TPC) mapping	In-progress
	Map CUD operations to stored procedures	Planned
	Support value generation when using value converters	Complete
	Value objects	Planned
	Raw SQL queries for unmapped types	Planned
	Database scaffolding templates	In-progress
.NET platforms and ecosystem	Distributed transactions	Planned
	EF Core tooling	Planned
	EF Core and graphical user interfaces	Planned
	SqlServer.Core (Woodstar)	Planned
	Azure Cosmos DB provider	Planned
	Migrations experience	Scoped
	Trimming	In-progress
	Evolve System.Linq.Expression	Cut
	Translate new LINQ operators	Cut
	Open telemetry for ADO.NET providers	Cut
	Enhancements to System.Data	Planned
	Research data access for cloud-native	Planned
Clear path forward from EF6	Issue #214: Expose model building conventions to applications	Planned
	Issue #245: Map inserts, updates, and deletes (CUD operations) to stored procedures	Planned
	Issue #620: Entity splitting support	Planned
	Issue #3170: TPC inheritance mapping pattern	In-progress
	Issue #3864: Support unidirectional many-to-many relationships through shadow navigations	Planned
	Issue #4038: Code templates for scaffolding entity types and DbContext from an existing database	In-progress
	Issue #10753: Support raw SQL queries without defining an entity type for the result	Planned
	Issue #11003: KeyAttribute support for composite primary key	Complete
	Issue #11624: Support raw SQL Queries for basic types like Guid, DateTime and int	Planned
	Issue #15911: Implement ObjectMaterialized event	Planned
	Issue #17653: Support for GroupBy entityType	Planned
	Issue #19929: Support GroupBy when it is final operator	Planned
	Issue #19930: Support GroupJoin when it is final query operator	Planned
	issue #26626: Use EF6 as an oracle for procedural testing of EF Core queries	Planned
Performance	Performance of database inserts and updates	In-progress
	TechEmpower composite score	In-progress

EF Core 7.0 (EF7) preview 3

EF Core 7.0 (EF7) preview 3 is available from NuGet

Previews 1, 2, and 3 do not contain any big new features. However, these previews do contain 38 bug fixes and 46 smaller enhancements, including:

• Attribute (Data Annotations) mapping for composite primary keys
• SQL Server UTF8 collations
• Stop wrapping single changes in transactions where possible
• Use RETURNING/OUTPUT clause for UPDATE/DELETE
• SQLite SaveChanges: Use RETURNING clause
• SQL Server: Optimize SQL Server OUTPUT clause usage when retrieving database-generated values
• Stop automatically deleting orphans for optional relationships with cascade delete configured
• Empty default interface implementations for all interceptor interface methods
• Temporal tables support for owned entities and other table splitting scenarios
• Support for index ordering (ASC/DESC)
• Support "non-rooted" query expressions in compiled queries
• Property/Reference/etc overloads that take IProperty/INavigation
• Distinguish cancellation from failure to allow different logging strategies
• Lift table from subquery when joining if no additional operations
• DiagnosticSuppressor for CS8618 for DbSet properties
• Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring
• Robust and extensible SQL precedence/parentheses mechanism
• Translation for string.IndexOf(string, int)
• Support SqlNullabilityProcessor and COALESCE with more than two arguments
• Support Contains when using a IReadOnlySet
• Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay

See GitHub for all issues resolved in preview 1, preview 2, and preview 3.

Burndown for EF Core 7.0

This is the burndown chart the team uses internally to track progress towards EF Core 7.0.

• The gray bar at the top represents all the issues already fixed for EF7.
  • The "Closed" category includes only issues that have been fixed and then closed, not issues closed for any other reason.
  • The "Fixed" category includes issues that have been fixed, but where the change has not yet been merged to the "main" branch.
• As always, we are aiming to be feature-complete by the beginning of September.

EF Core 6.0.4

The latest patch release of EF Core 6.0 is available on NuGet now. This is a patch release of EF Core 6.0 containing only important bug fixes:

• Exception from SQLite provider when application is shutting down
• Collection_navigation_equal_to_null_for_subquery fails after merging from release/6.0
• EF Core 6.0 temporal tables - migration rollback doesn't work
• InvalidOperationException on save after upgrading from 5 to 6

In addition, the following issues were fixed in the 6.0.1, 6.0.2, and 6.0.3 releases:

• FirstOrDefault after custom projection == null cannot be translated
• DbContext scaffolding creates reference error CS0120 in nameof() for InverseProperty in certain conditions
• EF core 6 selecting null values despite where clause asking for not null
• Query: Rownumber conversion needs better logic to figure out partitions
• Suboptimal SQL generation for query with optional navigation, its collection navigation and lateral join
• Aggregates on multiple child tables produces invalid SQL
• ServiceProviderCache keeps initially created IServiceProvider indefinitely
• Setting a Nullable Foreign Key property to Null triggers cascade delete
• Optimize hangs and stops responding
• Exception when creating new migration after updating from 6.0-rc.1 to 6.0-rc.2 or 6.0-rtm
• efcore6 produces wrong SELECT SQL when Where/OrderBy clauses are applied to Owned properties followed by .Take
• Proxies using Records with a base class broken since .NET 6
• Parentheses put around IS NULL only if operand is of type boolean
• Self-referencing entity circular dependency happening just on EF Core 6.0
• Many To Many Exception when adding and removing same entity
• RelationalConnection.Close calls async function
• Circular dependency while creating tables with DatabaseFacade.EnsureCreated on EF Core 6
• EF Core Migration Bundles: no way to passthrough custom args to generated efbundle
• Did the naming convention change for HasCheckConstraint in v.6? Is this a breaking change?
• Generated JOIN for multiple MIN is wrong
• StackOverflowException in nested GroupBy query
• When trimming, queries fail because of missing System.Math
• GroupBy with outer reference not translating properly, causing data loss
• EF 6.0.0 and 6.0.1: sub-lists are no longer loaded
• DateTime with z suffix is not respected when reading entities
• 'The object has been removed from the model.' when building model
• EF Core 6.0 regression when using HasDefaultSchema() with ToTable(null)
• Variable names must be unique within a query batch or stored procedure
• Stack overflow when using circular composite key dependencies
• SqliteConnectionFactory.cs is not thread-safe
• EF Core 6.0 InvalidOperationException: The object has been removed from the model
• Subquery.Contains throws when the type of item is value type
• Query with n:m relation adds non-existent column
• InvalidOperationException "sequence contains no matching element" in TableReferenceExpression.get_Table
• Update from 5.0.1 to 6.0breaks all SqliteConnection
• Scaffolder throws error if junction table foreign key columns have identical names
• EFCore 6 - NullReferenceException upon EnsureDeleted
• Non-nullable value comparer can't be applied on nullable type
• Exception in SQL server query in EF Core 6, looks related to HasQueryFilter(), worked in EF Core 5
• RC2 Sqlite provider no longer clears temporary files on exit
• The dotnet ef dbcontext scaffold command does not print all expected logs

EF Core 5.0.16

EF Core 5.0.16 is available on NuGet now. This is a patch release of EF Core 5.0 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.15.

EF Core 3.1.24

EF Core 3.1.24 is available on NuGet now. This is a patch release of EF Core 3.1 containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 3.1.23.

Pull requests merged since the last update

Community contributions

• @bbonch: Fix tests in StoreGeneratedTestBase
• @naveensrinivasan: Set permissions for GitHub actions
• @cincuranet: Bump version for Firebird provider
• @eersonmez: Update transactions.md
• @erhanalankus: Fix Typo
• @slch: Fix JOINs in examples

Many thanks to all our contributors!

EF Core

• SaveChanges
  • Fixes to support multi-dimensional arrays
  • Reduce SaveChanges roundtrips
• Lifecycle hooks
  • Stop validating non-null/empty connection strings
  • Add CommandInitialized interceptor
• Documentation
  • Update docs for DbContext pooling with state
  • Add note on user transactions and retrying strategies
• Query
  • Reset read count on RelationalDataReader
• Dependencies
  • Downgrade Microsoft.CodeAnalysis.CSharp
• Miscellaneous
  • Remove quirks
• DbContext
  • Suppress uninitialized DbSet warnings when a ctor is present

Builds to use

• The daily builds are the most up-to-date available.
  • The daily builds now contain all issues merged for 6.0.x patch releases, as well as new code to be released in EF7 preview 1.
• LTS: EF Core 6.0.4
• Supported: EF Core 5.0.16
• Supported: EF Core 3.1.24

Releases

See GitHub Releases and EF Core releases and planning (Roadmap) in our documentation for full details.

Weekly/biweekly updates from previous years

• 2021
• 2020
• 2019

Feedback

Comments are disabled on this issue to reduce noise. Please use the related discussion issue for any comments on these status updates.