20 Pull requests merged by 7 people

• Don't use service discovery for DbContext types if corresponding IDesignTimeDbContextFactory implementations are found.

  #34082 merged Jul 8, 2024

• [main] Update dependencies from dotnet/runtime

  #34186 merged Jul 8, 2024

• [main] Update dependencies from dotnet/arcade

  #34185 merged Jul 8, 2024

• Improve String_Contains_Column test

  #34174 merged Jul 7, 2024

• Cosmos: Stop generating discriminator clause when not needed

  #34145 merged Jul 4, 2024

• Some minor Cosmos cleanup

  #34155 merged Jul 4, 2024

• Pack of minor Cosmos changes

  #34143 merged Jul 4, 2024

• Implement Cosmos alias management

  #34074 merged Jul 3, 2024

• Index convention changes for non-relational providers

  #34054 merged Jul 3, 2024

• Simplify NOT

  #34142 merged Jul 3, 2024

• Use XOR to translate some == and != expressions

  #34124 merged Jul 3, 2024

• [release/6.0] Clean up YAML

  #34095 merged Jul 3, 2024

• Update branding to 6.0.33

  #34140 merged Jul 3, 2024

• Update branding to 8.0.8

  #34141 merged Jul 3, 2024

• [release/8.0] Update image to macOS-12

  #34037 merged Jul 2, 2024

• [release/6.0] Update image to macOS-12

  #34036 merged Jul 2, 2024

• Simplify AND and OR

  #34133 merged Jul 2, 2024

• Enable JSON tests on SQLite without Spatialite

  #34113 merged Jul 2, 2024

• Enable testing of compiled models in CI

  #34111 merged Jul 2, 2024

• Simplify COALESCE based on the nullability of its arguments

  #33938 merged Jul 2, 2024

8 Pull requests opened by 4 people

• [automated] Merge branch 'release/8.0' => 'main'

  #34144 opened Jul 2, 2024

• Add UnsafeAccessor support for generic types

  #34146 opened Jul 3, 2024

• Prefer equality in boolean comparisons

  #34166 opened Jul 5, 2024

• Use XOR to translate more == and != expressions

  #34168 opened Jul 5, 2024

• Translate COALESCE as ISNULL

  #34171 opened Jul 5, 2024

• Avoid duplicating complex expression in comparisons

  #34172 opened Jul 5, 2024

• Implement `CASE` flattening optimizations

  #34175 opened Jul 6, 2024

• Cosmos: Redo ReadItem and partition key management

  #34187 opened Jul 8, 2024

16 Issues closed by 5 people

• Construct IDesignTimeDbContextFactory without first discovering all DbContext types

  #27322 closed Jul 8, 2024

• Microsoft.Data.Sqlite - .NET8 iOS

  #34182 closed Jul 8, 2024

• Non-Nullable String Column added after table creation also adds default value

  #34178 closed Jul 8, 2024

• Make GUID keys auto-generated in Cosmos even if a partition key is used

  #33961 closed Jul 7, 2024

• OwnedType does not work with type configured with .ToSqlQuery

  #34160 closed Jul 7, 2024

• EF Core 8 query causing intensive performance drop due to the breaking "contians" change

  #34170 closed Jul 7, 2024

• EF Reverse engineering (scaffolding) problem

  #34162 closed Jul 5, 2024

• Cosmos: Leverage complete discriminator mapping

  #20268 closed Jul 4, 2024

• Support map property to view and ignore it on table

  #34147 closed Jul 3, 2024

• Cosmos: Implement proper source alias management

  #33894 closed Jul 3, 2024

• Cannot constrain max length of a text field in a model

  #34150 closed Jul 3, 2024

• Should cascade delete work when specifying custom class for join entity

  #34136 closed Jul 3, 2024

• Indexes are created by default for foreign keys in non-relational databases

  #34053 closed Jul 3, 2024

• The Cosmos provider ignores configured indexes

  #34023 closed Jul 3, 2024

• Compiled model tests failing on Windows

  #34137 closed Jul 2, 2024

• All PRs were merged on green, and yet the build was still broken

  #34139 closed Jul 2, 2024

26 Issues opened by 13 people

• Validate that derived types aren't mapped to a different container.

  #34189 opened Jul 8, 2024

• Report precompiled query generation progress

  #34188 opened Jul 8, 2024

• Validate against JSON inheritance mapping, which isn't supported yet

  #34184 opened Jul 8, 2024

• SQL truncated at lines starting with "go" in migrationBuilder.Sql

  #34183 opened Jul 8, 2024

• All providers: warn when attempting to save entity with CLR default key value

  #34181 opened Jul 8, 2024

• Cosmos: error when attempting to save entity with CLR default key value

  #34180 opened Jul 8, 2024

• Cosmos: Use 1:1 mapping for .NET `Id` to JSON `id` unless explicitly configured otherwise

  #34179 opened Jul 8, 2024

• Json parse error while using /login method from WebApiCore Identity provided by [email protected]

  #34177 opened Jul 7, 2024

• Cosmos: Inherit partition key definition from parent by convention

  #34176 opened Jul 7, 2024

• Supporting OUTER APPLY for aggregate queries

  #34173 opened Jul 6, 2024

• dotnet ef dbcontext scaffold creates a property of the parent type in the child class

  #34169 opened Jul 5, 2024

• Hidden Exception in LazyLoader.Load(..) Due to exception in InternalEntry.SetIsLoaded(..)

  #34167 opened Jul 5, 2024

• Investigate alternative translations for (in)equality comparison

  #34165 opened Jul 5, 2024

• Prefer equality when comparing values

  #34164 opened Jul 5, 2024

• Cosmos: Consider transforming to ReadItem even when a projection is present

  #34163 opened Jul 5, 2024

• Migration drops non-existent column for model with owned base class but non-owned inherited class

  #34161 opened Jul 4, 2024

• Query: take indexes into account in optimizations

  #34159 opened Jul 4, 2024

• Utilizing the new `CreateVersion7` API for `ValueGeneratedOnAdd`

  #34158 opened Jul 4, 2024

• Cosmos: Reimplement ReadItem via its own expression type again

  #34157 opened Jul 4, 2024

• Allow passing in options to IDbContextFactory.CreateDbContext

  #34156 opened Jul 4, 2024

• Why Unknown error 258 is not in SqlServerRetryingExecutionStrategy retryable error numbers.

  #34154 opened Jul 3, 2024

• Cosmos: Update pipeline doesn't support primitive collections over value-converted elements

  #34153 opened Jul 3, 2024

• Share optimizations between relational and non-relational providers

  #34152 opened Jul 3, 2024

• SQL optimization/simplification in 9.0

  #34151 opened Jul 3, 2024

• Comparing expressions can be slow

  #34149 opened Jul 3, 2024

• Cosmos: Stop generating discriminator predicate when querying all mapped types of a container (and the discriminator is complete)

  #34148 opened Jul 3, 2024

65 Unresolved conversations

Sometimes conversations happen on old items that aren’t yet closed. Here is a list of all the Issues and Pull Requests with unresolved conversations.

• Consider introducing nullability on SqlExpression

  #33889 commented on Jul 4, 2024 • 11 new comments

• Contains to OPENJSON translation regresses performance

  #32394 commented on Jul 8, 2024 • 7 new comments

• Query: optimize database null-semantics propagation

  #34126 commented on Jul 8, 2024 • 6 new comments

• [WIP] Translation of TimeOnly.FromTimeSpan on SQL Server no-op

  #34114 commented on Jul 6, 2024 • 4 new comments

• Memory Leak - Microsoft.EntityFrameworkCore.Internal.ServiceProviderCache

  #34028 commented on Jul 6, 2024 • 3 new comments

• Cosmos: Improve single-partition queries

  #17318 commented on Jul 8, 2024 • 3 new comments

• Implement `IS [NOT] DISTINCT FROM` translation

  #34048 commented on Jul 8, 2024 • 2 new comments

• Cosmos: The reading of a ResponseMessage is always done synchronously

  #34093 commented on Jul 8, 2024 • 2 new comments

• Add support for value converters to HasDbFunction in order to better support value objects

  #33788 commented on Jul 6, 2024 • 2 new comments

• The given key 'EmptyProjectionMember' was not present in the dictionary

  #31209 commented on Jul 3, 2024 • 2 new comments

• Allow keys and indexes to use properties on non-collection complex types

  #31246 commented on Jul 3, 2024 • 2 new comments

• Stuck on inherited entity model binding

  #34107 commented on Jul 3, 2024 • 2 new comments

• Shared column with different CLR types gets projected out twice

  #25272 commented on Jul 8, 2024 • 2 new comments

• Support inheritence with JSON POCO mapping

  #27779 commented on Jul 8, 2024 • 2 new comments

• SQL Server functional tests take twice as long after recent Arcade update

  #34039 commented on Jul 8, 2024 • 1 new comment

• Support expression (AKA functional) indexes

  #28360 commented on Jul 7, 2024 • 1 new comment

• Cosmos: ReadItem should be used for Reload

  #33893 commented on Jul 6, 2024 • 1 new comment

• Query: Additional function mapping capabilities

  #4319 commented on Jul 6, 2024 • 1 new comment

• Additional optimization suggestions for CASE

  #33957 commented on Jul 6, 2024 • 1 new comment

• Reloading Data

  #13620 commented on Jul 8, 2024 • 1 new comment

• AOT: query precompilation can be extemely slow for some query shapes (specifically containing JSON)

  #34108 commented on Jul 8, 2024 • 1 new comment

• Support vector search on Cosmos DB

  #33991 commented on Jul 3, 2024 • 1 new comment

• Fix `Nullable<T>.ToString()`

  #34014 commented on Jul 2, 2024 • 1 new comment

• Lock the database while executing Migrate()

  #34115 commented on Jul 8, 2024 • 1 new comment

• Use null propagation to optimize away `IS NOT NULL` checks

  #34127 commented on Jul 4, 2024 • 1 new comment

• Query: optimize nested CASE blocks

  #18774 commented on Jul 6, 2024 • 1 new comment

• Correct Approach to generate ef core 8 migrations programmatically on runtime with previous snapshots

  #34087 commented on Jul 2, 2024 • 1 new comment

• Cosmos: Allow database management operations using RBAC

  #33964 commented on Jul 3, 2024 • 1 new comment

• Performance decrease (10 second delay) in database migration 8.0.0 vs 8.0.3

  #33399 commented on Jul 5, 2024 • 1 new comment

• SQL Server: consider switching from COALESCE to ISNULL

  #32519 commented on Jul 5, 2024 • 1 new comment

• Fix case-insensitive logic for column names in SQL queries

  #33885 commented on Jul 4, 2024 • 1 new comment

• Full-Text Search not working with Global Query Filter

  #33799 commented on Jul 4, 2024 • 1 new comment

• SqlServer never returns `null` for nullable Boolean expressions

  #34001 commented on Jul 3, 2024 • 1 new comment

• Examine additional errors in SQL exceptions to properly handle connections

  #27917 commented on Jul 5, 2024 • 1 new comment

• Nullable object must have a value thrown for a query with DefaultIfEmpty()

  #30915 commented on Jul 4, 2024 • 0 new comments

• Ask for the "PrivacyInfo.xcprivacy" required by Apple

  #34029 commented on Jul 8, 2024 • 0 new comments

• 9.0 API Reviews

  #33220 commented on Jul 8, 2024 • 0 new comments

• Improve experience for managing migrations

  #22945 commented on Jul 8, 2024 • 0 new comments

• Make our SQL tree fully immutable

  #32927 commented on Jul 3, 2024 • 0 new comments

• Improve performance for RelationalCommandCache by adding a hashcode to the Command

  #34117 commented on Jul 3, 2024 • 0 new comments

• Cosmos: Stop nesting results in extra JSON object

  #34044 commented on Jul 7, 2024 • 0 new comments

• AOT/Compiled model: Somewhat complex entity with enums produces compiled model that contains AOT warnings

  #34057 commented on Jul 3, 2024 • 0 new comments

• Make sort order consistent in split queries

  #34097 commented on Jul 2, 2024 • 0 new comments

• Generate shorter UnsafeAccessor names

  #33470 commented on Jul 3, 2024 • 0 new comments

• Generate fully qualified lambda signatures for better compilation speed

  #33773 commented on Jul 3, 2024 • 0 new comments

• Update Microsoft.CodeAnalysis version to 4.10

  #34116 commented on Jul 3, 2024 • 0 new comments

• Fix for #34117, Improve Hash Code Distribution for RelationalCommandCache Keys

  #34118 commented on Jul 3, 2024 • 0 new comments

• Add SqlServer DATEPART support for Microsecond and Nanosecond properties.

  #34135 commented on Jul 3, 2024 • 0 new comments

• Query: optimize CASE statement - remove conditions that are never hit

  #18935 commented on Jul 6, 2024 • 0 new comments

• Cosmos: Optimize more queries that could use ReadItem

  #20693 commented on Jul 6, 2024 • 0 new comments

• Cosmos: Detect partition key filters in more queries

  #20350 commented on Jul 6, 2024 • 0 new comments

• Cosmos: We incorrectly execute via ReadItem, ignoring additional operators composed on top

  #34085 commented on Jul 6, 2024 • 0 new comments

• Cosmos: Extra clauses are removed from the query when extracting hierarchical partition key values

  #33960 commented on Jul 6, 2024 • 0 new comments

• Add-Migration in Package Manager Console never completes, breaking package manager until VS2022 exit

  #34055 commented on Jul 7, 2024 • 0 new comments

• [Cosmos] How to set a partition key in a embedded entity?

  #25548 commented on Jul 7, 2024 • 0 new comments

• Promote ExecuteUpdate/Delete from relational to core

  #31052 commented on Jul 7, 2024 • 0 new comments

• It is not possible to set null on property null Json after SaveChanges

  #34030 commented on Jul 7, 2024 • 0 new comments

• How to use custom annotations through migrations

  #34049 commented on Jul 7, 2024 • 0 new comments

• Cosmos: Validate our current container mapping strategy

  #34005 commented on Jul 8, 2024 • 0 new comments

• EF Core database provider for Azure Cosmos DB

  #33033 commented on Jul 8, 2024 • 0 new comments

• Query pipeline architecture issues

  #31327 commented on Jul 4, 2024 • 0 new comments

• Ensure FTS and other optional requirements for dev flow are tested on the C.I.

  #33916 commented on Jul 8, 2024 • 0 new comments

• Cosmos: support for mapping ReadOnlyMemory and/or similar

  #34021 commented on Jul 8, 2024 • 0 new comments

• Add the attribute ExcludeFromCodeCoverage for migrations

  #33138 commented on Jul 4, 2024 • 0 new comments

• Cosmos: projecting collection of distinct ints throws

  #34009 commented on Jul 4, 2024 • 0 new comments