Release notes
Sourced fromMicrosoft.EntityFrameworkCore.Relational's releases.
9.0.1
Release
What's Changed
Full Changelog:dotnet/efcore@v9.0.0...v9.0.1
9.0.0
Release
What's Changed
9.0.0-rc.2.24474.1
Release
9.0.0-rc.1.24451.1
Release
9.0.0-preview.7.24405.3
Release
9.0.0-preview.6.24327.4
Release
9.0.0-preview.5.24306.3
The team has been working primarily on EF Core internals, so there are no new big features in EF Core 9 (EF9) Preview 5. However, this means we really need people like you to run your code on these new internals and report back what you find. We want to fix bugs in the new internals as soon as possible in order to have a strong GA release later in the year.
That being said, there are several smaller enhancements included in preview 5. For full details, seeWhat's new in EF Core 9. To discuss the EF9 release, go toTry EF Core 9 now! on GitHub.
Enhanced database provider for Azure Cosmos DB for NoSQL
We are working on significant updates in EF9 to the EF Core database provider for Azure Cosmos DB for NoSQL. For preview 5, these include:
- Support for hierarchical partition keys
- Use of any numeric, bool, string, or value-converted type as a partition key
SeeAzure Cosmos DB for NoSQL in theWhat's New docs for more information.
Query translation improvements
EF9 preview 5 contains three small enhancements to query translation:
- Optimization of queries using
Count != 0 orCount > 0 - Translations for
TimeOnly.FromDateTime andTimeOnly.FromTimeSpan
SeeLINQ and SQL translation in theWhat's New docs for more information.
Everything else in preview 5
Preview 5 contains:
EF Core 9 preview 5 and Microsoft.Data.Sqlite contain work from the EF Team at Microsoft (@roji @AndriySvyryd @maumar @ajcvickers @cincuranet @SamMonoRT @luisquintanilla).
9.0.0-preview.4.24267.1
The team has been working primarily on EF Core internals, so there are no new big features in EF Core 9 (EF9) Preview 4. However, this means we really need people like you to run your code on these new internals and report back what you find. We want to fix bugs in the new internals as soon as possible in order to have a strong GA release later in the year.
That being said, there are several smaller enhancements included in preview 4. For full details, seeWhat's new in EF Core 9. To discuss the EF9 release, go toTry EF Core 9 now! on GitHub.
Enhanced database provider for Azure Cosmos DB for NoSQL
We are working on significant updates in EF9 to the EF Core database provider for Azure Cosmos DB for NoSQL. For preview 4, these include:
- Role-based access control (RBAC) is supported by EF9 for both management and use of containers.
- Azure Cosmos DB for NoSQL does not support synchronous (blocking) access from application code. EF Core now blocks synchronous access by default, helping people fall into the pit-of-success of using async I/O.
- Cosmos primitive collection support has been updated to use the metadata and model building APIs from EF8
SeeAzure Cosmos DB for NoSQL in theWhat's New docs for more information.
GroupBy complex types
In preview 4, EF9 now supports grouping (GroupBy queries) that group by a complex type instance. The resulting SQL uses groups by all members, reflecting the value object semantics of complex types.
SeeGroupBy complex types in theWhat's New docs for more information.
Read-only primitive collections
EF8 introduced support for mapping arrays and mutable lists of primitive types. This has been expanded in EF9 to include read-only collections declared asIReadOnlyList,IReadOnlyCollection, orReadOnlyCollection.
SeeRead-only primitive collections in theWhat's New docs for more information.
Everything else in preview 4
Preview 4 contains:
EF Core 9 preview 4 (and Microsoft.Data.Sqlite) contains work from the EF Team at Microsoft (@roji @AndriySvyryd @maumar @ajcvickers @cincuranet @SamMonoRT @luisquintanilla) as well as contributions from the EF Core community. The community PRs in EF9 Preview 4 are:
9.0.0-preview.3.24172.4
The team has been working primarily on EF Core internals, so there are no new big features in EF Core 9 (EF9) Preview 3. However, this means we really need people like you to run your code on these new internals and report back what you find. We want to fix bugs in the new internals as soon as possible in order to have a strong GA release later in the year.
That being said, there are several smaller enhancements included in preview 3. For full details, seeWhat's new in EF Core 9. To discuss the EF9 release, go toTry EF Core 9 now! on GitHub.
Auto-compiled models
Auto-compiled models allow theEF Core compiled model to be automatically regenerated when the model project is built. This means you no longer need to remember to re-run thedotnet ef dbcontext optimize command after your EF model changes. SeeAuto-compiled models in theWhat's New docs for more information.
Sugar forHierarchyId path generation
First class support for the SQL ServerHierarchyId type wasadded in EF8. In EF9, a sugar method has been added to make it easier to create new child nodes in the tree structure. SeeSugar for HierarchyId path generation in theWhat's New docs for more information.
Everything else in preview 3
Preview 3 contains:
EF Core 9 preview 3 (and Microsoft.Data.Sqlite) contains work from the EF Team at Microsoft (@roji @AndriySvyryd @maumar @ajcvickers @cincuranet @SamMonoRT @luisquintanilla) as well as contributions from the EF Core community. The community PRs in EF9 Preview 3 are:
9.0.0-preview.2.24128.4
The team has been working primarily on EF Core internals, so there are no new big features in EF Core 9 (EF9) Preview 2. However, this means we really need people like you to run your code on these new internals and report back what you find. We want to fix bugs in the new internals as soon as possible in order to have a strong GA release later in the year.
That being said, there are several smaller enhancements included in preview 2, many contributed by our community. For full details, seeWhat's new in EF Core 9. To discuss the EF9 release, go toTry EF Core 9 now! on GitHub.
Improved queries
- Inlined uncorrelated subqueries
- New ToHashSetAsync methods
- The
ToHashSet methods have existed since .NET Core 2.0. In EF9, the equivalent async methods have been added. - SeeNew
ToHashSetAsync<T> methods for full details.
Improved model building
- Specify caching for sequences
- EF9 allows setting the caching options for database sequences for any relational database provider that supports this.
- SeeSpecify caching for sequences for full details.
- Specify fill-factor for keys and indexes
Improved tooling
- Fewer rebuilds when using
dotnet ef tools- EF9 invalidates build caches less often, resulting in faster re-builds.
- SeeFewer rebuilds for full details.
Everything else in preview 2
Preview 2 contains:
EF Core 9 preview 2 (and Microsoft.Data.Sqlite) contains work from the EF Team at Microsoft (@roji @AndriySvyryd @maumar @ajcvickers) as well as contributions from the EF Core community. The community PRs in EF9 Preview 1 are:
9.0.0-preview.1.24081.2
The team has been working primarily on EF Core internals, so there are no new big features in EF Core 9 (EF9) Preview 1. However, this means we really need people like you to run your code on these new internals and report back what you find. We want to fix bugs in the new internals as soon as possible in order to have a strong GA release later in the year.
That being said, there are also several smaller enhancements included in preview 1. One of these might be just the thing you have been waiting for, so read on!
Improved queries
- Prune columns passed to OPENJSON's WITH clause
- EF9 removes unnecessary columns when calling
OPENJSON WITH. - SeePrune columns from JSON in the What's New docs for full details including runnable samples.
- Translations involving GREATEST/LEAST
- Several new translations have been introduced that use the
GREATEST andLEAST SQL functions. - This includes translations of
Math.Min andMath.Max in non-aggregate queries, as well as directly exposing theGREATEST andLEAST SQL functions in relational providers. - SeeGREATEST/LEAST translations in the What's New docs for full details including runnable samples.
- Force or prevent query parameterization
- Except in some special cases, EF Core parameterizes variables used in a LINQ query, but includes constants in the generated SQL. EF9 allows constants to be translated to parameters and variables to be translated to constants on a case to case basis.
- SeeForce or prevent query parameterization in the What's New docs for full details including runnable samples.
ExecuteUpdate
- Allow passing complex type instances to ExecuteUpdate
- EF9 supports directly passing complex type instances to
ExecuteUpdate as sugar for updating all member values. - SeeExecuteUpdate for complex types in the What's New docs for full details including runnable samples.
Temporal tables
- Small migrations for temporal tables
- The migration created when changing an existing table into a temporal table has been reduced in size for EF9.
- SeeImproved temporal table migrations in the What's New docs for full details including runnable samples.
Model building
- Make existing model building conventions more extensible
- In EF9, we have made it easier to extend some of the existing conventions, such as those for property and key discovery.
- SeeExtensible model building conventions in the What's New docs for full details including runnable samples.
- ApplyConfigurationsFromAssembly calls non-public constructors
Everything else in Preview 1
Preview 1 contains:
8.0.22
Release
What's Changed
Full Changelog:dotnet/efcore@v8.0.21...v8.0.22
8.0.21
Release
What's Changed
Full Changelog:dotnet/efcore@v8.0.20...v8.0.21
8.0.20
Release
What's Changed
Full Changelog:dotnet/efcore@v8.0.19...v8.0.20
8.0.17
Dependency Updates
- Update dependencies from dotnet/arcade (#36085)
Updates the project's dependencies using the latest versions from the dotnet/arcade repository. This ensures that the build infrastructure and related tooling are up to date, which can bring in important bug fixes, security patches, and improvements from upstream.
Miscellaneous
Update branding to 8.0.17 (#36043)
Updates the internal version branding to 8.0.17. This change ensures that the product and its packages correctly reflect the new release version, helping users and developers identify the build.
Merging internal commits for release/8.0 (#36080)
Integrates various internal commits into the release/8.0 branch. This merge brings together important updates and ensures the release branch is synchronized with recent internal development, maintaining consistency and stability for the release.
This summary is generated and may contain inaccuracies. For complete details, please review the linked pull requests.
Full Changelog:v8.0.16...v8.0.17
8.0.16
Release
What's Changed
Full Changelog:dotnet/efcore@v8.0.15...v8.0.16
Commits viewable incompare view.
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting@dependabot rebase.
UpdatedMicrosoft.EntityFrameworkCore.Relational from 8.0.15 to 9.0.1.
Release notes
Sourced fromMicrosoft.EntityFrameworkCore.Relational's releases.
9.0.1
Release
What's Changed
^and~when invalid because of value converters by @roji in[release/9.0] Avoid using^and~when invalid because of value converters dotnet/efcore#35241Full Changelog:dotnet/efcore@v9.0.0...v9.0.1
9.0.0
Release
What's Changed
... (truncated)
9.0.0-rc.2.24474.1
Release
9.0.0-rc.1.24451.1
Release
9.0.0-preview.7.24405.3
Release
9.0.0-preview.6.24327.4
Release
9.0.0-preview.5.24306.3
The team has been working primarily on EF Core internals, so there are no new big features in EF Core 9 (EF9) Preview 5. However, this means we really need people like you to run your code on these new internals and report back what you find. We want to fix bugs in the new internals as soon as possible in order to have a strong GA release later in the year.
That being said, there are several smaller enhancements included in preview 5. For full details, seeWhat's new in EF Core 9. To discuss the EF9 release, go toTry EF Core 9 now! on GitHub.
Enhanced database provider for Azure Cosmos DB for NoSQL
We are working on significant updates in EF9 to the EF Core database provider for Azure Cosmos DB for NoSQL. For preview 5, these include:
SeeAzure Cosmos DB for NoSQL in theWhat's New docs for more information.
Query translation improvements
EF9 preview 5 contains three small enhancements to query translation:
Count != 0orCount > 0TimeOnly.FromDateTimeandTimeOnly.FromTimeSpanSeeLINQ and SQL translation in theWhat's New docs for more information.
Everything else in preview 5
Preview 5 contains:
EF Core 9 preview 5 and Microsoft.Data.Sqlite contain work from the EF Team at Microsoft (@roji @AndriySvyryd @maumar @ajcvickers @cincuranet @SamMonoRT @luisquintanilla).
9.0.0-preview.4.24267.1
The team has been working primarily on EF Core internals, so there are no new big features in EF Core 9 (EF9) Preview 4. However, this means we really need people like you to run your code on these new internals and report back what you find. We want to fix bugs in the new internals as soon as possible in order to have a strong GA release later in the year.
That being said, there are several smaller enhancements included in preview 4. For full details, seeWhat's new in EF Core 9. To discuss the EF9 release, go toTry EF Core 9 now! on GitHub.
Enhanced database provider for Azure Cosmos DB for NoSQL
We are working on significant updates in EF9 to the EF Core database provider for Azure Cosmos DB for NoSQL. For preview 4, these include:
SeeAzure Cosmos DB for NoSQL in theWhat's New docs for more information.
GroupBy complex types
In preview 4, EF9 now supports grouping (
GroupByqueries) that group by a complex type instance. The resulting SQL uses groups by all members, reflecting the value object semantics of complex types.SeeGroupBy complex types in theWhat's New docs for more information.
Read-only primitive collections
EF8 introduced support for mapping arrays and mutable lists of primitive types. This has been expanded in EF9 to include read-only collections declared as
IReadOnlyList,IReadOnlyCollection, orReadOnlyCollection.SeeRead-only primitive collections in theWhat's New docs for more information.
Everything else in preview 4
Preview 4 contains:
EF Core 9 preview 4 (and Microsoft.Data.Sqlite) contains work from the EF Team at Microsoft (@roji @AndriySvyryd @maumar @ajcvickers @cincuranet @SamMonoRT @luisquintanilla) as well as contributions from the EF Core community. The community PRs in EF9 Preview 4 are:
9.0.0-preview.3.24172.4
The team has been working primarily on EF Core internals, so there are no new big features in EF Core 9 (EF9) Preview 3. However, this means we really need people like you to run your code on these new internals and report back what you find. We want to fix bugs in the new internals as soon as possible in order to have a strong GA release later in the year.
That being said, there are several smaller enhancements included in preview 3. For full details, seeWhat's new in EF Core 9. To discuss the EF9 release, go toTry EF Core 9 now! on GitHub.
Auto-compiled models
Auto-compiled models allow theEF Core compiled model to be automatically regenerated when the model project is built. This means you no longer need to remember to re-run the
dotnet ef dbcontext optimizecommand after your EF model changes. SeeAuto-compiled models in theWhat's New docs for more information.Sugar for
HierarchyIdpath generationFirst class support for the SQL Server
HierarchyIdtype wasadded in EF8. In EF9, a sugar method has been added to make it easier to create new child nodes in the tree structure. SeeSugar for HierarchyId path generation in theWhat's New docs for more information.Everything else in preview 3
Preview 3 contains:
EF Core 9 preview 3 (and Microsoft.Data.Sqlite) contains work from the EF Team at Microsoft (@roji @AndriySvyryd @maumar @ajcvickers @cincuranet @SamMonoRT @luisquintanilla) as well as contributions from the EF Core community. The community PRs in EF9 Preview 3 are:
9.0.0-preview.2.24128.4
The team has been working primarily on EF Core internals, so there are no new big features in EF Core 9 (EF9) Preview 2. However, this means we really need people like you to run your code on these new internals and report back what you find. We want to fix bugs in the new internals as soon as possible in order to have a strong GA release later in the year.
That being said, there are several smaller enhancements included in preview 2, many contributed by our community. For full details, seeWhat's new in EF Core 9. To discuss the EF9 release, go toTry EF Core 9 now! on GitHub.
Improved queries
ToHashSetmethods have existed since .NET Core 2.0. In EF9, the equivalent async methods have been added.ToHashSetAsync<T>methods for full details.Improved model building
Improved tooling
dotnet eftoolsEverything else in preview 2
Preview 2 contains:
EF Core 9 preview 2 (and Microsoft.Data.Sqlite) contains work from the EF Team at Microsoft (@roji @AndriySvyryd @maumar @ajcvickers) as well as contributions from the EF Core community. The community PRs in EF9 Preview 1 are:
ToHashSetAsync<T>Extension methods onIQueryable<T>9.0.0-preview.1.24081.2
The team has been working primarily on EF Core internals, so there are no new big features in EF Core 9 (EF9) Preview 1. However, this means we really need people like you to run your code on these new internals and report back what you find. We want to fix bugs in the new internals as soon as possible in order to have a strong GA release later in the year.
That being said, there are also several smaller enhancements included in preview 1. One of these might be just the thing you have been waiting for, so read on!
Improved queries
OPENJSON WITH.GREATESTandLEASTSQL functions.Math.MinandMath.Maxin non-aggregate queries, as well as directly exposing theGREATESTandLEASTSQL functions in relational providers.ExecuteUpdate
ExecuteUpdateas sugar for updating all member values.Temporal tables
Model building
Everything else in Preview 1
Preview 1 contains:
... (truncated)
8.0.22
Release
What's Changed
Full Changelog:dotnet/efcore@v8.0.21...v8.0.22
8.0.21
Release
What's Changed
Full Changelog:dotnet/efcore@v8.0.20...v8.0.21
8.0.20
Release
What's Changed
Full Changelog:dotnet/efcore@v8.0.19...v8.0.20
8.0.17
Dependency Updates
Updates the project's dependencies using the latest versions from the dotnet/arcade repository. This ensures that the build infrastructure and related tooling are up to date, which can bring in important bug fixes, security patches, and improvements from upstream.
Miscellaneous
Update branding to 8.0.17 (#36043)
Updates the internal version branding to 8.0.17. This change ensures that the product and its packages correctly reflect the new release version, helping users and developers identify the build.
Merging internal commits for release/8.0 (#36080)
Integrates various internal commits into the release/8.0 branch. This merge brings together important updates and ensures the release branch is synchronized with recent internal development, maintaining consistency and stability for the release.
This summary is generated and may contain inaccuracies. For complete details, please review the linked pull requests.
Full Changelog:v8.0.16...v8.0.17
8.0.16
Release
What's Changed
Full Changelog:dotnet/efcore@v8.0.15...v8.0.16
Commits viewable incompare view.
UpdatedNpgsql.EntityFrameworkCore.PostgreSQL from 8.0.4 to 9.0.4.
Release notes
Sourced fromNpgsql.EntityFrameworkCore.PostgreSQL's releases.
9.0.4
Milestone issues
Full Changelog:npgsql/efcore.pg@v9.0.3...v9.0.4
9.0.3
Milestone issues
Full Changelog:npgsql/efcore.pg@v9.0.2...v9.0.3
9.0.2
EFCore.PG depends onNpgsql 9.0.2, which contains an important fix around SSL validation (npgsql/npgsql#5942).
Milestone issues
Full Changelog:npgsql/efcore.pg@v9.0.1...v9.0.2
9.0.0
See therelease notes.
The full list of changes is availablehere.
What's Changed
... (truncated)
8.0.11
The full list of changes is availablehere.
Full Changelog:npgsql/efcore.pg@v8.0.10...v8.0.11
8.0.10
The full list of changes is availablehere.
Full Changelog:npgsql/efcore.pg@v8.0.8...v8.0.10
8.0.8
The full list of changes is availablehere.
Full Changelog:npgsql/efcore.pg@v8.0.4...v8.0.8
Commits viewable incompare view.
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting
@dependabot rebase.Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR:
@dependabot rebasewill rebase this PR@dependabot recreatewill recreate this PR, overwriting any edits that have been made to it@dependabot mergewill merge this PR after your CI passes on it@dependabot squash and mergewill squash and merge this PR after your CI passes on it@dependabot cancel mergewill cancel a previously requested merge and block automerging@dependabot reopenwill reopen this PR if it is closed@dependabot closewill close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually@dependabot show <dependency name> ignore conditionswill show all of the ignore conditions of the specified dependency@dependabot ignore this major versionwill close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this minor versionwill close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)@dependabot ignore this dependencywill close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)