dotnet/efcore (Microsoft.EntityFrameworkCore.SqlServer)
### [`v8.0.10`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.10): .NET 8.0.10
[Release](https://redirect.github.com/dotnet/core/releases/tag/v8.0.10)
### [`v8.0.8`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.8): .NET 8.0.8
[Release](https://redirect.github.com/dotnet/core/releases/tag/v8.0.8)
### [`v8.0.7`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.7): EF Core 8.0.7
EF Core 8.0.7 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.7). This is a patch release of EF Core 8 (EF8) containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.7+is%3Aclosed):
- \[Missing checks for predicate when simplifying JSON primitive collections]\(https://github.com/dotnet/efcore/issues/ [#33932](https://redirect.github.com/dotnet/efcore/issues/33932)
- \[Discriminator columns are created in Snapshot for wrongly configured TPC mapping strategy]\(https://github.com/dotnet/efcore/issues/ 33605)
- [Breaking Change in 8.0.4: System.InvalidOperationException: The data is NULL at ordinal 0. This method can't be called on NULL values. Check using IsDBNull before calling.](https://redirect.github.com/dotnet/efcore/issues/33547)
- [Wrong mapping of nested complex property with generic types and same property name, resulting in InvalidCastException](https://redirect.github.com/dotnet/efcore/issues/33449)
### [`v8.0.6`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.6): EF Core 8.0.6
This is a [patch release of EF Core 8.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.6) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 8.0.5.
### [`v8.0.5`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.5): EF Core 8.0.5
This is a [patch release of EF Core 8.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.5) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 8.0.4.
### [`v8.0.4`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.4): EF Core 8.0.4
EF Core 8.0.4 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.4). This is a patch release of EF Core 8 (EF8) containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.4+is%3Aclosed):
- [Incorrect apply projection for complex properties](https://redirect.github.com/dotnet/efcore/issues/32911)
- [The database default created by Migrations for primitive collections mapped to JSON is invalid](https://redirect.github.com/dotnet/efcore/issues/32972)
- [Filtering by Contains with HierarchyId and AsSplitQuery is not working](https://redirect.github.com/dotnet/efcore/issues/32976)
- [Unfulfillable nullable contraints are set for complex types with TPH entities](https://redirect.github.com/dotnet/efcore/issues/33004)
- [OutOfMemoryException when creating migration using ef tool](https://redirect.github.com/dotnet/efcore/issues/33176)
- [SQL Server: Should retry on 203](https://redirect.github.com/dotnet/efcore/issues/33260)
### [`v8.0.3`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.3): EF Core 8.0.3
EF Core 8.0.3 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.3). This is a patch release of EF Core 8 (EF8) containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.3+is%3Aclosed):
- [Constructor calls when using inheritance with owned entities causes exceptions](https://redirect.github.com/dotnet/efcore/issues/31353)
- [Missing package README file](https://redirect.github.com/dotnet/efcore/issues/31947)
- [String properties with indexes are compared case insensitively on SQL Server](https://redirect.github.com/dotnet/efcore/issues/32898)
- [Using SqliteConnection from an ASP.NET MVC (.NET Framework) application results in a few different exceptions](https://redirect.github.com/dotnet/efcore/issues/32614)
- [Exception when using FromSql on entity with ComplexProperty](https://redirect.github.com/dotnet/efcore/issues/32699)
- [IndexOutOfRange for EntityEntry.GetDatabaseValues() with complex type and TPH](https://redirect.github.com/dotnet/efcore/issues/32701)
- [SQL Server Migrations - SqlOperation.Sql is stripped of all empty lines](https://redirect.github.com/dotnet/efcore/issues/32730)
- [NullReferenceException in Get-Migration in EF Core 8](https://redirect.github.com/dotnet/efcore/issues/32732)
- [Owned entity on genericly typed entity generates unwanted steps in new migrations](https://redirect.github.com/dotnet/efcore/issues/32763)
- [Dotnet-ef mismatch causes apply Entity Framework migration fails when publishing an individual web app.](https://redirect.github.com/dotnet/efcore/issues/32782)
- [Query never returns when DB value for column mapped to primitive collection is](https://redirect.github.com/dotnet/efcore/issues/32896)
### [`v8.0.2`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.2): EF Core 8.0.2
EF Core 8.0.2 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.2). This is a patch release of EF Core 8 (EF8) containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.2+is%3Aclosed):
- [Adding EF.Constant to prevent parameterization in query](https://redirect.github.com/dotnet/efcore/issues/32680)
- [Nav expansion visitor does not visit the Contains item argument](https://redirect.github.com/dotnet/efcore/issues/32217)
- [SqliteException "no such column : rX.value" when ordering on subquery value in combination with a "where contains" when upgrading from 7 to 8.0.0-rc.2.23480.1](https://redirect.github.com/dotnet/efcore/issues/32234)
- [DB Context pooling with proxies resulting in memory issues in 8.0 RC2](https://redirect.github.com/dotnet/efcore/issues/32267)
- [Nav expansion visitor does not visit the non-lambda arguments (Skip, Take, ElementAt)](https://redirect.github.com/dotnet/efcore/issues/32312)
- [LINQ "Contains" generates SQL with wrong char length](https://redirect.github.com/dotnet/efcore/issues/32325)
- [Using new\[\] in select query gives exception .NET 8](https://redirect.github.com/dotnet/efcore/issues/32331)
- [EF Core Cosmos 7.0.13 => 7.0.14 Value cannot be null. (Parameter 'derivedType')](https://redirect.github.com/dotnet/efcore/issues/32363)
- [New OpenJSON expression to SQL translation breaks aggregates on subquery with 'Cannot perform an aggregate function on an expression containing an aggregate or a subquery' exception](https://redirect.github.com/dotnet/efcore/issues/32374)
- [Did Contains stop working on empty list in EF Core 8?](https://redirect.github.com/dotnet/efcore/issues/32375)
- [LINQ "Contains" fails to generate SQL with custom converter](https://redirect.github.com/dotnet/efcore/issues/32376)
- [error on working with explicit many-to-many relations with OnDelete.Restrict](https://redirect.github.com/dotnet/efcore/issues/32383)
- [Lazy loader throwing invalid operation exceptions](https://redirect.github.com/dotnet/efcore/issues/32390)
- [Cosmos provider v7.0.14 and v8.0.0 breaks previous OwnsMany behaviour](https://redirect.github.com/dotnet/efcore/issues/32410)
- [Constructor not found for type 'Microsoft.EntityFrameworkCore.ChangeTracking.Internal.NullableClassCurrentProviderValueComparer](https://redirect.github.com/dotnet/efcore/issues/32411)
- [Inconsistent behavior related to relationship cycle](https://redirect.github.com/dotnet/efcore/issues/32422)
- [Property conversions are lost on base type is subtype is registered to model afterwards after upgrade to EFCore 8](https://redirect.github.com/dotnet/efcore/issues/32430)
- [Incorrect parameter rewriting for string StartsWith/EndsWith/Contains](https://redirect.github.com/dotnet/efcore/issues/32432)
- [Migrations bug when creating stored procedure with GOTO statement](https://redirect.github.com/dotnet/efcore/issues/32457)
- [Unable to Scaffold DBContext if tables in SQL Server have certain names](https://redirect.github.com/dotnet/efcore/issues/32571)
- [Contains translates to correlated query when the item is nullable](https://redirect.github.com/dotnet/efcore/issues/32574)
- [FluentAPI configuration PrimitiveCollection on OwnedNavigationBuilder returns PropertyBuilder instead of PrimitiveCollectionBuilder](https://redirect.github.com/dotnet/efcore/issues/32601)
- [String comparison fails when using const and compiled Models.](https://redirect.github.com/dotnet/efcore/issues/32617)
- [Exception when writing a JSON column with negative enum value](https://redirect.github.com/dotnet/efcore/issues/32679)
- [Getting errors when mixing DbFunction and SqlQueryRaw](https://redirect.github.com/dotnet/efcore/issues/32680)
### [`v8.0.1`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.1): EF Core 8.0.1
EF Core 8.0.1 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.1). This is a patch release of EF Core 8 (EF8) containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.1+is%3Aclosed):
- [EFC8: Lazy Loading regression on newly created objects](https://redirect.github.com/dotnet/efcore/issues/32314)
- [EfCore 8: Primitive collections in JSON documents error with init](https://redirect.github.com/dotnet/efcore/issues/32310)
- [Buffering error in JSON deserialization with junk data](https://redirect.github.com/dotnet/efcore/issues/32235)
- [Contains fallback translation fails when the array parameter has AsQueryable](https://redirect.github.com/dotnet/efcore/issues/32218)
- [QueryableMethodNormalizingExpressionVisitor does not visit recursively when converting List.Contains to Queryable.Contains](https://redirect.github.com/dotnet/efcore/issues/32215)
- [SqlNullabilityProcessor ignores Contains item visitation](https://redirect.github.com/dotnet/efcore/issues/32208)
- [SensitiveDataLogging with ComplexProperty: Unable to cast RuntimeComplexType to type IEntityType](https://redirect.github.com/dotnet/efcore/issues/32198)
- [JSON materialization code should be resilient to incorrect JSON documents](https://redirect.github.com/dotnet/efcore/issues/32194)
### [`v8.0.0`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.0): EF Core 8 (EF8)
EF Core 8 (EF8) is [available from NuGet](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.0)
EF8 contains many new features and enhancements, including:
- [Allow Multi-region or Application Preferred Regions in EF Core Cosmos](https://redirect.github.com/dotnet/efcore/issues/29424)
- [Use C# structs or classes as value objects](https://redirect.github.com/dotnet/efcore/issues/9906)
- [Support primitive collections in the compiled model](https://redirect.github.com/dotnet/efcore/issues/31489)
- [Migrations and model snapshot for primitive collections](https://redirect.github.com/dotnet/efcore/issues/31414)
- [Query: add support for projecting JSON entities that have been composed on](https://redirect.github.com/dotnet/efcore/issues/31365)
- [SQLite: Add EF.Functions.Unhex](https://redirect.github.com/dotnet/efcore/issues/31355)
- [Add type mapping APIs to customize JSON value serialization/deserialization](https://redirect.github.com/dotnet/efcore/issues/30677)
- [SQL Server Index options SortInTempDB and DataCompression](https://redirect.github.com/dotnet/efcore/issues/30408)
- [Analyzer: warn (and code fix) for use of interpolation in SQL methods accepting raw strings](https://redirect.github.com/dotnet/efcore/issues/30965)
- [Translate Contains to IN with subquery instead of EXISTS where relevant](https://redirect.github.com/dotnet/efcore/issues/30955)
- [Allow inline primitive collections with parameters, translating to VALUES](https://redirect.github.com/dotnet/efcore/issues/30732)
- [Translate DateOnly.FromDateTime](https://redirect.github.com/dotnet/efcore/issues/30708)
- [Implement JSON serialization/deserialization via Utf8JsonReader/Utf8JsonWriter](https://redirect.github.com/dotnet/efcore/issues/30604)
- [Update pattern for scaffolding column default constraints](https://redirect.github.com/dotnet/efcore/issues/13613)
- [Use IN instead of EXISTS with ExecuteDelete and entity containment](https://redirect.github.com/dotnet/efcore/issues/31386)
- [Allow ExecuteUpdate to update properties of multiple queries as long as the map to a single table](https://redirect.github.com/dotnet/efcore/issues/31406)
- [Query: add support for projecting primitive collections from JSON entities](https://redirect.github.com/dotnet/efcore/issues/31364)
- [Switch to storing enums as ints in JSON instead of strings](https://redirect.github.com/dotnet/efcore/issues/31100)
- [Translate DegreesToRadians](https://redirect.github.com/dotnet/efcore/issues/30926)
- [Metadata and type mapping support for primitive collections](https://redirect.github.com/dotnet/efcore/issues/30730)
- [JSON type representations and conversions to store types](https://redirect.github.com/dotnet/efcore/issues/30727)
- [Allow stripping away all model building code to reduce application size](https://redirect.github.com/dotnet/efcore/issues/29755)
- [Json: add support for collection of primitive types inside JSON columns](https://redirect.github.com/dotnet/efcore/issues/28688)
- [Support LINQ querying of non-primitive collections within JSON](https://redirect.github.com/dotnet/efcore/issues/28616)
- [SQLite RevEng: Sample data to determine CLR type](https://redirect.github.com/dotnet/efcore/issues/8824)
- [Allow default value check in value generation to be customized](https://redirect.github.com/dotnet/efcore/issues/701)
- [Update handling of non-nullable store-generated properties](https://redirect.github.com/dotnet/efcore/issues/15070)
- [IN() list queries are not parameterized, causing increased SQL Server CPU usage](https://redirect.github.com/dotnet/efcore/issues/13617)
- [Allow 'unsharing' connection between contexts](https://redirect.github.com/dotnet/efcore/issues/30704)
- [Remove unneeded subquery and projection when using ordering without limit/offset in set operations](https://redirect.github.com/dotnet/efcore/issues/30684)
- [Make SequentialGuidValueGenerator non-allocating](https://redirect.github.com/dotnet/efcore/issues/30610)
- [Support querying over primitive collections](https://redirect.github.com/dotnet/efcore/issues/30426)
- [JSON/Sqlite: use -> and ->> where possible when traversing JSON, rather than json_extract](https://redirect.github.com/dotnet/efcore/issues/30334)
- [Add Generic version of EntityTypeConfiguration Attribute](https://redirect.github.com/dotnet/efcore/issues/30072)
- [NativeAOT/trimming compatibility for Microsoft.Data.Sqlite](https://redirect.github.com/dotnet/efcore/issues/29725)
- [Map collections of primitive types to JSON column in relational database](https://redirect.github.com/dotnet/efcore/issues/29427)
- [Translate DateTimeOffset.ToUnixTime(Seconds|Milliseconds)](https://redirect.github.com/dotnet/efcore/issues/28925)
- [Allow pooling DbContext with singleton services](https://redirect.github.com/dotnet/efcore/issues/27752)
- [Optional RestartSequenceOperation.StartValue](https://redirect.github.com/dotnet/efcore/issues/26560)
- [Generate compiled relational model](https://redirect.github.com/dotnet/efcore/issues/24896)
- [Global query filters produce too many parameters](https://redirect.github.com/dotnet/efcore/issues/24476)
- [Optimize update path for single property JSON element](https://redirect.github.com/dotnet/efcore/issues/30410)
- [JSON columns can be used in compiled models](https://redirect.github.com/dotnet/efcore/issues/29602)
- [Unneeded parentheses removed in SQL queries ](https://redirect.github.com/dotnet/efcore/issues/26767)
- [Set operations are supported over non-entity projections with different facets](https://redirect.github.com/dotnet/efcore/issues/19129)
- [Json: add support for Sqlite provider](https://redirect.github.com/dotnet/efcore/issues/28816)
- [SQL Server: Support hierarchyid](https://redirect.github.com/dotnet/efcore/issues/365)
- [Configuration to opt out of occasionally problematic SaveChanges optimizations](https://redirect.github.com/dotnet/efcore/issues/29916)
- [Add convention types for triggers](https://redirect.github.com/dotnet/efcore/issues/28687)
- [Translate element access of a JSON array](https://redirect.github.com/dotnet/efcore/issues/28648)
- [Raw SQL queries for unmapped types](https://learn.microsoft.com/ef/core/what-is-new/ef-core-8.0/plan#sql-queries-for-unmapped-types)
- [Support the new BCL DateOnly and TimeOnly structs for SQL Server](https://redirect.github.com/dotnet/efcore/issues/24507)
- [Translate ElementAt(OrDefault)](https://redirect.github.com/dotnet/efcore/issues/17066)
- [Opt-out of lazy-loading for specific navigations](https://redirect.github.com/dotnet/efcore/issues/10787)
- [Lazy-loading for no-tracking queries](https://redirect.github.com/dotnet/efcore/issues/10042)
- [Reverse engineer Synapse and Dynamics 365 TDS](https://redirect.github.com/dotnet/efcore/issues/29121)
- [Set MaxLength on TPH discriminator property by convention](https://redirect.github.com/dotnet/efcore/issues/10691)
- [Translate ToString() on a string column](https://redirect.github.com/dotnet/efcore/issues/20839)
- [Generic overload of ConventionSetBuilder.Remove](https://redirect.github.com/dotnet/efcore/issues/29476)
- [Lookup tracked entities by primary key, alternate key, or foreign key](https://redirect.github.com/dotnet/efcore/issues/29685)
- [Allow UseSequence and HiLo on non-key properties](https://redirect.github.com/dotnet/efcore/issues/29758)
- [Pass query tracking behavior to materialization interceptor](https://redirect.github.com/dotnet/efcore/issues/29910)
- [Use case-insensitive string key comparisons on SQL Server](https://redirect.github.com/dotnet/efcore/issues/27526)
- [Allow value converters to change the DbType](https://redirect.github.com/dotnet/efcore/issues/24771)
- [Resolve application services in EF services](https://redirect.github.com/dotnet/efcore/issues/13540)
- [Numeric rowersion properties automatically convert to binary](https://redirect.github.com/dotnet/efcore/issues/12434)
- [Allow transfer of ownership of DbConnection from application to DbContext](https://redirect.github.com/dotnet/efcore/issues/24199)
- [Provide more information when 'No DbContext was found' error is generated](https://redirect.github.com/dotnet/efcore/issues/18715)
EF Core 8 contains work from the EF Team at Microsoft ([@bricelam](https://redirect.github.com/bricelam) [@roji](https://redirect.github.com/roji) [@AndriySvyryd](https://redirect.github.com/AndriySvyryd) [@maumar](https://redirect.github.com/maumar) [@ajcvickers](https://redirect.github.com/ajcvickers)) as well as contributions from the EF Core community. The community PRs in EF8 are:
- [@ErikEJ](https://redirect.github.com/ErikEJ):
- [Update issue templates by ErikEJ · Pull Request #29470 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29470)
- [Reverse engineering of Dynamics CRM TDS endpoint and Synapse Serverless SQL Pool by ErikEJ · Pull Request #29122 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29122)
- [Check for SQL Server VIEW DEFINITION rights fails, if databasename contains special chars by ErikEJ · Pull Request #29612 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29612)
- [Make EngineEdition more readable by ErikEJ · Pull Request #31038 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31038)
- [Fix FK duplicate detection bug by ErikEJ · Pull Request #31181 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31181)
- [Add DateOnly.FromDateTime query mapping for SQL Server by ErikEJ · Pull Request #31180 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31180)
- [@DoctorKrolic](https://redirect.github.com/DoctorKrolic):
- [Remove unnecessary dependency on MS.CA.VB package by DoctorKrolic · Pull Request #29986 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29986)
- [Refactor internal usage analyzer by DoctorKrolic · Pull Request #30767 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30767)
- [Add analyzer/codefix for usage of interpolated strings in raw query methods by DoctorKrolic · Pull Request #30835 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30835)
- [Refactor analyzers' test infrastructure by DoctorKrolic · Pull Request #30814 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30814)
- [@stevendarby](https://redirect.github.com/stevendarby):
- [Don't duplicate query filter parameters by stevendarby · Pull Request #29422 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29422)
- [Allow changing an open connection if it's not owned by stevendarby · Pull Request #30706 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30706)
- [Allow DI for pooled DbContexts by stevendarby · Pull Request #30739 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30739)
- [@kuznetsovvj](https://redirect.github.com/kuznetsovvj):
- [Add a generic overload of ConventionSetBuilder.Remove by kuznetsovvj · Pull Request #29499 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29499)
- [@bikbov](https://redirect.github.com/bikbov):
- [ToString() on string columns added by bikbov · Pull Request #29349 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29349)
- [@nbarbettini](https://redirect.github.com/nbarbettini):
- [Fix grammar in XML doc for ToQueryString by nbarbettini · Pull Request #29979 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29979)
- [@gurustron](https://redirect.github.com/gurustron):
- [Fix typo in ApplyConfigurationsFromAssembly XML doc by gurustron · Pull Request #30003 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30003)
- [@alhad-deshpande](https://redirect.github.com/alhad-deshpande):
- [Updating SQLitePCLRaw library versions to 2.1.3 as it has ppc64le sup… by alhad-deshpande · Pull Request #29783 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29783)
- [@Suchiman](https://redirect.github.com/Suchiman):
- [Fix Typo by Suchiman · Pull Request #30480 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30480)
- [@ilmalte](https://redirect.github.com/ilmalte):
- [Create directory chain if doesn't exist for ef migrations bundle by ilmalte · Pull Request #30392 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30392)
- [@mihaita](https://redirect.github.com/mihaita):
- [Proposed fix for Optional RestartSequenceOperation.StartValue #26560 by dmihaita · Pull Request #29346 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29346)
- [@Marusyk](https://redirect.github.com/Marusyk):
- [Translate DateTimeOffset.ToUnixTime\[Seconds|Milliseconds\] by Marusyk · Pull Request #28978 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/28978)
- [@OsamaAbuSitta](https://redirect.github.com/OsamaAbuSitta):
- [Fix #30072 : Add Generic version of EntityTypeConfiguration Attribute by OsamaAbuSitta · Pull Request #30653 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30653)
- [@NKnusperer](https://redirect.github.com/NKnusperer):
- [Make `SequentialGuidValueGenerator` non-allocating by NKnusperer · Pull Request #30649 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30649)
- [@memory-thrasher](https://redirect.github.com/memory-thrasher):
- [Fixes scaffolding on Synapse (triggers) by memory-thrasher · Pull Request #31011 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31011)
- [@beliakov-mb](https://redirect.github.com/beliakov-mb):
- [Fix navigation in UserDefinedFunction by beliakov-mb · Pull Request #30776 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30776)
- [@netotz](https://redirect.github.com/netotz):
- [Documentation: Use `using` declarations in README files by netotz · Pull Request #31089 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31089)
- [@justindbaur](https://redirect.github.com/justindbaur):
- [Add `migrations has-pending-model-changes` Command by justindbaur · Pull Request #31164 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31164)
- [@matheus-inacio](https://redirect.github.com/matheus-inacio):
- [Implemented missing methods in the SaveChangesInterceptorAggregator by matheus-inacio · Pull Request #31363 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31363)
- [@smnsht](https://redirect.github.com/smnsht):
- [31355: SQLite: Add EF.Functions.Unhex by smnsht · Pull Request #31454 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31454)
- [@freakingawesome](https://redirect.github.com/freakingawesome)
- [Treat Sql Error Number 1222 as Transient by freakingawesome · Pull Request #31725 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31725)
- [@Varorbc](https://redirect.github.com/Varorbc):
- [Remove implicitly dependent reference by Varorbc · Pull Request #31006 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31006)
- [@hmajerus](https://redirect.github.com/hmajerus):
- [Add support for DATA_COMPRESSION and SORT_IN_TEMPDB SQL Server index options by hmajerus · Pull Request #30831 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30831)
- [@sulton-max](https://redirect.github.com/sulton-max):
- [Add DateOnly.ToString / TimeOnly.ToString query mapping for SQL Server by sulton-max · Pull Request #31289 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31289)
See GitHub for all issues resolved in [8.0.0](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.0+is%3Aclosed).
### [`v7.0.20`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.20): EF Core 7.0.20
#### Note: EF Core 7 is now [out-of-support](https://learn.microsoft.com/ef/core/what-is-new/).
This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.20) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.19.
### [`v7.0.19`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.19): EF Core 7.0.19
#### Note: EF Core 7 is now [out-of-support](https://learn.microsoft.com/ef/core/what-is-new/).
This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.19) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.18.
### [`v7.0.18`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.18): EF Core 7.0.18
This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.18) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.17.
### [`v7.0.17`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.17): EF Core 7.0.17
EF Core 7.0.17 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.17). This is a patch release of EF Core 7 containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.17+is%3Aclosed):
- [SqlClient - Update 8.0 to 5.1.5](https://redirect.github.com/dotnet/efcore/issues/33010)
### [`v7.0.16`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.16): EF Core 7.0.16
EF Core 7.0.16 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.16). This is a patch release of EF Core 7 containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.16+is%3Aclosed):
- [Cancelled token does not prevent execution of ExecuteDeleteAsync(token)](https://redirect.github.com/dotnet/efcore/issues/31448)
### [`v7.0.15`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.15): EF Core 7.0.15
This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.15) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.14.
### [`v7.0.14`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.14): EF Core 7.0.14
This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.14) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.13.
### [`v7.0.13`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.13): EF Core 7.0.13
EF Core 7.0.13 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.13). This is a patch release of EF Core 7 containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.13+is%3Aclosed):
- [Update from ef 6 to ef 7. Error getting base type entities where one child has a required navigation property](https://redirect.github.com/dotnet/efcore/issues/31107)
- [Incorrect translation of comparison of current value with owned type default value](https://redirect.github.com/dotnet/efcore/issues/30996)
- [GroupBy generates invalid SQL when using custom database function](https://redirect.github.com/dotnet/efcore/issues/29638)
And also the following bug fixes from [EF Core 6.0.24](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.24+is%3Aclosed):
- [Memory leak in EntityMaterializerSource](https://redirect.github.com/dotnet/efcore/issues/31866)
- [Possible finalizer thread stuck on System.RuntimeMethodHandle.Destroy](https://redirect.github.com/dotnet/efcore/issues/31782)
- [Memory Issue with EF Core 7 DbContext ServiceProviderCache](https://redirect.github.com/dotnet/efcore/issues/31539)
### [`v7.0.12`](https://redirect.github.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://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.10+is%3Aclosed):
- [Scaffolding synapse fails when attempting to enumerate triggers](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/30851)
### [`v7.0.9`](https://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues/30764)
### [`v7.0.8`](https://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.7+is%3Aclosed):
- [IndexOutOfRangeException in CreateNavigationExpansionExpression](https://redirect.github.com/dotnet/efcore/issues/30115)
- [Linq select cannot project an entity containing both Json columns and ICollections](https://redirect.github.com/dotnet/efcore/issues/30266)
- [Json: updating property with conversion from string to other type fails on sql server](https://redirect.github.com/dotnet/efcore/issues/30330)
- [Duplicate table alias in generated select query (An item with the same key has already been added)](https://redirect.github.com/dotnet/efcore/issues/30358)
- [InvalidOperationException when calling ExecuteUpdate with owned entity & using current value](https://redirect.github.com/dotnet/efcore/issues/30528)
- [Query/Json: projecting entity collection along with json collection generates invalid shaper](https://redirect.github.com/dotnet/efcore/issues/30565)
- [AutoInclude causes ExecuteDelete to fail](https://redirect.github.com/dotnet/efcore/issues/30572)
- [Multiple LeftJoins (GroupJoins) lead to GroupJoin Exception when the same where is used twice](https://redirect.github.com/dotnet/efcore/issues/30575)
- [SaveChanges circular dependency in unique unfiltered index (when change doesn't affect any column from unique index).](https://redirect.github.com/dotnet/efcore/issues/30601)
### [`v7.0.5`](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.5+is%3Aclosed):
- [Can't add migration renaming a column on TPC root](https://redirect.github.com/dotnet/efcore/issues/30321)
- [Scaffolded collection navigation properties do not have setters](https://redirect.github.com/dotnet/efcore/issues/30286)
- [EF7 generating incorrect SQL for the Concat/Union All](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/30028)
### [`v7.0.4`](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.4+is%3Aclosed):
- [Exception replacing multi-level relationship in EF7](https://redirect.github.com/dotnet/efcore/issues/30135)
- [Deletion can cause error "The association between entity types A and B has been severed..."](https://redirect.github.com/dotnet/efcore/issues/30122)
- [Non-empty second migration in TPC scheme using inheritance](https://redirect.github.com/dotnet/efcore/issues/30058)
- [Entity Framework Core 7 keeps creating the same migration for Nullable DateTime field](https://redirect.github.com/dotnet/efcore/issues/29985)
- [TPC mapping strategy not respecting default database schema during migration](https://redirect.github.com/dotnet/efcore/issues/29899)
- [Count after Take throws "No column name was specified for column 1 of 't'."](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/29952)
### [`v7.0.3`](https://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues/27504)
- [ExecuteUpdate fails when target entity has an owned entity](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/29418)
- [Change in behaviour of CSharpHelper.Identifier(string name)](https://redirect.github.com/dotnet/efcore/issues/29450)
- [NullReferenceException scaffolding when no primary key set](https://redirect.github.com/dotnet/efcore/issues/29516)
- [Idempotent migration script not working on EFCore7.0 for AlterColumn when nullable changed from true to false](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/29531)
- [Generated Model Snapshot throws InvalidOperationException](https://redirect.github.com/dotnet/efcore/issues/29534)
- [SQL Server bulk insert broken when new command applies pending commands and goes over the batch parameter limit](https://redirect.github.com/dotnet/efcore/issues/29539)
- [Invalid singularization when scaffolding a manytomany table](https://redirect.github.com/dotnet/efcore/issues/29544)
- [In EF7, SqLite unable to load spatialite using the NetTopologySuite Package](https://redirect.github.com/dotnet/efcore/issues/29584)
- [Cannot access property through interface in ExecuteUpdate setter lambda](https://redirect.github.com/dotnet/efcore/issues/29618)
- [DbContext scaffold missing IndexerProperty for M2M relation after moving to EF Core 7](https://redirect.github.com/dotnet/efcore/issues/29634)
- [Performance regression in model building in Entity Framework Core 7](https://redirect.github.com/dotnet/efcore/issues/29642)
- [Mixing sproc and non-sproc commands in the same batch may fail with a NullReferenceException](https://redirect.github.com/dotnet/efcore/issues/29643)
- [Condition's order will cause different result when using .Contains() to search string cross varchar and nvarchar columns](https://redirect.github.com/dotnet/efcore/issues/29646)
- [SaveChanges circular dependency in unique unfiltered index](https://redirect.github.com/dotnet/efcore/issues/29647)
- [QueryTrackingBehavior resets to TrackAll when using DbContext pooling](https://redirect.github.com/dotnet/efcore/issues/29733)
- [EFCore 7.0.0 - Graph of entity insertion throws a FK exception](https://redirect.github.com/dotnet/efcore/issues/29741)
- [Replacing PK to PK TPH dependent with different type fails](https://redirect.github.com/dotnet/efcore/issues/29789)
- [dotnet ef migrations add freezes](https://redirect.github.com/dotnet/efcore/issues/29826)
- [InvalidOperationException when mapping properties of different types to the same column](https://redirect.github.com/dotnet/efcore/issues/29859)
- [Obsoletion message for AutoTransactionsEnabled is wrong](https://redirect.github.com/dotnet/efcore/issues/29990)
- [Incorrect NullReferenceException for parameter in split query with GroupBy](https://redirect.github.com/dotnet/efcore/issues/30022)
### [`v7.0.2`](https://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues/29502)
### [`v7.0.1`](https://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues/29092)
- [Entity splitting support](https://redirect.github.com/dotnet/efcore/issues/620)
- [Support for GroupBy entityType](https://redirect.github.com/dotnet/efcore/issues/17653)
- [Support GroupJoin when it is final query operator](https://redirect.github.com/dotnet/efcore/issues/19930)
- [ExecuteUpdate: Add SetProperty overload that accepts a value directly (no lambda)](https://redirect.github.com/dotnet/efcore/issues/28968)
- [Support sproc input/output parameters on non-concurrency-token properties](https://redirect.github.com/dotnet/efcore/issues/28704)
- [Implement TagWith for ExecuteUpdate and DeleteUpdate](https://redirect.github.com/dotnet/efcore/issues/28690)
- [ExecuteDelete for owner when only its owned types are sharing the same table](https://redirect.github.com/dotnet/efcore/issues/28671)
- [Stop scaffolding DbSet initialization to null!](https://redirect.github.com/dotnet/efcore/issues/26877)
- [CSharpHelper: support more types of collection literals](https://redirect.github.com/dotnet/efcore/issues/19274)
- [Map JSON values stored in database to EF properties](https://redirect.github.com/dotnet/efcore/issues/4021)
- [ExecuteUpdate/Delete (AKA bulk update, without loading data into memory)](https://redirect.github.com/dotnet/efcore/issues/795)
- [Code templates for scaffolding entity types and DbContext from an existing database](https://redirect.github.com/dotnet/efcore/issues/4038)
- [Support raw SQL Queries for basic types like Guid, DateTime and int](https://redirect.github.com/dotnet/efcore/issues/11624)
- [Allow applications to create model building conventions (aka public conventions)](https://redirect.github.com/dotnet/efcore/issues/214)
- [Cosmos: Support AAD RBAC via the ClientSecretCredential](https://redirect.github.com/dotnet/efcore/issues/26491)
- [Map inserts, updates, and deletes (CUD operations) to stored procedures](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/27306)
- [Support sequence key generation on SQL Server, which is useful for Table-per-concrete-type (TPC) mapping](https://redirect.github.com/dotnet/efcore/issues/28096)
- [Allow null connection string to be passed to UseProvider methods](https://redirect.github.com/dotnet/efcore/issues/26869)
- [Downgrade the ContextInitialized event from Information to Debug](https://redirect.github.com/dotnet/efcore/issues/28480)
- [Get an EntityEntry for Shared Entity Types](https://redirect.github.com/dotnet/efcore/issues/25354)
- [Make EntityEntryGraphIterator publicly usable](https://redirect.github.com/dotnet/efcore/issues/26461)
- [Support unidirectional many-to-many relationships](https://redirect.github.com/dotnet/efcore/issues/3864)
- [Translate string.Join and string.Concat](https://redirect.github.com/dotnet/efcore/issues/2981)
- [RevEng: Enable generating IEntityTypeConfiguration classes (avoids large OnModelCreating)](https://redirect.github.com/dotnet/efcore/issues/8434)
- [Interception to modify the LINQ expression tree](https://redirect.github.com/dotnet/efcore/issues/28505)
- [Interception for DbUpdateConcurrencyException](https://redirect.github.com/dotnet/efcore/issues/28315)
- [Add interception event to be fired when EF has finished consuming a result set](https://redirect.github.com/dotnet/efcore/issues/23535)
- [Add events for DetectChanges/state change](https://redirect.github.com/dotnet/efcore/issues/16256)
- [ChangeTracker: New event for "entity about to get tracked"](https://redirect.github.com/dotnet/efcore/issues/27093)
- [Translate EnvelopeCombiner.CombineAsGeometry aggregate function](https://redirect.github.com/dotnet/efcore/issues/28184)
- [SQL Server: Translate statistics aggregate functions](https://redirect.github.com/dotnet/efcore/issues/28104)
- [Filtered Includes for hidden navigation properties](https://redirect.github.com/dotnet/efcore/issues/27493)
- [Make it easier to pass a CancellationToken to FindAsync](https://redirect.github.com/dotnet/efcore/issues/22667)
- [Interception for object materialization (a.k.a. "ObjectMaterialized")](https://redirect.github.com/dotnet/efcore/issues/15911)
- [Provide a hook for identity resolution](https://redirect.github.com/dotnet/efcore/issues/20124)
- [Create lazy-loading and change-tracking proxy types lazily](https://redirect.github.com/dotnet/efcore/issues/20135)
- [Compiled model: Allow use of lazy loading and change tracking proxy types](https://redirect.github.com/dotnet/efcore/issues/24902)
- [Full support for custom provider aggregate functions](https://redirect.github.com/dotnet/efcore/issues/22957)
- [Spatial: Translate aggregate functions](https://redirect.github.com/dotnet/efcore/issues/13278)
- [Allow specifying different column names per table in TPT, TPC or entity splitting](https://redirect.github.com/dotnet/efcore/issues/19811)
- [Support for custom proxy generation](https://redirect.github.com/dotnet/efcore/issues/14554)
- [TPC inheritance mapping pattern](https://redirect.github.com/dotnet/efcore/issues/3170)
- [DeleteBehaviorAttribute](https://redirect.github.com/dotnet/efcore/issues/9621)
- [Translate GetType() for entity types with inheritance](https://redirect.github.com/dotnet/efcore/issues/13424)
- [Delay DbCommandInterceptor.CommandCreated until DbCommand properties are initialized](https://redirect.github.com/dotnet/efcore/issues/17261)
- [Remove unnecessary extra batches in SaveChanges](https://redirect.github.com/dotnet/efcore/issues/20664)
- [Don't check for a connection string until after ConnectionOpening has been called](https://redirect.github.com/dotnet/efcore/issues/23085)
- [Add ConnectionCreating/ConnectionCreated to DbConnectionInterceptor](https://redirect.github.com/dotnet/efcore/issues/23087)
- [Migration name filter](https://redirect.github.com/dotnet/efcore/issues/23222)
- [Add support for AT TIME ZONE](https://redirect.github.com/dotnet/efcore/issues/26199)
- [GroupBy aggregate lifting](https://redirect.github.com/dotnet/efcore/issues/27132)
- [Pascal-case the DbContext name when scaffolding](https://redirect.github.com/dotnet/efcore/issues/27886)
- [Support value generation with converters](https://redirect.github.com/dotnet/efcore/issues/11597)
- [Improve batching performance when using TPH mappings](https://redirect.github.com/dotnet/efcore/issues/3954)
- [Attribute (Data Annotations) mapping for composite primary keys](https://redirect.github.com/dotnet/efcore/issues/11003)
- [SQL Server UTF8 collations](https://redirect.github.com/dotnet/efcore/issues/25798)
- [Stop wrapping single changes in transactions where possible](https://redirect.github.com/dotnet/efcore/issues/27439)
- [Use RETURNING/OUTPUT clause for UPDATE/DELETE](https://redirect.github.com/dotnet/efcore/issues/27547)
- [SQLite SaveChanges: Use RETURNING clause](https://redirect.github.com/dotnet/efcore/issues/24835)
- [SQL Server: Optimize SQL Server OUTPUT clause usage when retrieving database-generated values](https://redirect.github.com/dotnet/efcore/issues/27372)
- [Stop automatically deleting orphans for optional relationships with cascade delete configured](https://redirect.github.com/dotnet/efcore/issues/27217)
- [Empty default interface implementations for all interceptor interface methods](https://redirect.github.com/dotnet/efcore/issues/27625)
- [Temporal tables support for owned entities and other table splitting scenarios](https://redirect.github.com/dotnet/efcore/issues/26469)
- [Support for index ordering (ASC/DESC)](https://redirect.github.com/dotnet/efcore/issues/4150)
- [Support "non-rooted" query expressions in compiled queries](https://redirect.github.com/dotnet/efcore/issues/7016)
- [Property/Reference/etc overloads that take IProperty/INavigation](https://redirect.github.com/dotnet/efcore/issues/7390)
- [Distinguish cancellation from failure to allow different logging strategies](https://redirect.github.com/dotnet/efcore/issues/19526)
- [Lift table from subquery when joining if no additional operations](https://redirect.github.com/dotnet/efcore/issues/21321)
- [DiagnosticSuppressor for CS8618 for DbSet properties](https://redirect.github.com/dotnet/efcore/issues/21608)
- [Stop generating a default DbContext constructor when using dotnet ef dbcontext scaffold --no-onconfiguring](https://redirect.github.com/dotnet/efcore/issues/23515)
- [Robust and extensible SQL precedence/parentheses mechanism](https://redirect.github.com/dotnet/efcore/issues/23895)
- [Translation for string.IndexOf(string, int)](https://redirect.github.com/dotnet/efcore/issues/25396)
- [Support SqlNullabilityProcessor and COALESCE with more than two arguments](https://redirect.github.com/dotnet/efcore/issues/26344)
- [Support Contains when using a IReadOnlySet](https://redirect.github.com/dotnet/efcore/issues/26437)
- [Overload of EnableRetryOnFailure that allows specifying errorCodesToAdd without count / delay](https://redirect.github.com/dotnet/efcore/issues/27074)
See GitHub for [all issues resolved in EF7](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.0+is%3Aclosed).
### [`v6.0.35`](https://redirect.github.com/dotnet/efcore/releases/tag/v6.0.35): .NET 6.0.35
[Release](https://redirect.github.com/dotnet/core/releases/tag/v6.0.35)
### [`v6.0.33`](https://redirect.github.com/dotnet/efcore/releases/tag/v6.0.33): .NET 6.0.33
[Release](https://redirect.github.com/dotnet/core/releases/tag/v6.0.33)
### [`v6.0.32`](https://redirect.github.com/dotnet/efcore/releases/tag/v6.0.32): EF Core 6.0.32
This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.32) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.0.31.
### [`v6.0.31`](https://redirect.github.com/dotnet/efcore/releases/tag/v6.0.31): EF Core 6.0.31
This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.31) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.30.
### [`v6.0.30`](https://redirect.github.com/dotnet/efcore/releases/tag/v6.0.30): EF Core 6.0.30
This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.30) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.29.
### [`v6.0.29`](https://redirect.github.com/dotnet/efcore/releases/tag/v6.0.29): EF Core 6.0.29
This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.29) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.28.
### [`v6.0.28`](https://redirect.github.com/dotnet/efcore/releases/tag/v6.0.28): EF Core 6.0.28
This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.28) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.27.
### [`v6.0.27`](https://redirect.github.com/dotnet/efcore/releases/tag/v6.0.27): EF Core 6.0.27
This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.27) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.26.
### [`v6.0.26`](https://redirect.github.com/dotnet/efcore/releases/tag/v6.0.26): EF Core 6.0.26
This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.26) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.25.
### [`v6.0.25`](https://redirect.github.com/dotnet/efcore/releases/tag/v6.0.25): EF Core 6.0.25
This is a [patch release of EF Core 6.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.1.25) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 6.1.24.
### [`v6.0.24`](https://redirect.github.com/dotnet/efcore/releases/tag/v6.0.24): EF Core 6.0.24
EF Core 6.0.24 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.24). This is a patch release of EF Core 6 containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.24+is%3Aclosed):
- [Memory leak in EntityMaterializerSource](https://redirect.github.com/dotnet/efcore/issues/31866)
- [Possible finalizer thread stuck on System.RuntimeMethodHandle.Destroy](https://redirect.github.com/dotnet/efcore/issues/31782)
- [Memory Issue with EF Core 7 DbContext ServiceProviderCache](https://redirect.github.com/dotnet/efcore/issues/31539)
### [`v6.0.23`](https://redirect.github.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://redirect.github.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://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues/30851)
### [`v6.0.20`](https://redirect.github.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://redirect.github.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://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/releases/tag/v6.0.15): EF Core 6.0.15
This is a [patch rele
Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, check this box
This PR contains the following updates:
3.1.3
->8.0.10
Release Notes
dotnet/efcore (Microsoft.EntityFrameworkCore.SqlServer)
### [`v8.0.10`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.10): .NET 8.0.10 [Release](https://redirect.github.com/dotnet/core/releases/tag/v8.0.10) ### [`v8.0.8`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.8): .NET 8.0.8 [Release](https://redirect.github.com/dotnet/core/releases/tag/v8.0.8) ### [`v8.0.7`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.7): EF Core 8.0.7 EF Core 8.0.7 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.7). This is a patch release of EF Core 8 (EF8) containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.7+is%3Aclosed): - \[Missing checks for predicate when simplifying JSON primitive collections]\(https://github.com/dotnet/efcore/issues/ [#33932](https://redirect.github.com/dotnet/efcore/issues/33932) - \[Discriminator columns are created in Snapshot for wrongly configured TPC mapping strategy]\(https://github.com/dotnet/efcore/issues/ 33605) - [Breaking Change in 8.0.4: System.InvalidOperationException: The data is NULL at ordinal 0. This method can't be called on NULL values. Check using IsDBNull before calling.](https://redirect.github.com/dotnet/efcore/issues/33547) - [Wrong mapping of nested complex property with generic types and same property name, resulting in InvalidCastException](https://redirect.github.com/dotnet/efcore/issues/33449) ### [`v8.0.6`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.6): EF Core 8.0.6 This is a [patch release of EF Core 8.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.6) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 8.0.5. ### [`v8.0.5`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.5): EF Core 8.0.5 This is a [patch release of EF Core 8.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.5) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 8.0.4. ### [`v8.0.4`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.4): EF Core 8.0.4 EF Core 8.0.4 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.4). This is a patch release of EF Core 8 (EF8) containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.4+is%3Aclosed): - [Incorrect apply projection for complex properties](https://redirect.github.com/dotnet/efcore/issues/32911) - [The database default created by Migrations for primitive collections mapped to JSON is invalid](https://redirect.github.com/dotnet/efcore/issues/32972) - [Filtering by Contains with HierarchyId and AsSplitQuery is not working](https://redirect.github.com/dotnet/efcore/issues/32976) - [Unfulfillable nullable contraints are set for complex types with TPH entities](https://redirect.github.com/dotnet/efcore/issues/33004) - [OutOfMemoryException when creating migration using ef tool](https://redirect.github.com/dotnet/efcore/issues/33176) - [SQL Server: Should retry on 203](https://redirect.github.com/dotnet/efcore/issues/33260) ### [`v8.0.3`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.3): EF Core 8.0.3 EF Core 8.0.3 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.3). This is a patch release of EF Core 8 (EF8) containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.3+is%3Aclosed): - [Constructor calls when using inheritance with owned entities causes exceptions](https://redirect.github.com/dotnet/efcore/issues/31353) - [Missing package README file](https://redirect.github.com/dotnet/efcore/issues/31947) - [String properties with indexes are compared case insensitively on SQL Server](https://redirect.github.com/dotnet/efcore/issues/32898) - [Using SqliteConnection from an ASP.NET MVC (.NET Framework) application results in a few different exceptions](https://redirect.github.com/dotnet/efcore/issues/32614) - [Exception when using FromSql on entity with ComplexProperty](https://redirect.github.com/dotnet/efcore/issues/32699) - [IndexOutOfRange for EntityEntry.GetDatabaseValues() with complex type and TPH](https://redirect.github.com/dotnet/efcore/issues/32701) - [SQL Server Migrations - SqlOperation.Sql is stripped of all empty lines](https://redirect.github.com/dotnet/efcore/issues/32730) - [NullReferenceException in Get-Migration in EF Core 8](https://redirect.github.com/dotnet/efcore/issues/32732) - [Owned entity on genericly typed entity generates unwanted steps in new migrations](https://redirect.github.com/dotnet/efcore/issues/32763) - [Dotnet-ef mismatch causes apply Entity Framework migration fails when publishing an individual web app.](https://redirect.github.com/dotnet/efcore/issues/32782) - [Query never returns when DB value for column mapped to primitive collection is](https://redirect.github.com/dotnet/efcore/issues/32896) ### [`v8.0.2`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.2): EF Core 8.0.2 EF Core 8.0.2 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.2). This is a patch release of EF Core 8 (EF8) containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.2+is%3Aclosed): - [Adding EF.Constant to prevent parameterization in query](https://redirect.github.com/dotnet/efcore/issues/32680) - [Nav expansion visitor does not visit the Contains item argument](https://redirect.github.com/dotnet/efcore/issues/32217) - [SqliteException "no such column : rX.value" when ordering on subquery value in combination with a "where contains" when upgrading from 7 to 8.0.0-rc.2.23480.1](https://redirect.github.com/dotnet/efcore/issues/32234) - [DB Context pooling with proxies resulting in memory issues in 8.0 RC2](https://redirect.github.com/dotnet/efcore/issues/32267) - [Nav expansion visitor does not visit the non-lambda arguments (Skip, Take, ElementAt)](https://redirect.github.com/dotnet/efcore/issues/32312) - [LINQ "Contains" generates SQL with wrong char length](https://redirect.github.com/dotnet/efcore/issues/32325) - [Using new\[\] in select query gives exception .NET 8](https://redirect.github.com/dotnet/efcore/issues/32331) - [EF Core Cosmos 7.0.13 => 7.0.14 Value cannot be null. (Parameter 'derivedType')](https://redirect.github.com/dotnet/efcore/issues/32363) - [New OpenJSON expression to SQL translation breaks aggregates on subquery with 'Cannot perform an aggregate function on an expression containing an aggregate or a subquery' exception](https://redirect.github.com/dotnet/efcore/issues/32374) - [Did Contains stop working on empty list in EF Core 8?](https://redirect.github.com/dotnet/efcore/issues/32375) - [LINQ "Contains" fails to generate SQL with custom converter](https://redirect.github.com/dotnet/efcore/issues/32376) - [error on working with explicit many-to-many relations with OnDelete.Restrict](https://redirect.github.com/dotnet/efcore/issues/32383) - [Lazy loader throwing invalid operation exceptions](https://redirect.github.com/dotnet/efcore/issues/32390) - [Cosmos provider v7.0.14 and v8.0.0 breaks previous OwnsMany behaviour](https://redirect.github.com/dotnet/efcore/issues/32410) - [Constructor not found for type 'Microsoft.EntityFrameworkCore.ChangeTracking.Internal.NullableClassCurrentProviderValueComparer](https://redirect.github.com/dotnet/efcore/issues/32411) - [Inconsistent behavior related to relationship cycle](https://redirect.github.com/dotnet/efcore/issues/32422) - [Property conversions are lost on base type is subtype is registered to model afterwards after upgrade to EFCore 8](https://redirect.github.com/dotnet/efcore/issues/32430) - [Incorrect parameter rewriting for string StartsWith/EndsWith/Contains](https://redirect.github.com/dotnet/efcore/issues/32432) - [Migrations bug when creating stored procedure with GOTO statement](https://redirect.github.com/dotnet/efcore/issues/32457) - [Unable to Scaffold DBContext if tables in SQL Server have certain names](https://redirect.github.com/dotnet/efcore/issues/32571) - [Contains translates to correlated query when the item is nullable](https://redirect.github.com/dotnet/efcore/issues/32574) - [FluentAPI configuration PrimitiveCollection on OwnedNavigationBuilder returns PropertyBuilder instead of PrimitiveCollectionBuilder](https://redirect.github.com/dotnet/efcore/issues/32601) - [String comparison fails when using const and compiled Models.](https://redirect.github.com/dotnet/efcore/issues/32617) - [Exception when writing a JSON column with negative enum value](https://redirect.github.com/dotnet/efcore/issues/32679) - [Getting errors when mixing DbFunction and SqlQueryRaw](https://redirect.github.com/dotnet/efcore/issues/32680) ### [`v8.0.1`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.1): EF Core 8.0.1 EF Core 8.0.1 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.1). This is a patch release of EF Core 8 (EF8) containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.1+is%3Aclosed): - [EFC8: Lazy Loading regression on newly created objects](https://redirect.github.com/dotnet/efcore/issues/32314) - [EfCore 8: Primitive collections in JSON documents error with init](https://redirect.github.com/dotnet/efcore/issues/32310) - [Buffering error in JSON deserialization with junk data](https://redirect.github.com/dotnet/efcore/issues/32235) - [Contains fallback translation fails when the array parameter has AsQueryable](https://redirect.github.com/dotnet/efcore/issues/32218) - [QueryableMethodNormalizingExpressionVisitor does not visit recursively when converting List.Contains to Queryable.Contains](https://redirect.github.com/dotnet/efcore/issues/32215) - [SqlNullabilityProcessor ignores Contains item visitation](https://redirect.github.com/dotnet/efcore/issues/32208) - [SensitiveDataLogging with ComplexProperty: Unable to cast RuntimeComplexType to type IEntityType](https://redirect.github.com/dotnet/efcore/issues/32198) - [JSON materialization code should be resilient to incorrect JSON documents](https://redirect.github.com/dotnet/efcore/issues/32194) ### [`v8.0.0`](https://redirect.github.com/dotnet/efcore/releases/tag/v8.0.0): EF Core 8 (EF8) EF Core 8 (EF8) is [available from NuGet](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/8.0.0) EF8 contains many new features and enhancements, including: - [Allow Multi-region or Application Preferred Regions in EF Core Cosmos](https://redirect.github.com/dotnet/efcore/issues/29424) - [Use C# structs or classes as value objects](https://redirect.github.com/dotnet/efcore/issues/9906) - [Support primitive collections in the compiled model](https://redirect.github.com/dotnet/efcore/issues/31489) - [Migrations and model snapshot for primitive collections](https://redirect.github.com/dotnet/efcore/issues/31414) - [Query: add support for projecting JSON entities that have been composed on](https://redirect.github.com/dotnet/efcore/issues/31365) - [SQLite: Add EF.Functions.Unhex](https://redirect.github.com/dotnet/efcore/issues/31355) - [Add type mapping APIs to customize JSON value serialization/deserialization](https://redirect.github.com/dotnet/efcore/issues/30677) - [SQL Server Index options SortInTempDB and DataCompression](https://redirect.github.com/dotnet/efcore/issues/30408) - [Analyzer: warn (and code fix) for use of interpolation in SQL methods accepting raw strings](https://redirect.github.com/dotnet/efcore/issues/30965) - [Translate Contains to IN with subquery instead of EXISTS where relevant](https://redirect.github.com/dotnet/efcore/issues/30955) - [Allow inline primitive collections with parameters, translating to VALUES](https://redirect.github.com/dotnet/efcore/issues/30732) - [Translate DateOnly.FromDateTime](https://redirect.github.com/dotnet/efcore/issues/30708) - [Implement JSON serialization/deserialization via Utf8JsonReader/Utf8JsonWriter](https://redirect.github.com/dotnet/efcore/issues/30604) - [Update pattern for scaffolding column default constraints](https://redirect.github.com/dotnet/efcore/issues/13613) - [Use IN instead of EXISTS with ExecuteDelete and entity containment](https://redirect.github.com/dotnet/efcore/issues/31386) - [Allow ExecuteUpdate to update properties of multiple queries as long as the map to a single table](https://redirect.github.com/dotnet/efcore/issues/31406) - [Query: add support for projecting primitive collections from JSON entities](https://redirect.github.com/dotnet/efcore/issues/31364) - [Switch to storing enums as ints in JSON instead of strings](https://redirect.github.com/dotnet/efcore/issues/31100) - [Translate DegreesToRadians](https://redirect.github.com/dotnet/efcore/issues/30926) - [Metadata and type mapping support for primitive collections](https://redirect.github.com/dotnet/efcore/issues/30730) - [JSON type representations and conversions to store types](https://redirect.github.com/dotnet/efcore/issues/30727) - [Allow stripping away all model building code to reduce application size](https://redirect.github.com/dotnet/efcore/issues/29755) - [Json: add support for collection of primitive types inside JSON columns](https://redirect.github.com/dotnet/efcore/issues/28688) - [Support LINQ querying of non-primitive collections within JSON](https://redirect.github.com/dotnet/efcore/issues/28616) - [SQLite RevEng: Sample data to determine CLR type](https://redirect.github.com/dotnet/efcore/issues/8824) - [Allow default value check in value generation to be customized](https://redirect.github.com/dotnet/efcore/issues/701) - [Update handling of non-nullable store-generated properties](https://redirect.github.com/dotnet/efcore/issues/15070) - [IN() list queries are not parameterized, causing increased SQL Server CPU usage](https://redirect.github.com/dotnet/efcore/issues/13617) - [Allow 'unsharing' connection between contexts](https://redirect.github.com/dotnet/efcore/issues/30704) - [Remove unneeded subquery and projection when using ordering without limit/offset in set operations](https://redirect.github.com/dotnet/efcore/issues/30684) - [Make SequentialGuidValueGenerator non-allocating](https://redirect.github.com/dotnet/efcore/issues/30610) - [Support querying over primitive collections](https://redirect.github.com/dotnet/efcore/issues/30426) - [JSON/Sqlite: use -> and ->> where possible when traversing JSON, rather than json_extract](https://redirect.github.com/dotnet/efcore/issues/30334) - [Add Generic version of EntityTypeConfiguration Attribute](https://redirect.github.com/dotnet/efcore/issues/30072) - [NativeAOT/trimming compatibility for Microsoft.Data.Sqlite](https://redirect.github.com/dotnet/efcore/issues/29725) - [Map collections of primitive types to JSON column in relational database](https://redirect.github.com/dotnet/efcore/issues/29427) - [Translate DateTimeOffset.ToUnixTime(Seconds|Milliseconds)](https://redirect.github.com/dotnet/efcore/issues/28925) - [Allow pooling DbContext with singleton services](https://redirect.github.com/dotnet/efcore/issues/27752) - [Optional RestartSequenceOperation.StartValue](https://redirect.github.com/dotnet/efcore/issues/26560) - [Generate compiled relational model](https://redirect.github.com/dotnet/efcore/issues/24896) - [Global query filters produce too many parameters](https://redirect.github.com/dotnet/efcore/issues/24476) - [Optimize update path for single property JSON element](https://redirect.github.com/dotnet/efcore/issues/30410) - [JSON columns can be used in compiled models](https://redirect.github.com/dotnet/efcore/issues/29602) - [Unneeded parentheses removed in SQL queries ](https://redirect.github.com/dotnet/efcore/issues/26767) - [Set operations are supported over non-entity projections with different facets](https://redirect.github.com/dotnet/efcore/issues/19129) - [Json: add support for Sqlite provider](https://redirect.github.com/dotnet/efcore/issues/28816) - [SQL Server: Support hierarchyid](https://redirect.github.com/dotnet/efcore/issues/365) - [Configuration to opt out of occasionally problematic SaveChanges optimizations](https://redirect.github.com/dotnet/efcore/issues/29916) - [Add convention types for triggers](https://redirect.github.com/dotnet/efcore/issues/28687) - [Translate element access of a JSON array](https://redirect.github.com/dotnet/efcore/issues/28648) - [Raw SQL queries for unmapped types](https://learn.microsoft.com/ef/core/what-is-new/ef-core-8.0/plan#sql-queries-for-unmapped-types) - [Support the new BCL DateOnly and TimeOnly structs for SQL Server](https://redirect.github.com/dotnet/efcore/issues/24507) - [Translate ElementAt(OrDefault)](https://redirect.github.com/dotnet/efcore/issues/17066) - [Opt-out of lazy-loading for specific navigations](https://redirect.github.com/dotnet/efcore/issues/10787) - [Lazy-loading for no-tracking queries](https://redirect.github.com/dotnet/efcore/issues/10042) - [Reverse engineer Synapse and Dynamics 365 TDS](https://redirect.github.com/dotnet/efcore/issues/29121) - [Set MaxLength on TPH discriminator property by convention](https://redirect.github.com/dotnet/efcore/issues/10691) - [Translate ToString() on a string column](https://redirect.github.com/dotnet/efcore/issues/20839) - [Generic overload of ConventionSetBuilder.Remove](https://redirect.github.com/dotnet/efcore/issues/29476) - [Lookup tracked entities by primary key, alternate key, or foreign key](https://redirect.github.com/dotnet/efcore/issues/29685) - [Allow UseSequence and HiLo on non-key properties](https://redirect.github.com/dotnet/efcore/issues/29758) - [Pass query tracking behavior to materialization interceptor](https://redirect.github.com/dotnet/efcore/issues/29910) - [Use case-insensitive string key comparisons on SQL Server](https://redirect.github.com/dotnet/efcore/issues/27526) - [Allow value converters to change the DbType](https://redirect.github.com/dotnet/efcore/issues/24771) - [Resolve application services in EF services](https://redirect.github.com/dotnet/efcore/issues/13540) - [Numeric rowersion properties automatically convert to binary](https://redirect.github.com/dotnet/efcore/issues/12434) - [Allow transfer of ownership of DbConnection from application to DbContext](https://redirect.github.com/dotnet/efcore/issues/24199) - [Provide more information when 'No DbContext was found' error is generated](https://redirect.github.com/dotnet/efcore/issues/18715) EF Core 8 contains work from the EF Team at Microsoft ([@bricelam](https://redirect.github.com/bricelam) [@roji](https://redirect.github.com/roji) [@AndriySvyryd](https://redirect.github.com/AndriySvyryd) [@maumar](https://redirect.github.com/maumar) [@ajcvickers](https://redirect.github.com/ajcvickers)) as well as contributions from the EF Core community. The community PRs in EF8 are: - [@ErikEJ](https://redirect.github.com/ErikEJ): - [Update issue templates by ErikEJ · Pull Request #29470 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29470) - [Reverse engineering of Dynamics CRM TDS endpoint and Synapse Serverless SQL Pool by ErikEJ · Pull Request #29122 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29122) - [Check for SQL Server VIEW DEFINITION rights fails, if databasename contains special chars by ErikEJ · Pull Request #29612 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29612) - [Make EngineEdition more readable by ErikEJ · Pull Request #31038 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31038) - [Fix FK duplicate detection bug by ErikEJ · Pull Request #31181 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31181) - [Add DateOnly.FromDateTime query mapping for SQL Server by ErikEJ · Pull Request #31180 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31180) - [@DoctorKrolic](https://redirect.github.com/DoctorKrolic): - [Remove unnecessary dependency on MS.CA.VB package by DoctorKrolic · Pull Request #29986 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29986) - [Refactor internal usage analyzer by DoctorKrolic · Pull Request #30767 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30767) - [Add analyzer/codefix for usage of interpolated strings in raw query methods by DoctorKrolic · Pull Request #30835 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30835) - [Refactor analyzers' test infrastructure by DoctorKrolic · Pull Request #30814 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30814) - [@stevendarby](https://redirect.github.com/stevendarby): - [Don't duplicate query filter parameters by stevendarby · Pull Request #29422 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29422) - [Allow changing an open connection if it's not owned by stevendarby · Pull Request #30706 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30706) - [Allow DI for pooled DbContexts by stevendarby · Pull Request #30739 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30739) - [@kuznetsovvj](https://redirect.github.com/kuznetsovvj): - [Add a generic overload of ConventionSetBuilder.Remove by kuznetsovvj · Pull Request #29499 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29499) - [@bikbov](https://redirect.github.com/bikbov): - [ToString() on string columns added by bikbov · Pull Request #29349 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29349) - [@nbarbettini](https://redirect.github.com/nbarbettini): - [Fix grammar in XML doc for ToQueryString by nbarbettini · Pull Request #29979 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29979) - [@gurustron](https://redirect.github.com/gurustron): - [Fix typo in ApplyConfigurationsFromAssembly XML doc by gurustron · Pull Request #30003 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30003) - [@alhad-deshpande](https://redirect.github.com/alhad-deshpande): - [Updating SQLitePCLRaw library versions to 2.1.3 as it has ppc64le sup… by alhad-deshpande · Pull Request #29783 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29783) - [@Suchiman](https://redirect.github.com/Suchiman): - [Fix Typo by Suchiman · Pull Request #30480 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30480) - [@ilmalte](https://redirect.github.com/ilmalte): - [Create directory chain if doesn't exist for ef migrations bundle by ilmalte · Pull Request #30392 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30392) - [@mihaita](https://redirect.github.com/mihaita): - [Proposed fix for Optional RestartSequenceOperation.StartValue #26560 by dmihaita · Pull Request #29346 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/29346) - [@Marusyk](https://redirect.github.com/Marusyk): - [Translate DateTimeOffset.ToUnixTime\[Seconds|Milliseconds\] by Marusyk · Pull Request #28978 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/28978) - [@OsamaAbuSitta](https://redirect.github.com/OsamaAbuSitta): - [Fix #30072 : Add Generic version of EntityTypeConfiguration Attribute by OsamaAbuSitta · Pull Request #30653 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30653) - [@NKnusperer](https://redirect.github.com/NKnusperer): - [Make `SequentialGuidValueGenerator` non-allocating by NKnusperer · Pull Request #30649 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30649) - [@memory-thrasher](https://redirect.github.com/memory-thrasher): - [Fixes scaffolding on Synapse (triggers) by memory-thrasher · Pull Request #31011 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31011) - [@beliakov-mb](https://redirect.github.com/beliakov-mb): - [Fix navigation in UserDefinedFunction by beliakov-mb · Pull Request #30776 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30776) - [@netotz](https://redirect.github.com/netotz): - [Documentation: Use `using` declarations in README files by netotz · Pull Request #31089 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31089) - [@justindbaur](https://redirect.github.com/justindbaur): - [Add `migrations has-pending-model-changes` Command by justindbaur · Pull Request #31164 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31164) - [@matheus-inacio](https://redirect.github.com/matheus-inacio): - [Implemented missing methods in the SaveChangesInterceptorAggregator by matheus-inacio · Pull Request #31363 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31363) - [@smnsht](https://redirect.github.com/smnsht): - [31355: SQLite: Add EF.Functions.Unhex by smnsht · Pull Request #31454 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31454) - [@freakingawesome](https://redirect.github.com/freakingawesome) - [Treat Sql Error Number 1222 as Transient by freakingawesome · Pull Request #31725 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31725) - [@Varorbc](https://redirect.github.com/Varorbc): - [Remove implicitly dependent reference by Varorbc · Pull Request #31006 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31006) - [@hmajerus](https://redirect.github.com/hmajerus): - [Add support for DATA_COMPRESSION and SORT_IN_TEMPDB SQL Server index options by hmajerus · Pull Request #30831 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/30831) - [@sulton-max](https://redirect.github.com/sulton-max): - [Add DateOnly.ToString / TimeOnly.ToString query mapping for SQL Server by sulton-max · Pull Request #31289 · dotnet/efcore (github.com)](https://redirect.github.com/dotnet/efcore/pull/31289) See GitHub for all issues resolved in [8.0.0](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A8.0.0+is%3Aclosed). ### [`v7.0.20`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.20): EF Core 7.0.20 #### Note: EF Core 7 is now [out-of-support](https://learn.microsoft.com/ef/core/what-is-new/). This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.20) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.19. ### [`v7.0.19`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.19): EF Core 7.0.19 #### Note: EF Core 7 is now [out-of-support](https://learn.microsoft.com/ef/core/what-is-new/). This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.19) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.18. ### [`v7.0.18`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.18): EF Core 7.0.18 This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.18) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.17. ### [`v7.0.17`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.17): EF Core 7.0.17 EF Core 7.0.17 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.17). This is a patch release of EF Core 7 containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.17+is%3Aclosed): - [SqlClient - Update 8.0 to 5.1.5](https://redirect.github.com/dotnet/efcore/issues/33010) ### [`v7.0.16`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.16): EF Core 7.0.16 EF Core 7.0.16 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.16). This is a patch release of EF Core 7 containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.16+is%3Aclosed): - [Cancelled token does not prevent execution of ExecuteDeleteAsync(token)](https://redirect.github.com/dotnet/efcore/issues/31448) ### [`v7.0.15`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.15): EF Core 7.0.15 This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.15) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.14. ### [`v7.0.14`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.14): EF Core 7.0.14 This is a [patch release of EF Core 7.0](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.14) containing only updates to dependencies. There are no additional fixes in this release beyond those already shipped in EF Core 7.0.13. ### [`v7.0.13`](https://redirect.github.com/dotnet/efcore/releases/tag/v7.0.13): EF Core 7.0.13 EF Core 7.0.13 is [available on NuGet now](https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/7.0.13). This is a patch release of EF Core 7 containing only [important bug fixes](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.13+is%3Aclosed): - [Update from ef 6 to ef 7. Error getting base type entities where one child has a required navigation property](https://redirect.github.com/dotnet/efcore/issues/31107) - [Incorrect translation of comparison of current value with owned type default value](https://redirect.github.com/dotnet/efcore/issues/30996) - [GroupBy generates invalid SQL when using custom database function](https://redirect.github.com/dotnet/efcore/issues/29638) And also the following bug fixes from [EF Core 6.0.24](https://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A6.0.24+is%3Aclosed): - [Memory leak in EntityMaterializerSource](https://redirect.github.com/dotnet/efcore/issues/31866) - [Possible finalizer thread stuck on System.RuntimeMethodHandle.Destroy](https://redirect.github.com/dotnet/efcore/issues/31782) - [Memory Issue with EF Core 7 DbContext ServiceProviderCache](https://redirect.github.com/dotnet/efcore/issues/31539) ### [`v7.0.12`](https://redirect.github.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://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.10+is%3Aclosed): - [Scaffolding synapse fails when attempting to enumerate triggers](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/30851) ### [`v7.0.9`](https://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues/30764) ### [`v7.0.8`](https://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.7+is%3Aclosed): - [IndexOutOfRangeException in CreateNavigationExpansionExpression](https://redirect.github.com/dotnet/efcore/issues/30115) - [Linq select cannot project an entity containing both Json columns and ICollections](https://redirect.github.com/dotnet/efcore/issues/30266) - [Json: updating property with conversion from string to other type fails on sql server](https://redirect.github.com/dotnet/efcore/issues/30330) - [Duplicate table alias in generated select query (An item with the same key has already been added)](https://redirect.github.com/dotnet/efcore/issues/30358) - [InvalidOperationException when calling ExecuteUpdate with owned entity & using current value](https://redirect.github.com/dotnet/efcore/issues/30528) - [Query/Json: projecting entity collection along with json collection generates invalid shaper](https://redirect.github.com/dotnet/efcore/issues/30565) - [AutoInclude causes ExecuteDelete to fail](https://redirect.github.com/dotnet/efcore/issues/30572) - [Multiple LeftJoins (GroupJoins) lead to GroupJoin Exception when the same where is used twice](https://redirect.github.com/dotnet/efcore/issues/30575) - [SaveChanges circular dependency in unique unfiltered index (when change doesn't affect any column from unique index).](https://redirect.github.com/dotnet/efcore/issues/30601) ### [`v7.0.5`](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.5+is%3Aclosed): - [Can't add migration renaming a column on TPC root](https://redirect.github.com/dotnet/efcore/issues/30321) - [Scaffolded collection navigation properties do not have setters](https://redirect.github.com/dotnet/efcore/issues/30286) - [EF7 generating incorrect SQL for the Concat/Union All](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/30028) ### [`v7.0.4`](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues?q=is%3Aissue+milestone%3A7.0.4+is%3Aclosed): - [Exception replacing multi-level relationship in EF7](https://redirect.github.com/dotnet/efcore/issues/30135) - [Deletion can cause error "The association between entity types A and B has been severed..."](https://redirect.github.com/dotnet/efcore/issues/30122) - [Non-empty second migration in TPC scheme using inheritance](https://redirect.github.com/dotnet/efcore/issues/30058) - [Entity Framework Core 7 keeps creating the same migration for Nullable DateTime field](https://redirect.github.com/dotnet/efcore/issues/29985) - [TPC mapping strategy not respecting default database schema during migration](https://redirect.github.com/dotnet/efcore/issues/29899) - [Count after Take throws "No column name was specified for column 1 of 't'."](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/29952) ### [`v7.0.3`](https://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues/27504) - [ExecuteUpdate fails when target entity has an owned entity](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/29418) - [Change in behaviour of CSharpHelper.Identifier(string name)](https://redirect.github.com/dotnet/efcore/issues/29450) - [NullReferenceException scaffolding when no primary key set](https://redirect.github.com/dotnet/efcore/issues/29516) - [Idempotent migration script not working on EFCore7.0 for AlterColumn when nullable changed from true to false](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/29531) - [Generated Model Snapshot throws InvalidOperationException](https://redirect.github.com/dotnet/efcore/issues/29534) - [SQL Server bulk insert broken when new command applies pending commands and goes over the batch parameter limit](https://redirect.github.com/dotnet/efcore/issues/29539) - [Invalid singularization when scaffolding a manytomany table](https://redirect.github.com/dotnet/efcore/issues/29544) - [In EF7, SqLite unable to load spatialite using the NetTopologySuite Package](https://redirect.github.com/dotnet/efcore/issues/29584) - [Cannot access property through interface in ExecuteUpdate setter lambda](https://redirect.github.com/dotnet/efcore/issues/29618) - [DbContext scaffold missing IndexerProperty for M2M relation after moving to EF Core 7](https://redirect.github.com/dotnet/efcore/issues/29634) - [Performance regression in model building in Entity Framework Core 7](https://redirect.github.com/dotnet/efcore/issues/29642) - [Mixing sproc and non-sproc commands in the same batch may fail with a NullReferenceException](https://redirect.github.com/dotnet/efcore/issues/29643) - [Condition's order will cause different result when using .Contains() to search string cross varchar and nvarchar columns](https://redirect.github.com/dotnet/efcore/issues/29646) - [SaveChanges circular dependency in unique unfiltered index](https://redirect.github.com/dotnet/efcore/issues/29647) - [QueryTrackingBehavior resets to TrackAll when using DbContext pooling](https://redirect.github.com/dotnet/efcore/issues/29733) - [EFCore 7.0.0 - Graph of entity insertion throws a FK exception](https://redirect.github.com/dotnet/efcore/issues/29741) - [Replacing PK to PK TPH dependent with different type fails](https://redirect.github.com/dotnet/efcore/issues/29789) - [dotnet ef migrations add freezes](https://redirect.github.com/dotnet/efcore/issues/29826) - [InvalidOperationException when mapping properties of different types to the same column](https://redirect.github.com/dotnet/efcore/issues/29859) - [Obsoletion message for AutoTransactionsEnabled is wrong](https://redirect.github.com/dotnet/efcore/issues/29990) - [Incorrect NullReferenceException for parameter in split query with GroupBy](https://redirect.github.com/dotnet/efcore/issues/30022) ### [`v7.0.2`](https://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues/29502) ### [`v7.0.1`](https://redirect.github.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://redirect.github.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://redirect.github.com/dotnet/efcore/issues/29092) - [Entity splitting support](https://redirect.github.com/dotnet/efcore/issues/620) - [Support for GroupBy entityType](https://redirect.github.com/dotnet/efcore/issues/17653) - [Support GroupJoin when it is final query operator](https://redirect.github.com/dotnet/efcore/issues/19930) - [ExecuteUpdate: Add SetProperty overload that accepts a value directly (no lambda)](https://redirect.github.com/dotnet/efcore/issues/28968) - [Support sproc input/output parameters on non-concurrency-token properties](https://redirect.github.com/dotnet/efcore/issues/28704) - [Implement TagWith for ExecuteUpdate and DeleteUpdate](https://redirect.github.com/dotnet/efcore/issues/28690) - [ExecuteDelete for owner when only its owned types are sharing the same table](https://redirect.github.com/dotnet/efcore/issues/28671) - [Stop scaffolding DbSet initialization to null!](https://redirect.github.com/dotnet/efcore/issues/26877) - [CSharpHelper: support more types of collection literals](https://redirect.github.com/dotnet/efcore/issues/19274) - [Map JSON values stored in database to EF properties](https://redirect.github.com/dotnet/efcore/issues/4021) - [ExecuteUpdate/Delete (AKA bulk update, without loading data into memory)](https://redirect.github.com/dotnet/efcore/issues/795) - [Code templates for scaffolding entity types and DbContext from an existing database](https://redirect.github.com/dotnet/efcore/issues/4038) - [Support raw SQL Queries for basic types like Guid, DateTime and int](https://redirect.github.com/dotnet/efcore/issues/11624) - [Allow applications to create model building conventions (aka public conventions)](https://redirect.github.com/dotnet/efcore/issues/214) - [Cosmos: Support AAD RBAC via the ClientSecretCredential](https://redirect.github.com/dotnet/efcore/issues/26491) - [Map inserts, updates, and deletes (CUD operations) to stored procedures](https://redirect.github.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://redirect.github.com/dotnet/efcore/issues/27306) - [Support sequence key generation on SQL Server, which is useful for Table-per-concrete-type (TPC) mapping](https://redirect.github.com/dotnet/efcore/issues/28096) - [Allow null connection string to be passed to UseProvider methods](https://redirect.github.com/dotnet/efcore/issues/26869) - [Downgrade the ContextInitialized event from Information to Debug](https://redirect.github.com/dotnet/efcore/issues/28480) - [Get an EntityEntryConfiguration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.