Update dependency dotnet-ef to v7 - autoclosed

This PR contains the following updates:

Package	Type	Update	Change
dotnet-ef (source)	nuget	major	`3.1.6` -> `7.0.13`

Release Notes

dotnet/efcore (dotnet-ef)

### [`v7.0.13`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.13): .NET 7.0.13 [Release](https://togithub.com/dotnet/core/releases/tag/v7.0.13) ### [`v7.0.12`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.12): EF Core 7.0.12 This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.12) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.11. ### [`v7.0.11`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.11): EF Core 7.0.11 This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.11) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.10. ### [`v7.0.10`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.10): EF Core 7.0.10 EF Core 7.0.10 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.10). This is a patch release of EF Core 7 containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.10+is%3Aclosed): - [Scaffolding synapse fails when attempting to enumerate triggers](https://togithub.com/dotnet/efcore/issues/30998) - [Silent data loss when adding objects to an sqlite DB with PRAGMA journal_mode=DELETE in a multi-threaded environment.](https://togithub.com/dotnet/efcore/issues/30851) ### [`v7.0.9`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.9): EF Core 7.0.9 EF Core 7.0.9 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.9). This is a patch release of EF Core 7 containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.9+is%3Aclosed): - [Error "Index was outside the bounds of the array." when reading from dataset without AsNoTracking()](https://togithub.com/dotnet/efcore/issues/30764) ### [`v7.0.8`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.8): EF Core 7.0.8 This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.8) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.7. ### [`v7.0.7`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.7): EF Core 7.0.7 EF Core 7.0.7 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.7). This is a patch release of EF Core 7 containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.7+is%3Aclosed): - [IndexOutOfRangeException in CreateNavigationExpansionExpression](https://togithub.com/dotnet/efcore/issues/30115) - [Linq select cannot project an entity containing both Json columns and ICollections](https://togithub.com/dotnet/efcore/issues/30266) - [Json: updating property with conversion from string to other type fails on sql server](https://togithub.com/dotnet/efcore/issues/30330) - [Duplicate table alias in generated select query (An item with the same key has already been added)](https://togithub.com/dotnet/efcore/issues/30358) - [InvalidOperationException when calling ExecuteUpdate with owned entity & using current value](https://togithub.com/dotnet/efcore/issues/30528) - [Query/Json: projecting entity collection along with json collection generates invalid shaper](https://togithub.com/dotnet/efcore/issues/30565) - [AutoInclude causes ExecuteDelete to fail](https://togithub.com/dotnet/efcore/issues/30572) - [Multiple LeftJoins (GroupJoins) lead to GroupJoin Exception when the same where is used twice](https://togithub.com/dotnet/efcore/issues/30575) - [SaveChanges circular dependency in unique unfiltered index (when change doesn't affect any column from unique index).](https://togithub.com/dotnet/efcore/issues/30601) ### [`v7.0.5`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.5): EF Core 7.0.5 EF Core 7.0.5 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.5). This is a patch release of EF Core 7 containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.5+is%3Aclosed): - [Can't add migration renaming a column on TPC root](https://togithub.com/dotnet/efcore/issues/30321) - [Scaffolded collection navigation properties do not have setters](https://togithub.com/dotnet/efcore/issues/30286) - [EF7 generating incorrect SQL for the Concat/Union All](https://togithub.com/dotnet/efcore/issues/30273) - [Added nullable property to Json mapped model resulting in errors instead of mapping non existing json property to null](https://togithub.com/dotnet/efcore/issues/30028) ### [`v7.0.4`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.4): EF Core 7.0.4 This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.4) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.4+is%3Aclosed): - [Exception replacing multi-level relationship in EF7](https://togithub.com/dotnet/efcore/issues/30135) - [Deletion can cause error "The association between entity types A and B has been severed..."](https://togithub.com/dotnet/efcore/issues/30122) - [Non-empty second migration in TPC scheme using inheritance](https://togithub.com/dotnet/efcore/issues/30058) - [Entity Framework Core 7 keeps creating the same migration for Nullable DateTime field](https://togithub.com/dotnet/efcore/issues/29985) - [TPC mapping strategy not respecting default database schema during migration](https://togithub.com/dotnet/efcore/issues/29899) - [Count after Take throws "No column name was specified for column 1 of 't'."](https://togithub.com/dotnet/efcore/issues/29667) And for [Microsoft.Data.Sqlite](https://www.nuget.org/packages/Microsoft.Data.Sqlite/7.0.4): - [ArgumentOutOfRangeException in SqliteConnectionFactory.PruneCallback](https://togithub.com/dotnet/efcore/issues/29952) ### [`v7.0.3`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.3): EF Core 7.0.3 This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.3) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.3+is%3Aclosed): - [Add-Migration fails with "An item with the same key has already been added" when renaming entity](https://togithub.com/dotnet/efcore/issues/27504) - [ExecuteUpdate fails when target entity has an owned entity](https://togithub.com/dotnet/efcore/issues/28727) - [EF Core 7 Rev eng: Missing HasForeignKey when referencing a navigation property with a unique constraint with DataAnnotations on](https://togithub.com/dotnet/efcore/issues/29418) - [Change in behaviour of CSharpHelper.Identifier(string name)](https://togithub.com/dotnet/efcore/issues/29450) - [NullReferenceException scaffolding when no primary key set](https://togithub.com/dotnet/efcore/issues/29516) - [Idempotent migration script not working on EFCore7.0 for AlterColumn when nullable changed from true to false](https://togithub.com/dotnet/efcore/issues/29530) - [6.0.11 to 7.0.0: \[...\] are both mapped to column \[..\] but are configured to use differing provider types ('double' and 'double?').'](https://togithub.com/dotnet/efcore/issues/29531) - [Generated Model Snapshot throws InvalidOperationException](https://togithub.com/dotnet/efcore/issues/29534) - [SQL Server bulk insert broken when new command applies pending commands and goes over the batch parameter limit](https://togithub.com/dotnet/efcore/issues/29539) - [Invalid singularization when scaffolding a manytomany table](https://togithub.com/dotnet/efcore/issues/29544) - [In EF7, SqLite unable to load spatialite using the NetTopologySuite Package](https://togithub.com/dotnet/efcore/issues/29584) - [Cannot access property through interface in ExecuteUpdate setter lambda](https://togithub.com/dotnet/efcore/issues/29618) - [DbContext scaffold missing IndexerProperty for M2M relation after moving to EF Core 7](https://togithub.com/dotnet/efcore/issues/29634) - [Performance regression in model building in Entity Framework Core 7](https://togithub.com/dotnet/efcore/issues/29642) - [Mixing sproc and non-sproc commands in the same batch may fail with a NullReferenceException](https://togithub.com/dotnet/efcore/issues/29643) - [Condition's order will cause different result when using .Contains() to search string cross varchar and nvarchar columns](https://togithub.com/dotnet/efcore/issues/29646) - [SaveChanges circular dependency in unique unfiltered index](https://togithub.com/dotnet/efcore/issues/29647) - [QueryTrackingBehavior resets to TrackAll when using DbContext pooling](https://togithub.com/dotnet/efcore/issues/29733) - [EFCore 7.0.0 - Graph of entity insertion throws a FK exception](https://togithub.com/dotnet/efcore/issues/29741) - [Replacing PK to PK TPH dependent with different type fails](https://togithub.com/dotnet/efcore/issues/29789) - [dotnet ef migrations add freezes](https://togithub.com/dotnet/efcore/issues/29826) - [InvalidOperationException when mapping properties of different types to the same column](https://togithub.com/dotnet/efcore/issues/29859) - [Obsoletion message for AutoTransactionsEnabled is wrong](https://togithub.com/dotnet/efcore/issues/29990) - [Incorrect NullReferenceException for parameter in split query with GroupBy](https://togithub.com/dotnet/efcore/issues/30022) ### [`v7.0.2`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.2): EF Core 7.0.2 (EF7) This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.2) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.2+is%3Aclosed): - [Exception when inserting multiple rows into the same table on SQL Server](https://togithub.com/dotnet/efcore/issues/29502) ### [`v7.0.1`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.1): EF Core 7.0.1 (EF7) This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.1) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.1. ### [`v7.0.0`](https://togithub.com/dotnet/efcore/releases/tag/v7.0.0): EF Core 7.0 (EF7) EF Core 7.0 GA (commonly referred to as EF7) is now available from [NuGet](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.0). See [What's New in EF7](https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-7.0/whatsnew) for a detailed look at all the new features in EF7. In summary, the following new features are included in EF7: - [Make basic EF scenarios work under aggressive trimming](https://togithub.com/dotnet/efcore/issues/29092) - [Entity splitting support](https://togithub.com/dotnet/efcore/issues/620) - [Support for GroupBy entityType](https://togithub.com/dotnet/efcore/issues/17653) - [Support GroupJoin when it is final query operator](https://togithub.com/dotnet/efcore/issues/19930) - [ExecuteUpdate: Add SetProperty overload that accepts a value directly (no lambda)](https://togithub.com/dotnet/efcore/issues/28968) - [Support sproc input/output parameters on non-concurrency-token properties](https://togithub.com/dotnet/efcore/issues/28704) - [Implement TagWith for ExecuteUpdate and DeleteUpdate](https://togithub.com/dotnet/efcore/issues/28690) - [ExecuteDelete for owner when only its owned types are sharing the same table](https://togithub.com/dotnet/efcore/issues/28671) - [Stop scaffolding DbSet initialization to null!](https://togithub.com/dotnet/efcore/issues/26877) - [CSharpHelper: support more types of collection literals](https://togithub.com/dotnet/efcore/issues/19274) - [Map JSON values stored in database to EF properties](https://togithub.com/dotnet/efcore/issues/4021) - [ExecuteUpdate/Delete (AKA bulk update, without loading data into memory)](https://togithub.com/dotnet/efcore/issues/795) - [Code templates for scaffolding entity types and DbContext from an existing database](https://togithub.com/dotnet/efcore/issues/4038) - [Support raw SQL Queries for basic types like Guid, DateTime and int](https://togithub.com/dotnet/efcore/issues/11624) - [Allow applications to create model building conventions (aka public conventions)](https://togithub.com/dotnet/efcore/issues/214) - [Cosmos: Support AAD RBAC via the ClientSecretCredential](https://togithub.com/dotnet/efcore/issues/26491) - [Map inserts, updates, and deletes (CUD operations) to stored procedures](https://togithub.com/dotnet/efcore/issues/245) - [Add a static flag in EF that will be set when code is being executed for design-time discover](https://togithub.com/dotnet/efcore/issues/27306) - [Support sequence key generation on SQL Server, which is useful for Table-per-concrete-type (TPC) mapping](https://togithub.com/dotnet/efcore/issues/28096) - [Allow null connection string to be passed to UseProvider methods](https://togithub.com/dotnet/efcore/issues/26869) - [Downgrade the ContextInitialized event from Information to Debug](https://togithub.com/dotnet/efcore/issues/28480) - [Get an EntityEntry for Shared Entity Types](https://togithub.com/dotnet/efcore/issues/25354) - [Make EntityEntryGraphIterator publicly usable](https://togithub.com/dotnet/efcore/issues/26461) - [Support unidirectional many-to-many relationships](https://togithub.com/dotnet/efcore/issues/3864) - [Translate string.Join and string.Concat](https://togithub.com/dotnet/efcore/issues/2981) - [RevEng: Enable generating IEntityTypeConfiguration classes (avoids large OnModelCreating)](https://togithub.com/dotnet/efcore/issues/8434) - [Interception to modify the LINQ expression tree](https://togithub.com/dotnet/efcore/issues/28505) - [Interception for DbUpdateConcurrencyException](https://togithub.com/dotnet/efcore/issues/28315) - [Add interception event to be fired when EF has finished consuming a result set](https://togithub.com/dotnet/efcore/issues/23535) - [Add events for DetectChanges/state change](https://togithub.com/dotnet/efcore/issues/16256) - [ChangeTracker: New event for "entity about to get tracked"](https://togithub.com/dotnet/efcore/issues/27093) - [Translate EnvelopeCombiner.CombineAsGeometry aggregate function](https://togithub.com/dotnet/efcore/issues/28184) - [SQL Server: Translate statistics aggregate functions](https://togithub.com/dotnet/efcore/issues/28104) - [Filtered Includes for hidden navigation properties](https://togithub.com/dotnet/efcore/issues/27493) - [Make it easier to pass a CancellationToken to FindAsync](https://togithub.com/dotnet/efcore/issues/22667) - [Interception for object materialization (a.k.a. "ObjectMaterialized")](https://togithub.com/dotnet/efcore/issues/15911) - [Provide a hook for identity resolution](https://togithub.com/dotnet/efcore/issues/20124) - [Create lazy-loading and change-tracking proxy types lazily](https://togithub.com/dotnet/efcore/issues/20135) - [Compiled model: Allow use of lazy loading and change tracking proxy types](https://togithub.com/dotnet/efcore/issues/24902) - [Full support for custom provider aggregate functions](https://togithub.com/dotnet/efcore/issues/22957) - [Spatial: Translate aggregate functions](https://togithub.com/dotnet/efcore/issues/13278) - [Allow specifying different column names per table in TPT, TPC or entity splitting](https://togithub.com/dotnet/efcore/issues/19811) - [Support for custom proxy generation](https://togithub.com/dotnet/efcore/issues/14554) - [TPC inheritance mapping pattern](https://togithub.com/dotnet/efcore/issues/3170) - [DeleteBehaviorAttribute](https://togithub.com/dotnet/efcore/issues/9621) - [Translate GetType() for entity types with inheritance](https://togithub.com/dotnet/efcore/issues/13424) - [Delay DbCommandInterceptor.CommandCreated until DbCommand properties are initialized](https://togithub.com/dotnet/efcore/issues/17261) - [Remove unnecessary extra batches in SaveChanges](https://togithub.com/dotnet/efcore/issues/20664) - [Don't check for a connection string until after ConnectionOpening has been called](https://togithub.com/dotnet/efcore/issues/23085) - [Add ConnectionCreating/ConnectionCreated to DbConnectionInterceptor](https://togithub.com/dotnet/efcore/issues/23087) - [Migration name filter](https://togithub.com/dotnet/efcore/issues/23222) - [Add support for AT TIME ZONE](https://togithub.com/dotnet/efcore/issues/26199) - [GroupBy aggregate lifting](https://togithub.com/dotnet/efcore/issues/27132) - [Pascal-case the DbContext name when scaffolding](https://togithub.com/dotnet/efcore/issues/27886) - [Support value generation with converters](https://togithub.com/dotnet/efcore/issues/11597) - [Improve batching performance when using TPH mappings](https://togithub.com/dotnet/efcore/issues/3954) - [Attribute (Data Annotations) mapping for composite primary keys](https://togithub.com/dotnet/efcore/issues/11003) - [SQL Server UTF8 collations](https://togithub.com/dotnet/efcore/issues/25798) - [Stop wrapping single changes in transactions where possible](https://togithub.com/dotnet/efcore/issues/27439) - [Use RETURNING/OUTPUT clause for UPDATE/DELETE](https://togithub.com/dotnet/efcore/issues/27547) - [SQLite SaveChanges: Use RETURNING clause](https://togithub.com/dotnet/efcore/issues/24835) - [SQL Server: Optimize SQL Server OUTPUT clause usage when retrieving database-generated values](https://togithub.com/dotnet/efcore/issues/27372) - [Stop automatically deleting orphans for optional relationships with cascade delete configured](https://togithub.com/dotnet/efcore/issues/27217) - [Empty default interface implementations for all interceptor interface methods](https://togithub.com/dotnet/efcore/issues/27625) - [Temporal tables support for owned entities and other table splitting scenarios](https://togithub.com/dotnet/efcore/issues/26469) - [Support for index ordering (ASC/DESC)](https://togithub.com/dotnet/efcore/issues/4150) - [Support "non-rooted" query expressions in compiled queries](https://togithub.com/dotnet/efcore/issues/7016) - [Property/Reference/etc overloads that take IProperty/INavigation](https://togithub.com/dotnet/efcore/issues/7390) - [Distinguish cancellation from failure to allow different logging strategies](https://togithub.com/dotnet/efcore/issues/19526) - [Lift table from subquery when joining if no additional operations](https://togithub.com/dotnet/efcore/issues/21321) - [DiagnosticSuppressor for CS8618 for DbSet properties](https://togithub.com/dotnet/efcore/issues/21608) - [Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring](https://togithub.com/dotnet/efcore/issues/23515) - [Robust and extensible SQL precedence/parentheses mechanism](https://togithub.com/dotnet/efcore/issues/23895) - [Translation for string.IndexOf(string, int)](https://togithub.com/dotnet/efcore/issues/25396) - [Support SqlNullabilityProcessor and COALESCE with more than two arguments](https://togithub.com/dotnet/efcore/issues/26344) - [Support Contains when using a IReadOnlySet](https://togithub.com/dotnet/efcore/issues/26437) - [Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay](https://togithub.com/dotnet/efcore/issues/27074) See GitHub for [all issues resolved in EF7](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.0+is%3Aclosed). ### [`v6.0.24`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.24): .NET 6.0.24 [Release](https://togithub.com/dotnet/core/releases/tag/v6.0.24) ### [`v6.0.23`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.23): EF Core 6.0.23 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.23) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.22. ### [`v6.0.22`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.22): EF Core 6.0.22 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.22) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.21. ### [`v6.0.21`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.21): EF Core 6.0.21 EF Core 6.0.21 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.21). This is a patch release of EF Core 6 containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.21+is%3Aclosed): - [Silent data loss when adding objects to an sqlite DB with PRAGMA journal_mode=DELETE in a multi-threaded environment.](https://togithub.com/dotnet/efcore/issues/30851) ### [`v6.0.20`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.20): EF Core 6.0.20 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.20) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.19. ### [`v6.0.19`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.19): EF Core 6.0.19 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.19) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.18. ### [`v6.0.18`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.18): EF Core 6.0.18 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.18) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.16. ### [`v6.0.16`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.16): EF Core 6.0.16 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.16) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.15. ### [`v6.0.15`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.15): EF Core 6.0.15 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.15) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.14. ### [`v6.0.14`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.14): EF Core 6.0.14 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.14) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.13. ### [`v6.0.13`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.13): EF Core 6.0.13 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.13) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.12. ### [`v6.0.12`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.12): EF Core 6.0.12 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.12) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.12+is%3Aclosed): - [string.IndexOf throws NullReferenceException when applied on the result of a DbFunction ](https://togithub.com/dotnet/efcore/issues/29204) - [Function StoreType is ignored for DateTime](https://togithub.com/dotnet/efcore/issues/27954) - [RelationalMethodCallTranslatorProvider and explicit typeMapping](https://togithub.com/dotnet/efcore/issues/27524) ### [`v6.0.11`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.11): EF Core 6.0.11 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.11) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.11+is%3Aclosed): - [Excessive memory usage after enabling DbContextFactory](https://togithub.com/dotnet/efcore/issues/28988) - [Avoid re-sending PRAGMA KEY on pooled SQLite connections](https://togithub.com/dotnet/efcore/issues/28967) ### [`v6.0.10`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.10): EF Core 6.0.10 This is a [patch release of EF Core 6.0.](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.10) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.9. ### [`v6.0.9`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.9): EF Core 6.0.9 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.9) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.9+is%3Aclosed): - [Scaffolding with NRT generates non-nullable navigation property from principal to dependent](https://togithub.com/dotnet/efcore/issues/27496) - [Migrations containing strings with many line-breaks will truncate strings silently](https://togithub.com/dotnet/efcore/issues/27206) ### [`v6.0.8`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.8): EF Core 6.0.8 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.8) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.87+is%3Aclosed): - [Regression in 6.0.2: The variable name '@p0' has already been declared.](https://togithub.com/dotnet/efcore/issues/27427) ### [`v6.0.7`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.7): EF Core 6.0.7 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.7) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.7+is%3Aclosed): - [Don't add grouping key to projection when Distinct is applied](https://togithub.com/dotnet/efcore/issues/28039) ### [`v6.0.6`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.6): EF Core 6.0.6 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.6) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.6+is%3Aclosed): - [Can't create a view with navigation property](https://togithub.com/dotnet/efcore/issues/27854) - [Tools: Add dotnet-ef shims arm64](https://togithub.com/dotnet/efcore/issues/27827) - [Diagnostics: DataReaderDisposingEventData.ReadCount accumulates the value from different readers](https://togithub.com/dotnet/efcore/issues/27652) - [Consider setting NullabilityInfoContextSupport=true in EF's NuGet package](https://togithub.com/dotnet/efcore/issues/27474) - [SQLite doesn't work when trimming](https://togithub.com/dotnet/efcore/issues/27311) - [dotnet-ef needs to target 6](https://togithub.com/dotnet/efcore/issues/27787) Note that this release contains a [breaking change for the `dotnet-ef` command line tool](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/breaking-changes#dotnet-ef). ### [`v6.0.5`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.5): EF Core 6.0.5 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.5) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.5+is%3Aclosed): - [Query exception after upgrading from 6.0.1 to 6.0.2](https://togithub.com/dotnet/efcore/issues/27600) ### [`v6.0.4`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.4): EF Core 6.0.4 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.4) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.4+is%3Aclosed): - [Exception from SQLite provider when application is shutting down](https://togithub.com/dotnet/efcore/issues/27168) - [Collection_navigation_equal_to_null_for_subquery fails after merging from release/6.0](https://togithub.com/dotnet/efcore/issues/27356) - [EF Core 6.0 temporal tables - migration rollback doesn't work](https://togithub.com/dotnet/efcore/issues/27375) - [InvalidOperationException on save after upgrading from 5 to 6](https://togithub.com/dotnet/efcore/issues/27455) ### [`v6.0.3`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.3): EF Core 6.0.3 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.3) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.3+is%3Aclosed): - [FirstOrDefault after custom projection == null cannot be translated](https://togithub.com/dotnet/efcore/issues/18476) - [DbContext scaffolding creates reference error CS0120 in nameof() for InverseProperty in certain conditions](https://togithub.com/dotnet/efcore/issues/26588) - [EF core 6 selecting null values despite where clause asking for not null](https://togithub.com/dotnet/efcore/issues/26744) - [Query: Rownumber conversion needs better logic to figure out partitions](https://togithub.com/dotnet/efcore/issues/26756) - [Suboptimal SQL generation for query with optional navigation, its collection navigation and lateral join](https://togithub.com/dotnet/efcore/issues/27072) - [Aggregates on multiple child tables produces invalid SQL](https://togithub.com/dotnet/efcore/issues/27163) - [ServiceProviderCache keeps initially created IServiceProvider indefinitely](https://togithub.com/dotnet/efcore/issues/27169) - [Setting a Nullable Foreign Key property to Null triggers cascade delete](https://togithub.com/dotnet/efcore/issues/27174) - [Optimize hangs and stops responding](https://togithub.com/dotnet/efcore/issues/27301) ### [`v6.0.2`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.2): EF Core 6.0.2 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.2) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.2+is%3Aclosed): - [Exception when creating new migration after updating from 6.0-rc.1 to 6.0-rc.2 or 6.0-rtm](https://togithub.com/dotnet/efcore/issues/26405) - [efcore6 produces wrong SELECT SQL when Where/OrderBy clauses are applied to Owned properties followed by .Take](https://togithub.com/dotnet/efcore/issues/26592) - [Proxies using Records with a base class broken since .NET 6](https://togithub.com/dotnet/efcore/issues/26602) - [Parentheses put around IS NULL only if operand is of type boolean](https://togithub.com/dotnet/efcore/issues/26652) - [Self-referencing entity circular dependency happening just on EF Core 6.0](https://togithub.com/dotnet/efcore/issues/26750) - [Many To Many Exception when adding and removing same entity](https://togithub.com/dotnet/efcore/issues/26779) - [RelationalConnection.Close calls async function](https://togithub.com/dotnet/efcore/issues/26790) - [Circular dependency while creating tables with DatabaseFacade.EnsureCreated on EF Core 6](https://togithub.com/dotnet/efcore/issues/26834) - [EF Core Migration Bundles: no way to passthrough custom args to generated efbundle](https://togithub.com/dotnet/efcore/issues/26945) - [Did the naming convention change for HasCheckConstraint in v.6? Is this a breaking change?](https://togithub.com/dotnet/efcore/issues/27059) - [Generated JOIN for multiple MIN is wrong](https://togithub.com/dotnet/efcore/issues/27083) - [StackOverflowException in nested GroupBy query](https://togithub.com/dotnet/efcore/issues/27094) - [When trimming, queries fail because of missing System.Math](https://togithub.com/dotnet/efcore/issues/27097) - [GroupBy with outer reference not translating properly, causing data loss](https://togithub.com/dotnet/efcore/issues/27102) - [EF 6.0.0 and 6.0.1: sub-lists are no longer loaded](https://togithub.com/dotnet/efcore/issues/27105) ### [`v6.0.1`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.1): EF Core 6.0.1 This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.1) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.1+is%3Aclosed): - [DateTime with z suffix is not respected when reading entities](https://togithub.com/dotnet/efcore/issues/26690) - ['The object has been removed from the model.' when building model](https://togithub.com/dotnet/efcore/issues/26659) - [EF Core 6.0 regression when using HasDefaultSchema() with ToTable(null)](https://togithub.com/dotnet/efcore/issues/26651) - [Variable names must be unique within a query batch or stored procedure](https://togithub.com/dotnet/efcore/issues/26632) - [Stack overflow when using circular composite key dependencies](https://togithub.com/dotnet/efcore/issues/26629) - [SqliteConnectionFactory.cs is not thread-safe](https://togithub.com/dotnet/efcore/issues/26612) - [EF Core 6.0 InvalidOperationException: The object has been removed from the model](https://togithub.com/dotnet/efcore/issues/26611) - [Subquery.Contains throws when the type of item is value type](https://togithub.com/dotnet/efcore/issues/26593) - [Query with n:m relation adds non-existent column](https://togithub.com/dotnet/efcore/issues/26590) - [InvalidOperationException "sequence contains no matching element" in TableReferenceExpression.get_Table](https://togithub.com/dotnet/efcore/issues/26587) - [Update from 5.0.1 to 6.0breaks all SqliteConnection](https://togithub.com/dotnet/efcore/issues/26574) - [Scaffolder throws error if junction table foreign key columns have identical names](https://togithub.com/dotnet/efcore/issues/26496) - [EFCore 6 - NullReferenceException upon EnsureDeleted](https://togithub.com/dotnet/efcore/issues/26436) - [Non-nullable value comparer can't be applied on nullable type](https://togithub.com/dotnet/efcore/issues/26429) - [Exception in SQL server query in EF Core 6, looks related to HasQueryFilter(), worked in EF Core 5](https://togithub.com/dotnet/efcore/issues/26428) - [RC2 Sqlite provider no longer clears temporary files on exit](https://togithub.com/dotnet/efcore/issues/26422) - [The dotnet ef dbcontext scaffold command does not print all expected logs](https://togithub.com/dotnet/efcore/issues/26384) ### [`v6.0.0`](https://togithub.com/dotnet/efcore/releases/tag/v6.0.0): EF Core 6.0 EF Core 6.0 GA is now available from [NuGet](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.0). See [What's New in EF Core 6.0](https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-6.0/whatsnew) for a detailed look at all the new features in EF Core 6.0. In summary, the following new features are included in EF Core 6.0: - [Allow defining column order via \[ColumnAttribute.Order\] when creating tables](https://togithub.com/dotnet/efcore/issues/10059) - [SQL Server temporal tables](https://togithub.com/dotnet/efcore/issues/4693) - [Migrations Bundles](https://togithub.com/dotnet/efcore/issues/19693) - [Cosmos: Add basic support for collections and dictionaries of primitive types](https://togithub.com/dotnet/efcore/issues/14762) - [Cosmos: Add translators for member/methods which map to built-in functions](https://togithub.com/dotnet/efcore/issues/16143) - [Cosmos: Distinct operator in queries](https://togithub.com/dotnet/efcore/issues/16144) - [Cosmos: Diagnostic events including statistics (query cost, activity id)](https://togithub.com/dotnet/efcore/issues/17298) - [Cosmos: API to configure throughput](https://togithub.com/dotnet/efcore/issues/17301) - [Cosmos: Configure TTL per entity/entity type/container](https://togithub.com/dotnet/efcore/issues/17307) - [Cosmos: FromSql support](https://togithub.com/dotnet/efcore/issues/17311) - [Cosmos: Resolve HttpClientFactory from DI if available](https://togithub.com/dotnet/efcore/issues/21274) - [Cosmos: Azure Cosmos DB provider should default to implicit ownership](https://togithub.com/dotnet/efcore/issues/24803) - [Detect simple join tables in reverse engineering and create many-to-many relationships](https://togithub.com/dotnet/efcore/issues/22475) - [Translate GroupBy followed by FirstOrDefault over group](https://togithub.com/dotnet/efcore/issues/12088) - [Support ability to select top N of each group](https://togithub.com/dotnet/efcore/issues/13805) - [Remove unnecessary *last column* in ORDER BY when joining for collection](https://togithub.com/dotnet/efcore/issues/19828) - [Add IColumnModification and IModificationCommand to allow the implementations to be replaced easily](https://togithub.com/dotnet/efcore/issues/12169) - [Non-constant property name in EF.Property (and indexer property)](https://togithub.com/dotnet/efcore/issues/15832) - [Make the non-thread-safety of DbContext more visible](https://togithub.com/dotnet/efcore/issues/23319) - [Store options in ServiceProviderCache](https://togithub.com/dotnet/efcore/issues/19152) - [Adopt MIT license](https://togithub.com/dotnet/efcore/issues/19844) - [Warn when uniquifying an FK column name](https://togithub.com/dotnet/efcore/issues/20435) - [Preserve DeleteBehavior when scaffolding a database created by EF Core](https://togithub.com/dotnet/efcore/issues/21252) - [Add overloads of UsingEntity() that take advantage of conventions](https://togithub.com/dotnet/efcore/issues/21535) - [Log provider version in addition to EF Core version](https://togithub.com/dotnet/efcore/issues/22906) - [Indicate where SQL comes from (SaveChanges, LINQ query, etc.) in IDbCommandInterceptor](https://togithub.com/dotnet/efcore/issues/23719) - [Register a scoped DbContext automatically when using AddDbContextFactory](https://togithub.com/dotnet/efcore/issues/25164) - [Add extension methods to enable simpler adding and configuration of EF Core providers](https://togithub.com/dotnet/efcore/issues/25192) - [Simplify HasConversion API](https://togithub.com/dotnet/efcore/issues/25468) - [Support Timeout.InfiniteTimeSpan in SetCommandTimeout](https://togithub.com/dotnet/efcore/issues/25068) - [Support suspending/bypassing the configured DbContext's IExecutionStrategy](https://togithub.com/dotnet/efcore/issues/24922) - [Support 64-bit Identity seed values](https://togithub.com/dotnet/efcore/issues/24840) - [Warn when saving an optional dependent with all null properties when table splitting](https://togithub.com/dotnet/efcore/issues/24558) - [Remove existing schema when HasSchema(null) is called](https://togithub.com/dotnet/efcore/issues/24228) - [Add equivalent of IRelationalDbContextOptionsBuilderInfrastructure to in-memory provider](https://togithub.com/dotnet/efcore/issues/23669) - [Make HasDbFunction on function override implicit ToTable mapping](https://togithub.com/dotnet/efcore/issues/23408) - [Make IScaffoldingModelFactory public](https://togithub.com/dotnet/efcore/issues/23049) - [Uniquify and validate Check Constraint name](https://togithub.com/dotnet/efcore/issues/18958) - [Translate MathF members to SQL functions on SQLite](https://togithub.com/dotnet/efcore/issues/18842) - [Pre-convention model configuration](https://togithub.com/dotnet/efcore/issues/12229) - [Mechanism/API to specify a default conversion for any property of a given type in the model](https://togithub.com/dotnet/efcore/issues/10784) - [Support Ignore() for non entity type candidates](https://togithub.com/dotnet/efcore/issues/3867) - [Reduce EF Core application startup time via compiled models](https://togithub.com/dotnet/efcore/issues/1906) - [Add TagWith overload that gets the filename and line number automatically](https://togithub.com/dotnet/efcore/issues/14176) - [Translate bool ToString for SQL Server](https://togithub.com/dotnet/efcore/issues/14205) - [Scaffold from a database and generate C# 8 nullable reference types](https://togithub.com/dotnet/efcore/issues/15520) - [Translate Substring with single parameter](https://togithub.com/dotnet/efcore/issues/20173) - [Support split queries for projections containing non-navigation collections](https://togithub.com/dotnet/efcore/issues/21234) - [Improve EF Core performance on TechEmpower Fortunes](https://togithub.com/dotnet/efcore/issues/23611) - [Support empty constructor and DbContextOptions constructor in DbContextFactory](https://togithub.com/dotnet/efcore/issues/24124) - [Make DbContext pooling accessible to non-DI applications](https://togithub.com/dotnet/efcore/issues/24137) - [Increase the default maximum context pool size to 1024](https://togithub.com/dotnet/efcore/issues/24849) - [Improvements to optional dependents sharing table with principal](https://togithub.com/dotnet/efcore/issues/23564) - [Detection of trailing underscores when matching backing fields to properties](https://togithub.com/dotnet/efcore/issues/23901) - [Performance gain by recycling relational and ADO.NET objects in query execution](https://togithub.com/dotnet/efcore/issues/24206) - [Allow explicit temporary values to be stored in entity instances](https://togithub.com/dotnet/efcore/issues/24245) - [Default options added to all ToDebugString methods](https://togithub.com/dotnet/efcore/issues/24461) - [Improved logging of array parameter values](https://togithub.com/dotnet/efcore/issues/24595) - [Preserve synchronization context in SaveChangesAsync](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#preserve-synchronization-context-in-savechangesasync) - [Translate String.Concat with multiple arguments](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#translate-stringconcat-with-multiple-arguments) - [Smoother integration with System.Linq.Async](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#smoother-integration-with-systemlinqasync) - [More flexible free-text search](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#more-flexible-free-text-search) - [UnicodeAttribute](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#unicodeattribute) - [PrecisionAttribute](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#precisionattribute) - [EntityTypeConfigurationAttribute](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#entitytypeconfigurationattribute) - [Translate ToString on SQLite](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#translate-tostring-on-sqlite) - [EF.Functions.Random](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#effunctionsrandom) - [Support for SQL Server sparse columns](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#support-for-sql-server-sparse-columns) - [In-memory database: validate required properties are not null](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#in-memory-database-validate-required-properties-are-not-null) - [Improved SQL Server translation for IsNullOrWhitespace](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#improved-sql-server-translation-for-isnullorwhitespace) - [Database comments are scaffolded to code comments](https://docs.microsoft.com/ef/core/what-is-new/ef-core-6.0/whatsnew#database-comments-are-scaffolded-to-code-comments) And for Microsoft.Data.Sqlite: - [Support the new BCL DateOnly and TimeOnly structs for SQLite](https://togithub.com/dotnet/efcore/issues/24506) - [Fall back to case-insensitive matches for `SqliteDataReader[]`](https://togithub.com/dotnet/efcore/issues/24011) - [Add Span overloads to SqliteBlob](https://togithub.com/dotnet/efcore/issues/16187) - [Pool Connections](https://togithub.com/dotnet/efcore/issues/13837) See GitHub for [all issues fixed in EF Core 6.0](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.0+is%3Aclosed+) and the [Git release tag](https://togithub.com/dotnet/core/releases/tag/v6.0.0). ### [`v5.0.17`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.17): EF Core 5.0.17 This is a [patch release of EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.17) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.16. ### [`v5.0.16`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.16): EF Core 5.0.16 This is a [patch release of EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.16) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.15. ### [`v5.0.15`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.15): EF Core 5.0.15 This is a [patch release of EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.15) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.14. ### [`v5.0.14`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.14): EF Core 5.0.14 This is a [patch release of EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.14) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.13. ### [`v5.0.13`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.13): EF Core 5.0.13 This is a [patch release of EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.13) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 5.0.12. ### [`v5.0.12`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.12): EF Core 5.0.12 This is a [patch release of EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.12) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A5.0.12+is%3Aclosed): - [ObjectDisposedException on retrieval of a pooled DbContext](https://togithub.com/dotnet/efcore/issues/26202) ### [`v5.0.11`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.11): EF Core 5.0.11 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.10. ### [`v5.0.10`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.10): EF Core 5.0.10 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.9. ### [`v5.0.9`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.9): EF Core 5.0.9 This is a patch release of [EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.9) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A5.0.9+is%3Aclosed). - [Port fix for "Code generation for custom data annotation attributes is broken"](https://togithub.com/dotnet/efcore/issues/25156) - [HasDbFunction to an otherwise unmapped entity causes strange migration behavior](https://togithub.com/dotnet/efcore/issues/25133) ### [`v5.0.8`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.8): EF Core 5.0.8 This is a patch release of [EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.8) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A5.0.8+is%3Aclosed). - [Using Concat for model/seed data in migrations may truncate long strings](https://togithub.com/dotnet/efcore/issues/24112) ### [`v5.0.7`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.7): EF Core 5.0.7 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.6. ### [`v5.0.6`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.6): EF Core 5.0.6 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.5. ### [`v5.0.5`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.5): EF Core 5.0.5 This is a patch release of [EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.5) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A5.0.5+is%3Aclosed). - [Default value constraint re-added when using .HasComment()](https://togithub.com/dotnet/efcore/issues/24272) - [EfCore 5 Update method throws "Unable to cast object of type 'System.Int32' to type 'System.Int64'."](https://togithub.com/dotnet/efcore/issues/24221) - [SaveChanges fails for owned entity when owner has PK with default values](https://togithub.com/dotnet/efcore/issues/23730) - [\[Regression\] ThenInclude back to parent entity isn't working](https://togithub.com/dotnet/efcore/issues/23674) ### [`v5.0.3`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.3): EF Core 5.0.3 This is a patch release of [EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.3) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A5.0.3+is%3Aclosed). ##### Query - [InMemory: Decompose join condition which uses equals for comparison](https://togithub.com/dotnet/efcore/issues/23593) - [IQueryable.All evaluates to false with predicate \_ => true](https://togithub.com/dotnet/efcore/issues/23617) - [Loading entity from DB does not properly load owned entities (In memory provider)](https://togithub.com/dotnet/efcore/issues/23687) - [AsSingleQuery can not be translated by in-memory provider](https://togithub.com/dotnet/efcore/issues/23759) - [TryRewriteEntityEquality and NotEqual comparison of CompositePrimaryKey](https://togithub.com/dotnet/efcore/issues/23779) ##### Migrations - [Builder method mismatch across providers in model snapshot](https://togithub.com/dotnet/efcore/issues/23456) - [MigrationBuilder.InsertData not considering column types passed in](https://togithub.com/dotnet/efcore/issues/23503) - [EF Core generates the same migration even though nothing has changed in the model](https://togithub.com/dotnet/efcore/issues/23792) - [Mangled migration generated when altering database collation](https://togithub.com/dotnet/efcore/issues/23794) ##### Change tracking - [Adding a join entity instance doesn't populate collections on the participating entities](https://togithub.com/dotnet/efcore/issues/23659) - [Can not build relationships when attach disconnected entities which have many-to-many related entities](https://togithub.com/dotnet/efcore/issues/23787) ##### Diagnostics - [Issues with event counters](https://togithub.com/dotnet/efcore/issues/23630) ##### SaveChanges - [Insertion order is wrong when owned entity is involved](https://togithub.com/dotnet/efcore/issues/23668) ##### Model building - [GetDefaultDatabaseName throws ArgumentNullException for table splitting](https://togithub.com/dotnet/efcore/issues/23672) ### [`v5.0.2`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.2): EF Core 5.0.2 This is a patch release of [EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.2) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A5.0.2+is%3Aclosed). ##### Change tracking - [Many-to-many lazy (and explicit) loading erroneously sets inverse collection as loaded](https://togithub.com/dotnet/efcore/issues/23475) ##### Migrations - [Model (seed) data with newlines may result in SQL exceptions](https://togithub.com/dotnet/efcore/issues/23459) - [Migration concatenates strings that are escaped](https://togithub.com/dotnet/efcore/issues/23518) - [SQLite Migrations: Missing table name quotes during rebuild](https://togithub.com/dotnet/efcore/issues/23621) - [Foreign keys for tables marked as ExcludeFromMigrations regenerated in every migrations](https://togithub.com/dotnet/efcore/issues/23639) ##### Model building - [TPH where derived entities each have Required Owned Entities with Required / Non-Nullable Properties throws SqlException](https://togithub.com/dotnet/efcore/issues/23479) - [Error using case-mismatched mapped properties in many to many relationship](https://togithub.com/dotnet/efcore/issues/23516) - [EntityTypeBuilder: .IsRequired() is ignored if used after .OnDelete()](https://togithub.com/dotnet/efcore/issues/23555) ##### Query - [Overlapping property in many-to-many join table causes an error](https://togithub.com/dotnet/efcore/issues/23476) ##### SaveChanges - [EfCore 5 update breaks behavior of RowVersion with Conversions for InMemory database](https://togithub.com/dotnet/efcore/issues/23527) ### [`v5.0.1`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.1): EF Core 5.0.1 This is a patch release of [EF Core 5.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.1) containing only [important bug fixes](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A5.0.1+is%3Aclosed). ##### EF Core 5.0.1 - Query - [Properly generate expression to read provider-specific types from BufferedDataReader](https://togithub.com/dotnet/efcore/issues/23104) - [Owned collection when owner has composite PK throws translation failure](https://togithub.com/dotnet/efcore/issues/23130) - [ArgumentOutOfRangeException for split query with owned types](https://togithub.com/dotnet/efcore/pull/23273) - [Incorrect SQL generated when applying group by over a group by](https://togithub.com/dotnet/efcore/issues/23265) - [KeyNotFoundException when adding a single projection](https://togithub.com/dotnet/efcore/issues/23266) - [Incorrect result when doing owner + Include collection + split query + owned type mapped to different table + single](https://togithub.com/dotnet/efcore/issues/23276) - [InvalidCastException on entities referencing Owned types containing NetTopologySuite Point properties](https://togithub.com/dotnet/efcore/issues/23282) - [Exception when using inheritance with owned properties in the in-memory database](https://togithub.com/dotnet/efcore/issues/23285) - [Ternary operator with DateTimes in select gives ArgumentException](https://togithub.com/dotnet/efcore/issues/23309) - [Object reference not set to an instance of an object exception when using NET Topology Suite in Select projection](https://togithub.com/dotnet/efcore/issues/23336) - [Provider specific plugin method translator never gets called for indexer property](https://togithub.com/dotnet/efcore/issues/23410) - Model building - [Mapping exception with property called FooId on base type Foo in TPT](https://togithub.com/dotnet/efcore/issues/23092) - [Foreign keys are removed from owned tables when excludedFromMigrations set to true](https://togithub.com/dotnet/efcore/issues/23137) - [Exception in TPT models with default values](https://togithub.com/dotnet/efcore/issues/23180) - [Default schema has no effect on views in EF Core 5.0](https://togithub.com/dotnet/efcore/issues/23274) - [The entity type is part of a relationship cycle involving its primary key](https://togithub.com/dotnet/efcore/issues/23289) - [StackOverflowException when using same collection navigation twice](https://togithub.com/dotnet/efcore/issues/23354) - [StackOverflowException with EFCore 5 many-to-many mapping using many-to-one via self](https://togithub.com/dotnet/efcore/issues/23377) - DbContext - [Events aren't reset when pooled context is reset asynchronously](https://togithub.com/dotnet/efcore/issues/23108) - Scaffolding - [The string argument 'name' cannot be empty when scaffolding a SQLite database](https://togithub.com/dotnet/efcore/issues/23268) - [System.ArgumentException: The collection argument 'propertyNames' must contain at least one element](https://togithub.com/dotnet/efcore/issues/23378) - [Collations aren't scaffolded correctly](https://togithub.com/dotnet/efcore/issues/23386) - SaveChanges - [SaveChanges fails for SQL Server because of savepoints are not supported when MultipleActiveResultSets is enabled](https://togithub.com/dotnet/efcore/issues/23269) - Migrations - [SQL generated for migrations is incorrect when DbContext has TVF mapped using DbFunctionAttribute](https://togithub.com/dotnet/efcore/issues/23312) - [SQLite Spatial Migrations: Columns with Z and M created incorrectly](https://togithub.com/dotnet/efcore/issues/23390) ##### Microsoft.Data.Sqlite 5.0.1 - [Starting with Microsoft.Data.Sqlite.Core 5.0.0 it is no longer possible to set cipher key options](https://togithub.com/dotnet/efcore/issues/23250) ### [`v5.0.0`](https://togithub.com/dotnet/efcore/releases/tag/v5.0.0): EF Core 5.0.0 EF Core 5.0 is [available on NuGet now!](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/5.0.0) - Issues [fixed for EF Core 5.0.0](https://togithub.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A5.0.0+is%3Aclosed) Among the new features for EF Core 5.0 are: - [Many-to-many relationships](https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-5.0/whatsnew#many-to-many) - [Map entity types to queries](https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-5.0/whatsnew#map-entity-types-to-queries) - [Event counters](https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-5.0/whatsnew#event-counters) - [Property bags](https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-5.0/whatsnew#property-bags) - [SaveChanges interception and events](https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-5.0/whatsnew#savechanges-interception-and-events) - [Exclude tables from migrations](https://docs.microsoft.com/en-us/ef/core/what-is-new/ef-core-5.0/whatsnew#exclude-tables-from-migrations) - [Required 1:1 dependents](https://docs.microsoft.com/