.NET 10.0 Preview 1

Release

What's Changed

• Update branding to 10.0.0-alpha1 by @AndriySvyryd in #34438
• Fix github-merge-flow by @AndriySvyryd in #34452
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34464
• Add NRT annotations required for the new Newtonsoft.Json version by @AndriySvyryd in #34470
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34460
• Persist Id values into owned collection JSON documents by @ajcvickers in #34466
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34487
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34491
• Cosmos: strip implicit casts to allow vector search over arrays by @roji in #34437
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34496
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34498
• Fix ESCAPE clause for Azure Synapse. by @cincuranet in #34463
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34504
• Use different store names for funky data tests by @cincuranet in #34506
• (RC2) Fix ESCAPE clause for Azure Synapse. (#34463) by @cincuranet in #34509
• Make Discriminator_values_are_not_marked_as_unknown virtual (#34517) by @mianculovici in #34520
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34513
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34531
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34538
• Added a test project for F# functional tests. by @koenigst in #34541
• Properly implement support for Cosmos hierarchical partition keys by @roji in #34557
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34544
• Move back to SqlClient 5.2 on main. by @ajcvickers in #34565
• Map directly to JSON id for types converted to string by @ajcvickers in #34564
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34595
• Various tweaks that came out of PG sync by @roji in #34593
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34581
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34630
• Bump Microsoft.Azure.Cosmos from 3.42.0 to 3.43.0 by @dependabot in #34635
• Remove duplicated docs by @roji in #34642
• Update SQLite libraries to new versions (with WASM on .NET 9 supported). by @cincuranet in #34576
• Fix doc typo by @roji in #34664
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34621
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34684
• Remove unused variable by @ranma42 in #34680
• Enable NuGetAudit by @AndriySvyryd in #34650
• Fix Azure SQL tests by @AndriySvyryd in #34676
• Bump Microsoft.Data.SqlClient from 5.1.6 to 5.2.2 by @dependabot in #34688
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34691
• Move runtime override to tests by @AndriySvyryd in #34535
• Change analyzer references to use the standard/recommended form by @roji in #34596
• Make SqlNullabilityProcessor into a real ExpressionVisitor by @roji in #34697
• Optimize MIN/MAX over DISTINCT by @ranma42 in #34699
• Add all precompiled query tests to the same collection. by @AndriySvyryd in #34692
• Handle view mapping in ExecuteDelete/Update translation by @roji in #34709
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34532
• Fix test and a bit of code cleanup by @roji in #34731
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34734
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34735
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34719
• Bump Microsoft.Azure.Cosmos from 3.43.0 to 3.43.1 by @dependabot in #34740
• Fix to #34728 - Split query with AsNoTrackingWithIdentityResolution() throws ArgumentOutOfRangeException by @maumar in #34742
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34746
• Simplify away NonQueryExpression by @roji in #34768
• Make dotnet-ef build properly on Linux. by @mmitche in #34781
• Update azure-pipelines.yml to fix BinSkim by @SamMonoRT in #34800
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34797
• (Attempt #2) Update azure-pipelines.yml for binskim by @SamMonoRT in #34802
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34795
• Fix: Value cannot be null parameter name key by @salihozkara in #34730
• Reverting the BinSkim target directory by @SamMonoRT in #34813
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34837
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34838
• Optimize DISTINCT over singleton collections by @ranma42 in #34702
• Fix tags for final GroupBy queries by @roji in #34787
• Bump Azure.Identity from 1.12.0 to 1.12.1 by @dependabot in #34844
• Bump Grpc.AspNetCore from 2.59.0 to 2.66.0 by @dependabot in #34845
• Bump Microsoft.AspNetCore.Identity.EntityFrameworkCore from 8.0.2 to 8.0.8 by @dependabot in #34843
• remove repeated IsGenericMethod and GetGenericMethodDefinition in SqlServerByteArrayMethodTranslator by @SimonCropp in #34419
• thoughts on caching argumentsPropagateNullability arrays? by @SimonCropp in #34422
• small xml doc fix (copy paste error) by @maumar in #34857
• Throw when a nested entity type is mapped to a different JSON column. by @AndriySvyryd in #34816
• Update System.Runtime.Caching by @AndriySvyryd in #34865
• Bump Microsoft.AspNetCore.OData from 8.2.5 to 9.0.0 by @dependabot in #34842
• Make sort order consistent in split queries by @ascott18 in #34097
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34770
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34876
• add MariaDB to README.md by @robertsilen in #34885
• Make SQL Server scaffolding compatible with Azure Data Explorer by @barnuri in #34832
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34897
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34898
• Add implementation for Nanoseconds and Microseconds for DateTime[Offset], TimeSpan, {Date|Time}Only. by @cincuranet in #34861
• Keep parameter values out IMemoryCache in RelationalCommandCache by @yinzara in #34803
• Bump Microsoft.AspNetCore.Identity.EntityFrameworkCore from 8.0.8 to 8.0.10 by @dependabot in #34903
• Bump Microsoft.Azure.Cosmos from 3.43.1 to 3.44.0 by @dependabot in #34904
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34890
• Use matching type mapping when translating BoolSwitch by @ranma42 in #34906
• Don't remove quoted 'GO' lines by @AndriySvyryd in #34917
• Rewrite SearchConditionConverter by @roji in #34905
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #34926
• Enable flow to release/8.0-staging and release/9.0-staging by @AndriySvyryd in #34933
• Fix to #34749 - Created query for projection with ownedMany and join is wrong by @maumar in #34858
• Use right hand type mapping for more binary expressions when left is an object by @ChrisJollyAU in #34729
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34945
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34944
• Bump Microsoft.Azure.Cosmos from 3.44.0 to 3.44.1 by @dependabot in #34947
• Bump Azure.Identity from 1.12.1 to 1.13.0 by @dependabot in #34948
• [TINY/CLEANUP] enabling test for scenario that was fixed earlier by @maumar in #34975
• Return the default schema for owned entity types when not mapped to the same table as the owner. by @AndriySvyryd in #34974
• Fix to #34960 - System.Text.Json.JsonReaderException: '0x00' is invalid after a single JSON value. Expected end of data by @maumar in #34969
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #34997
• [TINY] Do not return null namespace for Types by @roji in #34994
• Bump Azure.Identity from 1.13.0 to 1.13.1 by @dependabot in #35001
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #34998
• Use the proper type mapping for the result of AVG by @ChrisJollyAU in #35023
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #35035
• Fix to #34293 - Json: error when trying to materialize json entity with nullable property that is null in the json string - should materialize the property as null instead by @maumar in #35040
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35036
• Fix to #35007 - EF Core fails to translate LINQ query to SQL if JOIN contains multiple columns by @maumar in #35019
• Add requiredness to the debug view for navigations by @AndriySvyryd in #35037
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #35072
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35073
• Updating Cosmos version, including using new public APIs by @ajcvickers in #35074
• Move NonNullableConventionState to CoreAnnotationNames by @ajcvickers in #35020
• Add missing awaits in MigrationsInfrastructureTestBase by @roji in #35106
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #35054
• Update to .NET9 SDK by @SamMonoRT in #35119
• Clean up Cosmos PagingExpression namespace by @roji in #35123
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #35134
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35136
• Partial fix to #35053 - Is EF9 slower than EF8? by @maumar in #35128
• Set to preview by @roji in #35121
• Bump Microsoft.Azure.Cosmos from 3.45.0 to 3.45.2 by @dependabot in #35139
• Bump Microsoft.AspNetCore.OData from 9.0.0 to 9.1.0 by @dependabot in #35141
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #35138
• Fix build with latest roslyn by @am11 in #35149
• Introduce QueryParameterExpression by @roji in #35101
• Bump Microsoft.AspNetCore.Identity.EntityFrameworkCore from 8.0.10 to 9.0.0 by @dependabot in #35140
• Don't remove the annotation in NonNullableConventionBase by @AndriySvyryd in #35151
• Fix contains test by @am11 in #35166
• Bump Cosmos SDK to 3.46.0 by @roji in #35171
• Fix TPC equality check inside subquery predicate by @roji in #35120
• Add missing Converts when simplifying in funcletizer by @roji in #35122
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #35197
• Correct VisitUnary operand evaluation in funcletizer by @roji in #35172
• Bump Grpc.AspNetCore from 2.66.0 to 2.67.0 by @dependabot in #35204
• Bump Microsoft.AspNetCore.OData from 9.1.0 to 9.1.1 by @dependabot in #35205
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35198
• Fix to #35208 - Query/Perf: don't compile liftable constant resolvers in interpretation mode by @maumar in #35209
• Return null when the type is nullable for Cosmos Max/Min/Average by @ajcvickers in #35173
• Fix to #35212 - Query/Perf: Compile identifier lambdas passed to PopulateIncludeCollection rather than inline by @maumar in #35213
• Simplify parameter names by @roji in #35200
• Avoid using ^ and ~ when invalid because of value converters by @ranma42 in #35124
• Fix query filters with context accessors by @cincuranet in #35237
• Handle comparers for nullable value types in primitive collections by @ajcvickers in #35235
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #35249
• Fix Contains on ImmutableArray by @cincuranet in #35247
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35250
• Uniquify all variables used in SQL Server migration scripts by @AndriySvyryd in #35177
• Fix test on newest SQL Server (not run on CI ATM) by @cincuranet in #35254
• Expose SQLite VFS option in connection string by @arontsang in #34864
• Allow SqlFragmentExpression to have a type/type mapping by @roji in #34995
• See how SqlClient 6 runs by @ErikEJ in #35232
• Update instruction for daily builds to 10. by @cincuranet in #35274
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #35256
• Update BinSkim and prefast by @AndriySvyryd in #35272
• Fix to #35108 - Temporal table migration regression from EF Core 8 to 9 by @maumar in #35283
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35301
• [TINY] Fix to #35281 - Migrations: CreateTableBuilder Annotation(string name, object value) should accept object? instead by @maumar in #35297
• [release/9.0-staging] Fix to #35108 - Temporal table migration regression from EF Core 8 to 9 by @maumar in #35289
• Update BenchmarkDotNet by @AndriySvyryd in #35312
• Refactor method/member translation tests into their own suite by @roji in #35319
• Add SqlServer translation for DateOnly.ToDateTime(timeOnly) by @mseada94 in #35194
• Add readonly to Instance fields. by @cincuranet in #35334
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35335
• Don't attempt to remove a detached entry from the local view by @ajcvickers in #35253
• More translation test cleanup (Random, DateTime.Parse/new, bitwise operators) by @roji in #35341
• Switch to SQL standard "boolean". by @cincuranet in #35349
• Don't throw PendingModelChangesWarning when applying a specific migration by @AndriySvyryd in #35343
• Update dependencies and transform Span-based overloads to Enumerable in funcletizer by @roji in #35339
• Fix colors in activate.sh. by @cincuranet in #35350
• Basic setup of dev container. by @cincuranet in #35351
• Fix SqlConstantExpression obsolete constructor by @roji in #35357
• Optimize multiple consecutive LIMITs by @ranma42 in #35384
• Count > 0 normalized to Any should also work on ICollection by @ChrisJollyAU in #35381
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #35374
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35378
• Update baselines by @ranma42 in #35394
• Enable Resolve_scoped_application_service test by @ranma42 in #34129
• [TINY] Minor fixes to SQL baseline rewriter by @roji in #35333
• [release/9.0-staging] Don't throw PendingModelChangesWarning when applying a specific migration by @AndriySvyryd in #35353
• Fix tests by disabling provider caching. by @AndriySvyryd in #35402
• Update Helix queues by @AndriySvyryd in #35403
• More translation test work (basic operators, string case sensitivity...) by @roji in #35373
• [release/8.0] Update Helix queues by @AndriySvyryd in #35408
• [release/9.0] Update Helix queues by @AndriySvyryd in #35407
• Remove Windows 11 Arm64 Helix queue by @AndriySvyryd in #35406
• Don't escape separator characters in single key values by @ajcvickers in #35252
• [release/9.0-staging] Fix to #35239 - EF9: SaveChanges() is significantly slower in .NET9 vs. .NET8 when using .ToJson() Mapping vs. PostgreSQL Legacy POCO mapping by @maumar in #35360
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #35413
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35414
• [release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #35415
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35418
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #35417
• Fix to #35239 - EF9: SaveChanges() is significantly slower in .NET9 vs. .NET8 when using .ToJson() Mapping vs. PostgreSQL Legacy POCO mapping by @maumar in #35326
• [release/9.0-staging] Don't scaffold NonNullableConventionState annotation by @AndriySvyryd in #35359
• Add GetSchemaQualifiedHistoryTableName method to SqlServerEntityTypeExtensions by @rezaghadimim in #35368
• Update branding to 8.0.13 by @vseanreesermsft in #35427
• Update branding to 9.0.2 by @vseanreesermsft in #35428
• [SMALL] Split TemporalTranslations into per-type suites by @roji in #35371
• Make SnapshotModelProcessor idempotent. by @AndriySvyryd in #35432
• Change ExecuteUpdate to accept non-expression lambda by @roji in #35257
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #35458
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35459
• Update issue templates to forms. by @cincuranet in #35423
• Change ExecuteUpdate to accept Action instead of Func parameter by @roji in #35455
• Merge branch 'release/9.0-staging' => 'release/9.0' by @AndriySvyryd in #35463
• Merge branch 'release/8.0-staging' => 'release/8.0' by @AndriySvyryd in #35464
• [automated] Merge branch 'release/8.0' => 'release/9.0' by @github-actions in #35429
• [release/9.0] Update dependencies from dotnet/arcade by @dotnet-maestro in #35460
• Merging internal commits for release/9.0 by @vseanreesermsft in #35472
• Add file from disk into solution. by @cincuranet in #35478
• Implement support for the new .NET LeftJoin operator by @roji in #35451
• [automated] Merge branch 'release/9.0' => 'main' by @github-actions in #35430
• Fix hashing of IList constants in SqlConstantExpression by @ranma42 in #35487
• Fixes to implicit DbContext registration around factories by @roji in #35486
• Solves the problem of getting project MSBuild information by @paulomorgado in #34574
• Retarget ef.dll to net10.0 by @AndriySvyryd in #35488
• [main] Update dependencies from dotnet/arcade by @dotnet-maestro in #35496
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35497
• Revert dotnet ef --msbuildprojectextensionspath breaking change by @AndriySvyryd in #35492
• [TINY] Separate Guid/ByteArray translation tests to their own suites by @roji in #35501
• better perf in SupportedMethods calculation in SqlServerConvertTransl… by @SimonCropp in #34421
• Fix precompiled query handling of non-captured variables flowing in by @roji in #35504
• Enhance GetETagPropertyName method to handle ETag lookup in both entity and base types by @rezaghadimim in #35520
• [main] Update dependencies from dotnet/runtime by @dotnet-maestro in #35532
• Update branding to 10.0.0-preview1 by @AndriySvyryd in #35536
• [release/10.0-preview1] Update dependencies from dotnet/runtime by @dotnet-maestro in #35546
• [release/10.0-preview1] Update dependencies from dotnet/runtime by @dotnet-maestro in #35557

New Contributors

• @mianculovici made their first contribution in #34520
• @salihozkara made their first contribution in #34730
• @ascott18 made their first contribution in #34097
• @robertsilen made their first contribution in #34885
• @barnuri made their first contribution in #34832
• @am11 made their first contribution in #35149
• @arontsang made their first contribution in #34864
• @mseada94 made their first contribution in #35194
• @rezaghadimim made their first contribution in #35368

Full Changelog: v9.0.1...v10.0.0-preview.1.25081.1