dotnet/efcore v9.0.0 on GitHub

Release

What's Changed

Update branding to 9.0-alpha1 by @wtgodbe in #31465
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31467
Bump Microsoft.AspNetCore.Identity.EntityFrameworkCore from 7.0.9 to 7.0.10 by @dependabot in #31461
Bump Microsoft.Azure.Cosmos from 3.35.2 to 3.35.3 by @dependabot in #31463
Bump Microsoft.AspNetCore.OData from 8.2.0 to 8.2.1 by @dependabot in #31462
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31474
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31483
Fixes and improvements to StartsWith/EndsWith/Contains by @roji in #31482
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31421
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31499
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31509
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31510
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31512
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31516
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31523
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #31524
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31526
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31528
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31542
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #31566
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31575
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31582
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31598
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31601
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #31624
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31632
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31635
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31636
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31560
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31640
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31641
Add readme file for nuget package EFCore.Tools by @lyndaidaii in #30470
Add readme for EFcore.Desgin NuGet package by @lyndaidaii in #30471
Add readme for sql server by @lyndaidaii in #30466
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31648
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31649
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31650
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31654
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31660
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31667
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31668
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31670
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31671
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31674
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31669
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31678
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31686
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31690
Update SDK version by @sebastienros in #31693
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31698
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31699
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31701
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31706
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31708
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31719
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31715
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31723
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31728
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31734
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31737
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31745
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31747
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31748
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31738
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31756
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31759
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31761
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31762
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31763
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31765
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31766
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31769
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31772
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31774
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31775
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #31786
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31794
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31795
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31797
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31798
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31802
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31803
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31805
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31800
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31809
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31812
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31815
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31816
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31820
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31823
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31824
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31825
Fix to #31448 Use token for NonQueryResultAsync by @dsgordeev in #31449
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31852
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31874
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31877
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31879
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #31880
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31883
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31893
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31899
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31900
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31902
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31907
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31908
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31909
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31911
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31914
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31918
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31919
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31920
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31921
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31924
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31925
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31927
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31929
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31931
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31932
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31935
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31940
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31944
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31955
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31958
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31959
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31963
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31971
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31973
Remove quirks from main by @ajcvickers in #31976
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31980
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31992
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #31995
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32001
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32011
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32024
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32034
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32000
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32044
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32050
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32054
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32057
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32060
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32074
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32081
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32096
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32106
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32118
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32125
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32132
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32133
[main] Fix to #32023 - Case expressions may only be nested to level 10 when using SplitQuery() or ToList() inside projection. by @maumar in #32094
[main] Fix to #32062 - Altering a nullable column to not null generates invalid SQL commands for migration by @maumar in #32102
Bump Azure.Identity from 1.10.2 to 1.10.3 by @dependabot in #32139
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32153
Change IStateManager.StartTrackingFromQuery to use ISnapshot instead of ValueBuffer by @AndriySvyryd in #32099
Use OrderedDictionary or Dictionary instead of SortedDictionary in RuntimeModel by @AndriySvyryd in #32124
Make SQL CLR optional for running EF tests by @ajcvickers in #32143
Add a logo by @bricelam in #32156
SqlServer: Fix FreeText parameter type mapping by @bricelam in #32163
Fix failing tests by @bricelam in #32164
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32162
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32175
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32177
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32182
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32183
Bump Microsoft.Data.SqlClient from 5.1.1 to 5.1.2 by @dependabot in #32187
Bump Microsoft.Azure.Cosmos from 3.35.4 to 3.36.0 by @dependabot in #32188
Bump Microsoft.AspNetCore.Identity.EntityFrameworkCore from 7.0.12 to 7.0.13 by @dependabot in #32189
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32195
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32200
Update DailyBuilds to indicate build to use for EF8 by @ajcvickers in #32210
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32211
Refactor out the baselines for CSharpRuntimeModelCodeGeneratorTest by @AndriySvyryd in #32196
Allow to ignore attributes when finding type mapping by @AndriySvyryd in #32193
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32226
Take into account Contains item visitation in SqlNullabilityProcessor by @roji in #32214
Visit arguments in QueryableMethodNormalizingExpressionVisitor after converting List.Contains by @roji in #32219
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32232
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32236
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32240
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32241
Replace explicit richCodeNavigationEnvironment in azure-pipelines-richnav.yml by @akoeplinger in #32082
Revert to latest public preview of the .NET SDK by @bricelam in #32203
Scaffolding: Handle unknown computed column SQL in model factory by @bricelam in #32251
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32247
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32254
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32262
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32268
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32281
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32282
Temporal table migrations refactor. by @maumar in #32239
Improve some exception messages. by @AndriySvyryd in #32260
Remove quirks by @ajcvickers in #32292
Add more tests for ConventionSet and fix the found issues. by @AndriySvyryd in #32220
Make ModelBuilderTest asserts more robust and extensible by @AndriySvyryd in #32221
Update to .NET 8 GA by @bricelam in #32298
Adjust test class names and namespaces by @AndriySvyryd in #32289
Add primitive collection regression test by @roji in #32330
Fix to #29902 - Renaming PeriodStart and PeriodEnd columns of a temporal table causes them to be swapped by @maumar in #32328
Rename solution to EFCore.sln by @roji in #32344
Do extra processing for init-only fields by @ajcvickers in #32342
Make ILazyLoader not IDisposable by @ajcvickers in #32345
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32356
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32357
Bump Microsoft.AspNetCore.Identity.EntityFrameworkCore from 7.0.13 to 8.0.0 by @dependabot in #32362
Don't throw when attempting to load from a newly Added entity with unknown FK values by @ajcvickers in #32343
Make default value '{}' for non-nullable JSON columns by @roji in #32354
Bump Azure.Identity from 1.10.3 to 1.10.4 by @dependabot in #32361
Fix typos, doubled words by @petterh in #32372
Move compiled model tests to EFCore.Specification.Tests by @AndriySvyryd in #32341
Fix to #32154 - Convert_regular_column_of_temporal_table_to_sparse failing by @maumar in #32370
[automated] Merge branch 'release/7.0' => 'main' by @dotnet-maestro-bot in #32379
Stop keeping a reference to the model in LazyLoader instances and the Castle interceptor by @ajcvickers in #32388
Correctly parse JSON from string by @ajcvickers in #32393
Do nameof() over DateOnly instead of DateTime by @roji in #32415
Allow empty inline collections by @roji in #32414
Handle shadow navigations when loading with split queries by @ajcvickers in #32396
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32420
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32421
Implement EF.Constant by @roji in #32412
Translations to LEAST/GREATEST, Math.Min/Max by @roji in #32338
Remove no-longer-needed unwrapping of AsQueryable by @roji in #32429
Implement EF.Parameter by @roji in #32427
Add method postfix when rewriting parameters for StartsWith/EndsWith/Contains by @roji in #32433
Fix to #27844 - EF Core 6.0 temporal table migration when altering computed column not generating correct script by @maumar in #32398
Create correct JSON reader/writer for double nested value conversions by @ajcvickers in #32444
Switch to HashSet in LazyLoader by @AndriySvyryd in #32445
Add missing ConfigureAwait(false) on await foreach by @roji in #32450
Allow ignored key values for fixup before saving using TPT by @ajcvickers in #32439
Visit inside InlineQueryRootExpression in nav expansion by @roji in #32460
Cosmos: Generate ordinal values for key properties that used not to be persisted. by @AndriySvyryd in #32469
Update DailyBuilds.md for EF9 by @AndriySvyryd in #32470
Use current value in update pipeline when original value is not being tracked by @ajcvickers in #32480
Fix expression cloning when table changes in SelectExpression.VisitChildren by @roji in #32456
Attempt to reduce flakiness in ExecuteReader_throws_when_busy tests by @ajcvickers in #32501
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32508
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32511
Infer type mapping suitable for concatenating two results by @ajcvickers in #32510
Fix Contains within SQL Server aggregate functions by @roji in #32478
Revert behavior to throw when attempting to modify an unconstrained alternate key property by @ajcvickers in #32492
Update Grpc.AspNetCore by @ajcvickers in #32500
Make proxies thread-safe accessing a navigation once loaded by @ajcvickers in #32522
Allow specifying Assembly for migrations by @davidnajar in #32473
Move ModelBuilding tests to EFCore.Specification.Tests by @AndriySvyryd in #32530
Add DbContextOptions composibility support by @AndriySvyryd in #32518
Fix splitting migrations SQL by GO by @ajcvickers in #32548
Test new sqlite3mc SQLitePCLRaw bundle by @ajcvickers in #32562
Allow the last DbContext to be registered to use nongeneric options by @AndriySvyryd in #32569
Fix to #1015 - Remove QueryBugsTest class by @maumar in #32542
Ensure that, by convention, dependent properties have the same element type as principal properties by @ajcvickers in #32560
Don't consider a generated value stable just because it was explicitly set by @ajcvickers in #32497
Stop re-using the same connection when running test queries in parallel by @ajcvickers in #32580
Ensure connection and commands can be disposed in either order by @ajcvickers in #32581
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32585
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32586
Revert the nongeneric DbContextOptions registration by @AndriySvyryd in #32579
Improve the relationship cycle breaking logic to detect cycles even when not starting on one. by @AndriySvyryd in #32573
Generate more information when failing to load EntityTypeConfiguration types by @ajcvickers in #32577
Validate scaffolding migration file names by @ajcvickers in #32589
Fix some API docs by @AndriySvyryd in #32594
Fix relationship cycle breaking logic in CSharpRuntimeModelCodeGenerator. by @AndriySvyryd in #32593
Pass 'OBJECT' to sp_rename when renaming a table or sequence by @ajcvickers in #32599
Update target framework to reflect reality by @ErikEJ in #32602
Check value converter configuration source when setting element type by @AndriySvyryd in #32600
Scaffolding Change -d option to -m, since -d no longer works by @ajcvickers in #32606
Fix concurrency issues with SQLite pooling by @ajcvickers in #32615
Update screenshot used in DailyBuilds.md by @Tim-Maes in #32604
Update developer docs for building packages and using developer build config by @ajcvickers in #32597
Microsoft.Data.Sqlite: Check error code when binding parameters by @ajcvickers in #32613
Generate the correct type in snapshot when a property has a value converter by @AndriySvyryd in #32619
Allow to configure Cosmos without specifying connection details. by @AndriySvyryd in #32620
Don't detect join table with other incoming references as a simple join table by @ajcvickers in #32627
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32635
Don't keep join entity type around because a ForeignKeyAttribute used to reference it. Instead, remove it and reattach the configuration. by @AndriySvyryd in #32640
Make ITableMappingBase.IncludesDerivedTypes null if there are no derived types by @AndriySvyryd in #32628
Allow generated class members to have same name as generated classes when casing differs by @ajcvickers in #32629
Additional testing transforming the database model to the IModel that will then be used for scaffolding by @ajcvickers in #32631
Singulaize before checking for CSharp name conflicts by @ajcvickers in #32641
Microsoft.Data.Sqlite: Don't assume nullabilty or uniqueness of projected columns by @ajcvickers in #32648
Refactor queryable collection support for non-relational providers by @roji in #32506
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32670
Redo SQL tree pruning by @roji in #32672
Track prunability of inner joins on the expression itself by @roji in #32674
Tiny cleanup in SelectExpression.ApplyPredicate by @roji in #32688
Prune SQL Server OPENJSON's WITH clause by @roji in #32673
Clean up and open table cloning logic by @roji in #32665
Fix to #32570 - Test/Cleanup: some adhoc tests that are provider only… because hardcoded column types etc can be moved from provider to relational/core by @maumar in #32706
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32696
Test for navigation naming from composite FK names by @ajcvickers in #32711
[automated] Merge branch 'release/6.0' => 'main' by @dotnet-maestro-bot in #32713
[automated] Merge branch 'release/7.0' => 'main' by @dotnet-maestro-bot in #32714
Preserve unicodeness and fixed-lengthiness in compiled model. by @AndriySvyryd in #32662
Upgrade the snapshot when rolling back to a migration from a previous version by @AndriySvyryd in #32690
Fix T4 files for VS 17.8 by @AndriySvyryd in #32651
Break up KeyDiscoveryConvention by @AndriySvyryd in #32650
Add a note about testing on non en-US by @ajcvickers in #32726
Automatic use of C# primary constructors by @roji in #32509
Automatic use of C# collection initializers by @roji in #32736
Produce uncorrelated IN for Contains with nullable item by @roji in #32575
Microsoft.Data.Sqlite: Cleanup when error occurs on dispose. by @ajcvickers in #32605
Fix complex assignment operator handling in LinqToCSharpSyntaxTranslator by @roji in #32715
Add --disable-build-servers to bundle command by @ajcvickers in #32737
[automated] Merge branch 'release/6.0' => 'main' by @dotnet-maestro-bot in #32758
[automated] Merge branch 'release/7.0' => 'main' by @dotnet-maestro-bot in #32759
Correct SQL Server Take(0) compensating logic by @roji in #32768
[automated] Merge branch 'release/6.0' => 'main' by @dotnet-maestro-bot in #32769
[automated] Merge branch 'release/7.0' => 'main' by @dotnet-maestro-bot in #32774
Fix typos on DeleteBehavior.cs by @EngincanV in #32781
Handle updating complex type properties in ExecuteUpdate by @roji in #32499
Fix test baseline due to bad merge by @roji in #32789
Fix IncludeExpression pruning for nested owned entities in ExecuteUpdate/Delete by @roji in #32773
Don't discover DbFunctions when building ad-hoc model by @ajcvickers in #32790
Redo SQL table alias management by @roji in #32785
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32825
Bump SQLitePCLRaw.core from 2.1.7-pre20231117161811 to 2.1.7 by @dependabot in #32832
Bump SQLitePCLRaw.bundle_sqlite3 and SQLitePCLRaw.core by @dependabot in #32829
Bump SQLitePCLRaw.bundle_winsqlite3 and SQLitePCLRaw.core by @dependabot in #32830
Bump SQLitePCLRaw.bundle_winsqlite3 from 2.1.7-pre20231117161811 to 2.1.7 by @dependabot in #32833
Bump SQLitePCLRaw.bundle_e_sqlite3mc from 2.1.7-pre20231117161811 to 2.1.7 by @dependabot in #32834
Update SqlClient dependency by @ajcvickers in #32842
[automated] Merge branch 'release/6.0' => 'main' by @dotnet-maestro-bot in #32843
[automated] Merge branch 'release/7.0' => 'main' by @dotnet-maestro-bot in #32844
[TINY/TESTONLY] Resolution to #32515 - Query: primitive collection parameters values should reflect the type they are representing by @maumar in #32845
Add back some methods to the compiled model that are used for customization by @AndriySvyryd in #32805
Make AdHocMapper and RelationalAdHocMapper public by @ajcvickers in #32839
Stop stripping new lines from migration script literals by @ajcvickers in #32788
Redo query column/table relationship without TableReferenceExpression by @roji in #32812
Update daily build screenshot to show a daily build by @ajcvickers in #32856
Update to the latest non-preview SDK by @AndriySvyryd in #32859
Make TableExpressionBase.Alias immutable by @roji in #32815
Move all pruning code to the pruner and make it an immutable visitor by @roji in #32817
Bubble up nullability for IN+subquery in SqlNullabilityProcessor by @roji in #32849
Fix SelectExpression cloning when client projections are present by @roji in #32824
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32880
Bump SQLitePCLRaw.bundle_e_sqlite3 from 2.1.7-pre20231117161811 to 2.1.7 by @dependabot in #32884
Bump SQLitePCLRaw.bundle_e_sqlcipher from 2.1.7-pre20231117161811 to 2.1.7 by @dependabot in #32883
Stop using System.Transactions in MismatchedKeyTypesSqlServerTest by @ajcvickers in #32886
Handle complex types in GetDatabaseValues by @ajcvickers in #32813
Clear _modificationCommandGraph when returning the context to pool by @AndriySvyryd in #32871
Extract SelectExpression construction out to RelationalQueryableMethodTranslatingEV by @roji in #32877
Rename CheckPropertyBelongsToType to CheckContains by @ajcvickers in #32888
Add complex type mappings to the default relational mappings by @ajcvickers in #32867
Cleanup of TPC handling by @roji in #32891
Stop using case-insensitive comparisons for indexed properties by @ajcvickers in #32899
Update Mono.TextTemplating to new preview package by @ajcvickers in #32895
Use configured default type mappings in ExecuteSql by @AndriySvyryd in #32902
Update branding to preview2 by @wtgodbe in #32912
Use SqlClient 5.2 preview 5 by @ErikEJ in #32918
stackalloc for BytesToDecimal by @Poppyto in #31190
Don't assume that FK of skip navigation is non-null by @ajcvickers in #32920
Updating Microsoft.CodeAnalysis version to 4.8 by @ajcvickers in #32922
Throw for empty strings in primitive collection columns by @ajcvickers in #32924
Generate change-tracking delegates in the compiled model. by @AndriySvyryd in #31443
Microsoft.Data.Sqlite.Core issue with multiple Blob colums by @francopettinari in #32770
Support resetting SQL Server IDENTITY by @roji in #32931
Also catch type initialization errors when attempting to load types that might not exist by @ajcvickers in #32938
Added ToHashSetAsync Extension methods on IQueryable by @wertzui in #32905
Fix incremental builds by @Suchiman in #32860
Revert "Microsoft.Data.Sqlite.Core issue with multiple Blob colums (#32770)" by @ajcvickers in #32945
Fix copy paste typo by @Suchiman in #32951
Fix failing test related to SQL Server identity reseeding by @roji in #32949
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #32954
Stop specifying incorrect column name in snapshot for owned type of generic entity type by @ajcvickers in #32937
Fix typo by @ajcvickers in #32973
NuGet package readme files by @ajcvickers in #32961
Fix daily build selection image. by @ajcvickers in #32975
Fix OPENJSON postprocessing with split query by @roji in #32978
Fix to #32939 - Accidentally using field instead of property for JSON metadata produce hard to understand exception by @maumar in #32966
Cleanup asserts by @btecu in #32968
Fix to #32984 - Query/Test: change query test infra to output SQL whenever we encounter an exception during query execution by @maumar in #33000
Stop throwing eagerly when looking up a ValueGenerator by @ajcvickers in #32930
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33006
FabricBot: Onboarding to GitOps.ResourceManagement because of FabricBot decommissioning by @dotnet-policy-service in #32897
[automated] Merge branch 'release/7.0' => 'main' by @dotnet-maestro-bot in #33019
[automated] Merge branch 'release/6.0' => 'main' by @dotnet-maestro-bot in #33017
Retarget tools to .NET Framework 4.7.2 by @AndriySvyryd in #33028
Fix to #32972 - The database default created by Migrations for primitive collections mapped to JSON is invalid by @maumar in #33039
[automated] Merge branch 'release/7.0' => 'main' by @dotnet-maestro-bot in #33047
Fix to #33004 - Unfulfillable nullable contraints are set for complex types with TPH entities by @maumar in #33052
[TEST ONLY] moving tests for #32972 to relational so we also test SqLite by @maumar in #33050
Small fixes done during EFCore.PG 9.0.0-preview.1 sync by @roji in #33060
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33072
[TEST ONLY] Move AdHoc tests relying on MARS to SqlServer suite by @maumar in #33076
Fix to #32911 - ComplexProperty with AsSplitQuery by @maumar in #33020
[automated] Merge branch 'release/7.0' => 'main' by @dotnet-maestro-bot in #33089
[automated] Merge branch 'release/6.0' => 'main' by @dotnet-maestro-bot in #33090
Add fill factor to keys and unique constraints by @deano-hunter in #32900
New PR: Microsoft.Data.Sqlite issue with multiple Blob colums (Issue #32747) and following Assertion failure in SQLite following Blob column PR (Issue #32944) by @francopettinari in #33111
Fix to #33046 - ArgumentException thrown when building queries involving owned entities mapped with .ToJson() by @maumar in #33110
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33108
Create cgmanifest.json for third-party deliverables by @AndriySvyryd in #33127
Rewrite the funcletizer to support precompiled queries by @roji in #33106
Sanitize parameter names for VB by @roji in #33151
Set ProducesDotNetReleaseShippingAssets property in Publishing.props by @MilenaHristova in #33132
Fixed typo in getting-and-building-the-code.md by @clement911 in #33166
Bump Mono.TextTemplating from 3.0.0-preview-0045-g9b6fc72764 to 3.0.0-preview-0049-g4f33c8d8b1 by @dependabot in #33163
Bump PreReleaseVersionIteration by @dkurepa in #33168
Test migration path generation by @ajcvickers in #32760
Cleanup duplicate tests (same test ID) by @lauxjpn in #33185
32943-Sugar for HierarchyId path generation by @Rezakazemi890 in #33062
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33159
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #32916
Fix to #33183 - Complex property causes "The multi-part identifier "xxx" could not be bound" after GroupBy + Select(x => x.First()) by @maumar in #33197
Additional test for #32911 plus a small code correction by @maumar in #33200
Add OptimizeContext MSBuild target that runs on build by @AndriySvyryd in #33049
33196 command timeout allow zero by @SteSinger in #33198
Another tiny fix to #32911 by @maumar in #33213
Fix inferred mapping application on Sqlite JsonEachExpression by @roji in #33209
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33230
Minor test cleanup by @roji in #33233
API review changes by @AndriySvyryd in #33221
Bump Microsoft.AspNetCore.Identity.EntityFrameworkCore from 8.0.0 to 8.0.2 by @dependabot in #33235
Bump Microsoft.Data.SqlClient from 5.2.0-preview5.24024.3 to 5.2.0 by @dependabot in #33236
Bump Microsoft.AspNetCore.OData from 8.2.3 to 8.2.5 by @dependabot in #33237
Update dependencies by @AndriySvyryd in #33239
Fix MemberExpression funcletization by @roji in #33241
Split public pipeline definition by @AndriySvyryd in #33250
Remove non-public logic from public pipeline by @AndriySvyryd in #33255
Add quotability to all SQL expression types by @roji in #33210
[automated] Merge branch 'release/7.0' => 'main' by @dotnet-maestro-bot in #33254
[automated] Merge branch 'release/6.0' => 'main' by @dotnet-maestro-bot in #33249
Turn on NRT by default in specification tests by @roji in #33278
Stop doing rogue execution in query tests by @ajcvickers in #33281
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33286
Update MSBuild dependencies by @AndriySvyryd in #33275
Update tsaoptions.json for EF/Data notifications to new alias by @SamMonoRT in #33273
Onboard the official build to 1ES pipeline templates by @AndriySvyryd in #33276
Tiny simplification in funcletizer by @roji in #33284
Revert "Scaffolding Change -d option to -m, since -d no longer works (#32606)" by @ajcvickers in #33282
Forcibly sets "en-US" locale. by @cincuranet in #33291
1ES PT auto-baselining by @AndriySvyryd in #33298
Pass full exception rather than just message for TypeLoadingErrorWarning by @ajcvickers in #33295
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #33302
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #33317
Extract type mapping postprocessing to an external visitor by @roji in #33308
Add IEntityType.IsAdHoc by @AndriySvyryd in #33312
Explicitly mark EFCore.Specification.Tests as shipping by @AndriySvyryd in #33321
Update .NET SDK to 9.0.100-preview.2.24157.14 by @AndriySvyryd in #33323
Discover the compiled model automatically by @AndriySvyryd in #33148
[release/6.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #33325
Fix missing type mapping for CONVERT by @cincuranet in #33311
Use the final 1ES images by @AndriySvyryd in #33324
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33333
Change Where_math(f)_log_new_base queries, so they fail if LOG() parameters are swapped by @lauxjpn in #33342
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33344
[release/7.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #33348
update branding to preview4 by @maumar in #33366
Green prompt "identifier" (similar to Python's venv). by @cincuranet in #33361
Enforce dot sourcing. by @cincuranet in #33363
Consistent and idiomatic casing/formatting. by @cincuranet in #33362
[release/7.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #33374
[release/7.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #33376
Turn off autobaselining as it's interfering with runs on the servicing branches by @AndriySvyryd in #33379
Update TSA owner and external packages by @AndriySvyryd in #33380
Fix NRT directives in tests by @ajcvickers in #33387
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33390
Make Cosmos provider throw for sync I/O by @ajcvickers in #33386
Configure the guardian baseline path by @AndriySvyryd in #33398
Fix key generation validation for TPC. by @cincuranet in #33371
Return flattened properties of complex types in correct order by @ajcvickers in #33393
Correct value type in hard-coded migrations test by @ajcvickers in #33404
Disable Cosmos test failing on C.I. by @ajcvickers in #33405
API review changes by @roji in #33388
Only use length-based sized type inference for string concat by @ajcvickers in #33403
Apply fill factor when creating tables by @ajcvickers in #33407
Centralize and clean up diagnostic IDs by @roji in #33415
API review changes by @roji in #33420
Refactor OperationTaskBase to derive from ToolTask by @AndriySvyryd in #33367
Detect ambiguous InversePropertyAttribute on collection navigations. by @AndriySvyryd in #33434
Fixes around identifier and type mappings for ValuesExpression by @roji in #33439
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33448
Bump Microsoft.Azure.Cosmos from 3.36.0 to 3.38.1 by @dependabot in #33238
Fix documentation comment about ShouldConvertToInlineQueryRoot by @cincuranet in #33455
Update branding to 7.0.19 by @vseanreesermsft in #33461
[release/7.0] [CG] Update Azure.Identity by @maumar in #33349
Update branding to 6.0.30 by @vseanreesermsft in #33460
[release/6.0] Update EOL OS versions by @richlander in #33355
[release/6.0] [CG] Update Microsoft.Azure.Cosmos by @AndriySvyryd in #33356
[release/7.0] Onboard the official build to 1ES pipeline templates by @AndriySvyryd in #33304
[release/6.0] Onboard the official build to 1ES pipeline templates by @AndriySvyryd in #33303
Stop eagerly throwing when setting value generation strategy by @ajcvickers in #33457
Fix funcletizer for VisitListInit by @cincuranet in #33466
Consolidate primitive collections across relational and Cosmos by @ajcvickers in #33456
Handle private properties in the compiled model by @AndriySvyryd in #33409
chore: remove repetitive words by @kindhuge in #33471
Update CODEOWNERS by @SamMonoRT in #33322
Fix docs/names by @cincuranet in #33475
Add the VMR configuration file by @jkoritzinsky in #33480
List as inline collections implementation. by @cincuranet in #33476
Use CreateContainerIfNotExistsAsync on the Cosmos SDK to be compatible with RBAC by @ajcvickers in #33473
Debug messages intended for shadow properties should not be logged for indexer properties by @ajcvickers in #33488
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33492
Support GroupBy over complex type by @roji in #33493
Merging internal commits for release/7.0 by @vseanreesermsft in #33501
Merging internal commits for release/6.0 by @vseanreesermsft in #33500
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #33503
[release/7.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #33507
[release/6.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #33511
Make sure table name inferred from DbSet name is has proper length based on maximum length for identifiers. by @cincuranet in #33513
Introduce liftable constants to shaper to prepare for precompilation by @maumar in #33351
Small fix to IInjectableService and lazy loading that removes constants of ParameterBindingInfo objects by @maumar in #33534
Various fixes for issues in efcore-in-VMR build by @jkoritzinsky in #33540
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33537
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33391
Fix parameter names for nested types in complex type equality by @roji in #33527
Transform JSON_VALUE() to OPENJSON/WITH for binary/varbinary by @roji in #33440
Update DotNetBuild.props by @ViktorHofer in #33551
Use placeholder value to fix CredScan by @akoeplinger in #33550
InMemoryTable: Make IsConcurrencyConflict() method more readable by @y0ung3r in #33561
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33586
Fix string.Length translation after SqlQuery by @cincuranet in #33580
TINY: Reference analyzers project as usual under R#/Rider by @roji in #33587
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33588
update branding to preview5 by @maumar in #33595
Annotate most of the Cosmos query pipeline for NRTs by @roji in #33584
Improve formatting by @cincuranet in #33594
disabling flaky cosmos test by @maumar in #33601
[SMALL/TEST ONLY] Fix to #33590 - Test ordering issue by @maumar in #33609
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33631
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33632
Implement precompiled queries by @roji in #33297
Remove temporary properties created by ForeignKeyPropertyDiscoveryConvention if they aren't used. by @AndriySvyryd in #33611
Only build the model once and cache the (non)runtime one in the same pass. by @AndriySvyryd in #33642
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33648
Various code cleanup/styling for Cosmos query pipeline by @roji in #33637
Make RelationalModel lazy by @AndriySvyryd in #33650
Update branding to 8.0.6 by @vseanreesermsft in #33659
[release/8.0] Don't generate a discriminator in the snapshot if there's no discriminator property. by @AndriySvyryd in #33622
[release/8.0] Fix parameter names for nested types in complex type equality (#33527) by @roji in #33548
Update branding to 6.0.31 by @vseanreesermsft in #33657
Update branding to 7.0.20 by @vseanreesermsft in #33658
Normalize .Count != 0 to Any() in preprocessing by @roji in #33654
Support hierarchical partition keys in Cosmos provider by @ajcvickers in #33536
Pregenerate SQL for precompiled queries by @roji in #33510
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #33660
[TEST ONLY] disabling another flaky test on cosmos by @maumar in #33669
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33681
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33682
Fix to #33678 - TimeOnly.FromDateTime() could not be translated in EF Core 8 by @maumar in #33689
Fix to #33547 - 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. by @maumar in #33559
[release/8.0] Fix to #33547 - 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. by @maumar in #33692
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33708
Refactor compiled models MSBuild integration. by @AndriySvyryd in #33700
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33707
Merging internal commits for release/8.0 by @vseanreesermsft in #33717
Bump Microsoft.Azure.Cosmos from 3.38.1 to 3.39.1 by @dependabot in #33711
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #33694
Correctly initialize design-time relational model for externally built models by @AndriySvyryd in #33719
[release/8.0] Update CODEOWNERS by @AndriySvyryd in #33744
Update branding to 8.0.7 by @vseanreesermsft in #33737
[release/8.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #33760
[TINY] Move all query translators into their own folders by @roji in #33755
Bump Microsoft.Azure.Cosmos from 3.39.1 to 3.40.0 by @dependabot in #33767
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33764
Remove invalid optimization of CASE-WHEN expressions by @ranma42 in #33754
update branding for preview 5 by @maumar in #33777
Publish binaries for BinSkim by @AndriySvyryd in #33786
Bump SQLitePCLRaw from 2.1.7 to 2.1.8 by @AndriySvyryd in #33790
Simplify TRUE = expr in filtering contexts by @ranma42 in #33776
Re-enable GroupBy_aggregate_where_required_relationship by @ranma42 in #33806
Clean up query translator/expression namespace and file placement by @roji in #33782
Enable SQL baseline rewriting for Cosmos by @roji in #33808
Bump SQLitePCLRaw.core from 2.1.7 to 2.1.8 by @dependabot in #33824
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33820
Skip Sqlite functional tests on MacOs by @AndriySvyryd in #33809
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33821
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #33746
SQLite: implement sum and average aggregation for decimal by @ranma42 in #33721
Check arity consistency when constructing SqlFunctionExpressions by @ranma42 in #33815
Implement nullability computation for SqlFunctionExpression by @ranma42 in #33814
Call NuGetAuthenticate after SetupNuGetSources by @mmitche in #33846
re-enabling sqlite tests on macos now that ci was updated by @maumar in #33832
Update to SDK 9.0.100-preview.4.24267.66 by @AndriySvyryd in #33840
Disable source indexing by @AndriySvyryd in #33841
Update Azure.Identity by @AndriySvyryd in #33842
Output test logging for query tests only on error by @roji in #33819
Pass sequence annotations (#33780) by @Sielnix in #33804
Fix comparison of nullable values by @ranma42 in #33757
Improve error message by @cincuranet in #33851
Update Cosmos testing actions by @AndriySvyryd in #33865
Re-enable fixed tests by @ranma42 in #33871
Fix SQL Server operator precedence table by @ranma42 in #33875
Translate logical Boolean operators as conditional Boolean operators by @ranma42 in #33873
Fix and enable Bitwise_and_on_expression_with_like_and_null_check_being_compared_to_false by @ranma42 in #33872
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33879
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33880
Bump Microsoft.Data.SqlClient from 5.2.0 to 5.2.1 by @dependabot in #33882
Fix to #33443 - JSON path is not properly formatted by @maumar in #33771
Fix optimization of CASE op WHEN by @ranma42 in #33869
Minor improvement of SqlServerParameterBasedSqlProcessor.Optimize by @ranma42 in #33758
[SMALL] Fix to #33886 - Query/Json: additional small fixes for JSON escaping by @maumar in #33888
Fix unhex() nullability by @ranma42 in #33870
Translate ToString() over enums by @Danevandy99 in #33706
Set publishAssetsImmediately on post-build by @mmitche in #33768
Various stuff from EFCore.PG JSON work by @roji in #32255
Work on Cosmos primitive collections, subquery and general query infra by @roji in #33895
Clean up container management in Cosmos by @roji in #33898
SQL Server: add support for object in SqlServerConvertTranslator by @imangd in #33891
Revert broken validation for JSON properties with no JsonValueReaderWriter by @roji in #33908
Cosmos: use ReadItem for more Find cases by @ajcvickers in #33896
Remove unneeded Cosmos 3-value logic compensation for InExpression by @roji in #33899
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #33902
Cosmos: translate Contains over subquery by @roji in #33905
Update FTS baselines by @ajcvickers in #33915
Generate KeyValueFactory and related instances in the compiled model. by @AndriySvyryd in #33887
OTEL implementation, so far matching EventCounters infrastructure. by @cincuranet in #33633
Enable internal feed and runtime usage via templates by @mmitche in #33919
Add precompiled query generation to the dbcontext optimize command by @AndriySvyryd in #33747
Fix SQL Server translation of IndexOf by @ranma42 in #33876
Add missing check for predicate in primitive collection simplifications by @roji in #33933
Implement translation of HashSet (and ICollection in general) to OPENJSON query by @cincuranet in #33920
[release/8.0] Add missing check for predicate in primitive collection simplifications by @roji in #33939
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #33949
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #33951
Simplify NOT (CASE ... THEN const) by pushing NOT into the THEN/ELSE by @ranma42 in #33934
Cosmos: Translate string.Contains/StartsWith/EndsWith with OrdinalIgnoreCase by @roji in #33936
Remove optimization of NOT(a != b) by @ranma42 in #33943
Fix UpdateExpression.VisitChildren to visit the setter column by @roji in #33948
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #33944
Fix to #33073 - JSON columns throws Invalid token type: 'StartObject' exception with AsNoTrackingWithIdentityResolution() by @maumar in #33101
Cosmos: work on Skip/Take, undefined by @roji in #33935
Use TokenCredential for Cosmos tests by @AndriySvyryd in #33956
Translate non-aggregate string.Join to CONCAT_WS on SQL Server by @roji in #28900
When creating the "missing column" error message, use the same (case insensitive) column name comparer used in field value retrieval by @simonmckenzie in #33749
[release/8.0] Use TokenCredential for Cosmos tests by @AndriySvyryd in #33966
Run Cosmos tests as a separate step by @AndriySvyryd in #33974
Fix exception assertions in Cosmos tests by @roji in #33984
Fix for #33702 Translation for the SQL Server PATINDEX function by @smnsht in #33868
Avoid division by decimal 0 in SQLite by @ranma42 in #33989
Cosmos: add translations for date/time components by @roji in #33976
[release/8.0] Skip Cosmos tests by @AndriySvyryd in #33988
Use ARM to create containers for Cosmos tests. by @AndriySvyryd in #33994
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #33973
Support ReadItem for no-tracking queries by @ajcvickers in #33927
Cosmos: Fix Project_multiple_collections by @AndriySvyryd in #34003
Bump Microsoft.Azure.Cosmos from 3.40.0 to 3.41.0 by @dependabot in #34012
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34006
Improve some null-related tests by @ranma42 in #34019
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34031
Generate Accessors for shadow properties and columns by @AndriySvyryd in #33996
Cosmos querying over arrays of structural type by @roji in #33998
Cosmos: Implement SelectMany by @roji in #34013
Disable startup assembly support for MSBuild integration by @AndriySvyryd in #34034
TrimStart and TrimEnd with optional char array implementation for SQL Server by @abdielcs in #33715
update branding for preview 6 by @maumar in #34043
Changes and tests for Cosmos type mapping by @ajcvickers in #34042
Stop generating includes in nav expansion for primitive collection properties by @roji in #34047
Cosmos: Minor refactoring of array extraction/conversion as extension methods (trivial) by @roji in #34045
fixing cosmos test failures on linux (#34058) by @maumar in #34059
Some code cleanup/style by @roji in #34062
Optimize away Coalesce for trivial cases by @ranma42 in #34002
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34075
Implement translation for XOR by @ranma42 in #34071
Small: Report cross-document join exception on Cosmos, and some test cleanup by @roji in #34066
Fix build regression from #34002 by @ranma42 in #34078
Cosmos: Fixes around array projection by @roji in #34061
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34077
FromSql work by @roji in #34065
Onboard new inter-branch merge flow [Configuration] by @f-alizada in #34050
Onboard new inter-branch merge flow [Workflow] by @f-alizada in #34051
[automated] Merge branch 'release/8.0' => 'main' by @dotnet-maestro-bot in #34089
Simplify and improve null semantics rewrites by @ranma42 in #34072
Update getting-and-building-the-code.md by @ErikEJ in #34100
SQL Server: Use XOR to translate some NOT expressions by @ranma42 in #34080
Enable Max_in_multi_level_nested_subquery test on Sqlite by @ranma42 in #34128
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34131
Implement Cosmos pagination by @roji in #34103
Use using for critical section management everywhere by @roji in #34120
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34132
Simplify COALESCE based on the nullability of its arguments by @ranma42 in #33938
Enable testing of compiled models in CI by @ranma42 in #34111
Enable JSON tests on SQLite without Spatialite by @ranma42 in #34113
Simplify AND and OR by @ranma42 in #34133
[release/8.0] Update image to macOS-12 by @AndriySvyryd in #34037
Update branding to 8.0.8 by @vseanreesermsft in #34141
SQL Server: use XOR to translate some == and != expressions by @ranma42 in #34124
Simplify NOT by @ranma42 in #34142
Index convention changes for non-relational providers by @ajcvickers in #34054
Implement Cosmos alias management by @roji in #34074
Pack of minor Cosmos changes by @roji in #34143
Some minor Cosmos cleanup by @roji in #34155
Cosmos: Stop generating discriminator clause when not needed by @roji in #34145
Improve String_Contains_Column test by @ranma42 in #34174
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34185
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34186
Don't use service discovery for DbContext types if corresponding IDesignTimeDbContextFactory implementations are found. by @AndriySvyryd in #34082
Fix for #34117, Improve Hash Code Distribution for RelationalCommandCache Keys by @ADNewsom09 in #34118
Add UnsafeAccessor support for generic types by @AndriySvyryd in #34146
Merging internal commits for release/8.0 by @vseanreesermsft in #34191
Cosmos: Redo ReadItem and partition key management by @roji in #34187
SQL Server: Use XOR to translate more == and != expressions by @ranma42 in #34168
Lock the database while executing Migrate() by @AndriySvyryd in #34115
[release/8.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34209
Enable internal runtime downloads via dSAS by @mmitche in #34217
Implement CASE flattening optimizations by @ranma42 in #34175
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34226
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34225
Explicitly mark EFCore.Relational.Specification.Tests as shipping by @AndriySvyryd in #34228
Up SAS timeout to 3 hours by @mmitche in #34229
Fix Nullable<T>.ToString() by @ranma42 in #34014
Fix Nullable<bool>.ToString() conversion by @ranma42 in #33940
Update Helix pools by @AndriySvyryd in #34231
Revert "impements #11261 sequence cache support" for 9.0 by @ajcvickers in #34240
API review updates by @ajcvickers in #34241
Cosmos: Stop nesting results in extra JSON object by @roji in #34044
Generate suppressible error when entity saved to Cosmos without PK value set by @ajcvickers in #34250
Cosmos: error on operator ordering that requires pushdown by @roji in #34255
Move ExecuteUpdate/ExecuteDelete to core so non-relational providers can implement by @ajcvickers in #34257
Enabled key converter tests for Cosmos by @ajcvickers in #34249
Throw (suppressible) for common concrete collection types mapped as entity types by @ajcvickers in #34264
LEAST/GREATEST nullability work by @roji in #32458
update branding for preview7 by @maumar in #34275
Better reporting for query cache hits and misses for OTEL. by @cincuranet in #34267
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34268
Implement nullability simplification for COLLATE and AT TIME ZONE by @ranma42 in #34263
Execute migrations using the ExecutionStrategy by @AndriySvyryd in #34206
Fix build break by @ajcvickers in #34306
SQL Server: Use bitwise NOT on BIT expressions by @ranma42 in #34303
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34311
Propagate allowOptimizedExpansion to CASE results by @ranma42 in #34304
Bump Microsoft.Azure.Cosmos from 3.41.0 to 3.42.0 by @dependabot in #34313
SQL Server: transform aggregate functions over subqueries by @roji in #34262
Addressing API review feedback by @maumar in #34321
Fix to #34056 - AOT/Query: for queries with JSON, interceptors generate code with labels that are not uniquified by @maumar in #34323
Block collections of scalars with converters on Cosmos by @ajcvickers in #34307
Block nested primitive collections in relational due to lack of query support by @ajcvickers in #34325
Add missing ConditionalTheory Attribute to Delete_FromSql_converted_to_subquery by @ChrisJollyAU in #34326
Change default compat level to 150 by @ajcvickers in #34319
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34310
Enable TSA reporting by @AndriySvyryd in #34333
Add extension point to Migrate by @AndriySvyryd in #34199
Get partition keys, container name, and JsonIdDefinition from the root entity in the hierarchy by default by @ajcvickers in #34252
Add back support for Cosmos nested dictionaries by @ajcvickers in #34312
Stop including the discriminator in the JSON id by default by @ajcvickers in #34208
Handle projections of nested owned entity in Cosmos by @ajcvickers in #34315
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34360
Don't implement IModelFinalizingConvention on CosmosJsonIdConvention by @AndriySvyryd in #34343
Introduce UseAzureSynapse and UseAzureSql by @cincuranet in #34052
Change default embedded discriminator property from "Discriminator" to "$type" by @ajcvickers in #34340
Promote Json tests to Core so that they can be utilized for Cosmos. by @maumar in #34355
Update branding to 8.0.9 by @vseanreesermsft in #34371
[release/8.0] Update Helix pools by @AndriySvyryd in #34232
[release/8.0] Use placeholder value to fix CredScan by @AndriySvyryd in #34342
fixing cosmos baselines to expect '$type' as the default discriminator name by @maumar in #34383
Fix to #34211 - Issue occurs when trying to generate query string when mapping entity with json to a view with a custom schema by @maumar in #34239
Switch EntityFrameworkMetricsData.Get* methods to internal. These are consumed only by EF. by @cincuranet in #34379
Increase Linux CI timeout to accomodate additional Cosmos testing. by @AndriySvyryd in #34380
Apply primary constructor cleanup everywhere by @roji in #34377
Optimize away DISTINCT inside IN/EXISTS/set operations by @ranma42 in #34381
Fix some Cosmos tests on CI by @AndriySvyryd in #34390
Split UseSqlServer/UseAzureSql/UseAzureSynapse builders by @cincuranet in #34385
[release/8.0] Find the discriminator property even if it is not string by @AndriySvyryd in #34388
New EF.Constant handling by @cincuranet in #34297
Variable rename from #34385. by @cincuranet in #34399
API review updates: by @ajcvickers in #34403
Support vector search on Cosmos DB by @ajcvickers in #33991
[main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34407
[main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34410
API review fixes by @roji in #34408
API review changes from August 12 by @cincuranet in #34415
Context options to control constantization/parameterization of parameterized collections and EF.Parameter improvement collection parameters by @cincuranet in #34406
Translate Order & OrderDescending by @bricelam in #34282
remove redundant (SqlExpression) cast in SqlServerByteArrayMethodTranslator by @SimonCropp in #34418
use collection expressions in SqlServerByteArrayMethodTranslator by @SimonCropp in #34420
use GetValueOrDefault and Remove by @SimonCropp in #34423
Remove migration lock timeout by @AndriySvyryd in #34338
remove SqlServerQueryTranslationPostprocessorFactory _typeMappingSource by @SimonCropp in #34429
Experimental support for the Azure SQL JSON type by @ajcvickers in #34401
Don't generate code for precached values in the compiled model by default by @AndriySvyryd in #34412
Add missing Model Builder API by @AndriySvyryd in #34427
Merging internal commits for release/8.0 by @vseanreesermsft in #34425
[release/9.0-rc1] Fix OptimisticConcurrencyCosmosTest by @AndriySvyryd in #34443
Merge branch 'release/9.0-rc1' => 'release/9.0' by @AndriySvyryd in #34458
[release/9.0-rc1] Update dependencies from dotnet/runtime by @dotnet-maestro in #34461
Fix non-NativeAOT compiled model by @AndriySvyryd in #34455
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34465
[release/9.0-rc1] Update dependencies from dotnet/runtime by @dotnet-maestro in #34471
Update SDK to 9.0.100-preview.7.24407.12 by @AndriySvyryd in #34472
Enable PoliCheck by @AndriySvyryd in #34484
Update Microsoft.Build.Locator by @AndriySvyryd in #34486
[release/9.0-rc1] Update dependencies from dotnet/runtime by @dotnet-maestro in #34488
Code cleanup (4) by @ajcvickers in #34474
(RC2) Persist Id values into owned collection JSON documents by @ajcvickers in #34478
(RC2) (Test only) Code cleanup (Tests) by @ajcvickers in #34490
[release/9.0-rc1] Update dependencies from dotnet/runtime by @dotnet-maestro in #34492
[release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34499
(RC2) Cosmos: strip implicit casts to allow vector search over arrays by @ajcvickers in #34495
(RC2) Fix ESCAPE clause for Azure Synapse. (#34463) by @cincuranet in #34510
Rename some locals by @roji in #34514
[release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34533
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34534
(RC2) (Test only) Fix async void tests by @ajcvickers in #34529
[release/9.0] Make nested generic type generation consistent by @AndriySvyryd in #34537
[release/9.0] Add explicit casts for generated null in method calls. by @AndriySvyryd in #34523
[release/9.0] Properly implement support for Cosmos hierarchical partition keys by @roji in #34560
(RC2) Downgrade to LTS SqlClient by @ajcvickers in #34540
Update branding to 8.0.10 by @vseanreesermsft in #34571
[release/9.0] Always include generated files in the compilation by @AndriySvyryd in #34547
[release/8.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34583
[release/9.0-rc1] Update dependencies from dotnet/runtime by @dotnet-maestro in #34584
[release/9.0] Map directly to JSON id for types converted to string by @ajcvickers in #34577
[release/9.0-rc1] Update dependencies from dotnet/runtime by @dotnet-maestro in #34588
[release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34597
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34598
[release/9.0] Acquire the migrations database lock in a transaction. by @AndriySvyryd in #34489
[release/8.0] Update FK ElementType when the FK properties change. by @AndriySvyryd in #34561
[release/9.0] Generate correct calls for complex and primitive properties in the model snapshot by @AndriySvyryd in #34587
[release/9.0] Update Azure.Identity version by @AndriySvyryd in #34605
[release/9.0] Update Mono.TextTemplating and Microsoft.CodeAnalysis to non-preview versions by @AndriySvyryd in #34606
[automated] Merge branch 'release/8.0' => 'release/9.0' by @github-actions in #34572
[automated] Merge branch 'release/9.0-rc1' => 'release/9.0' by @github-actions in #34497
[release/9.0] Don't remove non-existent foreign keys. by @AndriySvyryd in #34614
[release/9.0] Set shared database throughput when using RBAC in tests by @AndriySvyryd in #34623
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34633
[release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34632
[release/9.0] Take into account store-generated values when ordering update commands by @AndriySvyryd in #34626
[release/9.0] Nominally upgrade Microsoft.Build.Framework to 17.8.3 by @AndriySvyryd in #34636
[release/9.0] Bump Microsoft.Azure.Cosmos from 3.42.0 to 3.43.0 by @AndriySvyryd in #34639
[release/9.0] Update Microsoft.CodeAnalysis.Testing packages to 1.1.2 by @AndriySvyryd in #34648
[release/9.0] Remove referencing indexes when reconfiguring a property as a navigation by @AndriySvyryd in #34640
[release/9.0] Change some JSON Metadata API to respect null values set explicitly. by @AndriySvyryd in #34624
[release/9.0] Fix type mapping management for JsonScalarExpression by @roji in #34663
[release/9.0] Update SDK to 9.0.100-rc.1.24452.12 by @AndriySvyryd in #34669
[release/9.0] Enable Central Package Management by @AndriySvyryd in #34666
branding for rc2 by @maumar in #34690
[release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34687
[release/9.0-rc2] Update dependencies from dotnet/arcade by @dotnet-maestro in #34701
[release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34700
Remove package source mapping and suppress warning by @mmitche in #34711
[release/9.0] Use the correct comparer when sorting relational functions. by @AndriySvyryd in #34712
[release/9.0] Rename IncludeRootDiscriminatorInJsonId to HasRootDiscriminatorInJsonId by @roji in #34717
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34737
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34745
[release/9.0] Disabling a flaky test by @maumar in #34744
[release/9.0] Fix to #34728 - Split query with AsNoTrackingWithIdentityResolution() throws ArgumentOutOfRangeException by @maumar in #34743
[release/9.0] Tools: Fallback to service provider when no context types found by @AndriySvyryd in #34759
[release/9.0] Use the specified migrations assembly in validation by @AndriySvyryd in #34777
[release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34798
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34799
Update branding to 8.0.11 by @vseanreesermsft in #34807
[release/8.0] Remove referencing indexes when reconfiguring a property as a navigation by @AndriySvyryd in #34651
[automated] Merge branch 'release/8.0' => 'release/9.0' by @github-actions in #34808
[release/8.0] Update dependencies by @AndriySvyryd in #34822
[release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34839
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34840
[release/9.0] Don't throw on non-transactional migration operation warning. by @AndriySvyryd in #34830
Merge branch 'release/8.0' into release/9.0 by @AndriySvyryd in #34828
Merge internal flow changes from rc2 by @mmitche in #34855
[release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34879
[release/8.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34880
[release/8.0] Update Microsoft.Extensions.HostFactoryResolver.Sources version by @AndriySvyryd in #34884
[release/9.0] (TELL MODE) small xml doc fix (copy paste error) (#34857) by @maumar in #34888
[release/9.0] Fix conditional test evaluation in funcletizer by @roji in #34886
[release/8.0] Don't execute empty batches by @AndriySvyryd in #34882
[release/9.0] Fix to #34760 - NullReferenceException for a custom ValueConverter in EF Core 9 RC 1. by @maumar in #34894
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34899
[release/9.0] Avoid infinite recursion on identifying shadow FKs by @AndriySvyryd in #34892
[release/8.0] Avoid infinite recursion on identifying shadow FKs by @AndriySvyryd in #34891
[release/9.0] Don't break transactions across batches by @AndriySvyryd in #34869
Merging internal commits for release/8.0 by @AndriySvyryd in #34902
[release/9.0] Nanoseconds and microseconds processing fix on Cosmos by @cincuranet in #34901
[release/9.0] Keep parameter values out IMemoryCache in RelationalCommandCache by @roji in #34907
[automated] Merge branch 'release/8.0' => 'release/9.0' by @github-actions in #34887
[release/8.0] Keep parameter values out IMemoryCache in RelationalCommandCache by @roji in #34908
[automated] Merge branch 'release/8.0' => 'release/9.0' by @github-actions in #34910
[release/9.0] branding for GA - enable stable branding by @maumar in #34909
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34915
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34920
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34924
[release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #34925
[release/9.0] Fix Cosmos enum partition keys by @roji in #34922
[release/9.0] Update dependencies from dotnet/runtime by @dotnet-maestro in #34927
reenable stable package warning by @maumar in #34932

New Contributors

@lyndaidaii made their first contribution in #30470
@dsgordeev made their first contribution in #31449
@akoeplinger made their first contribution in #32082
@petterh made their first contribution in #32372
@davidnajar made their first contribution in #32473
@Tim-Maes made their first contribution in #32604
@EngincanV made their first contribution in #32781
@Poppyto made their first contribution in #31190
@francopettinari made their first contribution in #32770
@wertzui made their first contribution in #32905
@btecu made their first contribution in #32968
@dotnet-policy-service made their first contribution in #32897
@deano-hunter made their first contribution in #32900
@clement911 made their first contribution in #33166
@Rezakazemi890 made their first contribution in #33062
@SteSinger made their first contribution in #33198
@richlander made their first contribution in #33355
@kindhuge made their first contribution in #33471
@jkoritzinsky made their first contribution in #33480
@ViktorHofer made their first contribution in #33551
@y0ung3r made their first contribution in #33561
@Sielnix made their first contribution in #33804
@Danevandy99 made their first contribution in #33706
@imangd made their first contribution in #33891
@simonmckenzie made their first contribution in #33749
@abdielcs made their first contribution in #33715
@f-alizada made their first contribution in #34050
@ADNewsom09 made their first contribution in #34118

Full Changelog: v8.0.5...v9.0.0

dotnet/efcore v9.0.0 .NET 9.0.0 on GitHub

What's Changed

New Contributors

dotnet/efcore v9.0.0
.NET 9.0.0

on GitHub