10 Pull requests merged by 7 people

• [release/9.0-staging TEST ONLY] adjusting some migration tests so that baselines dont depend on the product version

  #34977 merged Nov 2, 2024

• Use the proper type mapping for the result of AVG

  #35023 merged Oct 31, 2024

• [release/8.0-staging] Update macOS images to 13

  #35005 merged Oct 30, 2024

• [release/9.0-staging] Update macOS images to 13

  #35004 merged Oct 30, 2024

• [main] Update dependencies from dotnet/runtime

  #34998 merged Oct 29, 2024

• Bump Azure.Identity from 1.13.0 to 1.13.1

  #35001 merged Oct 28, 2024

• [TINY] Do not return null namespace for Types

  #34994 merged Oct 28, 2024

• Update .Sources package reference

  #34973 merged Oct 28, 2024

• [main] Update dependencies from dotnet/arcade

  #34997 merged Oct 28, 2024

• Fix to #34960 - System.Text.Json.JsonReaderException: '0x00' is invalid after a single JSON value. Expected end of data

  #34969 merged Oct 28, 2024

8 Pull requests opened by 6 people

• Support translating some string functions when they have a char parameters

  #34999 opened Oct 28, 2024

• Better cast/convert support for Cosmos

  #35000 opened Oct 28, 2024

• Bump Microsoft.Azure.Cosmos from 3.44.1 to 3.45.0

  #35002 opened Oct 28, 2024

• Update macOS images to 13

  #35003 opened Oct 28, 2024

• Fix to #35007 - EF Core fails to translate LINQ query to SQL if JOIN contains multiple columns

  #35019 opened Oct 30, 2024

• Move NonNullableConventionState to CoreAnnotationNames

  #35020 opened Oct 30, 2024

• Add custom file header when scaffolding

  #35021 opened Oct 30, 2024

• Fix to #35024 - Query could not be translated when using a static ICollection/IList field

  #35029 opened Nov 1, 2024

23 Issues closed by 9 people

• Compiled model fails to distinguish between types with same name in different namespaces

  #35032 closed Nov 3, 2024

• EFCore 9 - SqlServer - RC2 - Issue when IndexOf("") is used in the LINQ

  #34968 closed Nov 3, 2024

• Unable to create a migration for OracleDB

  #35030 closed Nov 2, 2024

• Removing HierarchyId with existing migrations breaks compilation

  #35022 closed Nov 1, 2024

• Ignore Other Global Query Filters during OnModelCreating

  #34986 closed Nov 1, 2024

• Cosmos: Average truncates results

  #26378 closed Oct 31, 2024

• Should I use foreign keys for a composite primary key?

  #35008 closed Oct 31, 2024

• How may I resolve?

  #35012 closed Oct 31, 2024

• ToListAsync returns wrong amount of rows when using TemporalAll and list projection

  #34978 closed Oct 31, 2024

• Get latest version of all from temporal table, with include.

  #34384 closed Oct 31, 2024

• EFCore 9 RC2 - Issue with translation of DbFunction when EF.Constant is used as an argument

  #34962 closed Oct 30, 2024

• Temporary primary keys and actual primary keys cannot be the same

  #34989 closed Oct 30, 2024

• Analyser issue with FindAsync

  #34966 closed Oct 29, 2024

• New Provider: Appropriate mechanism for injecting query hints

  #35009 closed Oct 29, 2024

• System.InvalidCastException: Unable to cast object of type 'System.String' to type 'System.Int32'.

  #34959 closed Oct 29, 2024

• Format of the initialization string does not conform to specification starting at index

  #34946 closed Oct 29, 2024

• Make DbContext release references to entities when they are removed or detached.

  #34987 closed Oct 29, 2024

• FromSql(): Allow SqlCommand-like type as an overloaded method parameter

  #34990 closed Oct 29, 2024

• Discrepancy with Temporal tables results

  #34972 closed Oct 29, 2024

• EF Core - SQLClient includes all columns from a joined table in the SQL query, even when only one field is explicitly selected

  #34980 closed Oct 28, 2024

• Scaffolded migrations are invalid when a type in the global namespace is referenced

  #34993 closed Oct 28, 2024

• Issue Running EF Core Migration Bundle in .NET SDK Container Image on Linux Debian (WSL2)

  #34979 closed Oct 28, 2024

• System.Text.Json.JsonReaderException: '0x00' is invalid after a single JSON value. Expected end of data.

  #34960 closed Oct 28, 2024

19 Issues opened by 16 people

• invalid FK field name

  #35034 opened Nov 3, 2024

• Compiled model generates code that attempts to reference private methods in value converters

  #35033 opened Nov 2, 2024

• Should I use required modifier with navigations?

  #35031 opened Nov 1, 2024

• Query: invalid SQL generated when doing join with nested anonymous key selectors

  #35028 opened Oct 31, 2024

• Investigate potential overhead of using pre-compiled queries in non-AOT mode

  #35027 opened Oct 31, 2024

• Analyzer: Warn about missing indexes on queries

  #35026 opened Oct 31, 2024

• ComplexType properties disappear when using TPC mapping

  #35025 opened Oct 31, 2024

• Query could not be translated when using a static ICollection/IList field

  #35024 opened Oct 31, 2024

• Add GetSchemaQualifiedHistoryTableName method to SqlServerEntityTypeExtensions

  #35018 opened Oct 30, 2024

• Property not being ignored by EntityTypeBuilder

  #35017 opened Oct 30, 2024

• Model annotation changes absent from Down() method of initial migration

  #35016 opened Oct 29, 2024

• Rollback migration command for efcore

  #35015 opened Oct 29, 2024

• GroupBy with joined table produces sub optimal query

  #35014 opened Oct 29, 2024

• Compile generated UnsafeAccessors classes don't match underlying class accessibility level

  #35013 opened Oct 29, 2024

• Compile generated EntityType classes are susceptible to variable name clashes

  #35011 opened Oct 29, 2024

• Microsoft.Data.Sqlite keeps handle on file even after close, and pool clear

  #35010 opened Oct 29, 2024

• EF Core fails to translate LINQ query to SQL if JOIN contains multiple columns

  #35007 opened Oct 29, 2024

• AOT : when precompile model is not nativeaot compatibile, we should throw informative exception telling users to use -nativeaot switch

  #35006 opened Oct 29, 2024

• public IReadOnlyCollection<string> with private backing field throws exception when trying to add migration

  #34996 opened Oct 28, 2024

30 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.

• Cosmos: review cast/convert handling

  #34982 commented on Oct 28, 2024 • 0 new comments

• Translate LINQ DistinctBy

  #27470 commented on Oct 28, 2024 • 0 new comments

• Improve experience deploying databases created by Migrations

  #19587 commented on Oct 28, 2024 • 0 new comments

• Open up MigrationHistoryTable's model building for provider extensibility (or rethink the design)

  #34991 commented on Oct 28, 2024 • 0 new comments

• "You need to call SQLitePCL.raw.SetProvider()" error when using Microsoft.EntityFrameworkCore.Sqlite 5.0.4 via C++\CLI wrapper

  #24493 commented on Oct 29, 2024 • 0 new comments

• Support Contains with a collection of tuples (e.g. for filtering on composite keys)

  #11799 commented on Oct 29, 2024 • 0 new comments

• Microsoft.EntityFrameworkCore.Sqlite.NetTopologySuite ERROR: System.ArgumentException: shell is empty but holes are not

  #34981 commented on Oct 29, 2024 • 0 new comments

• EFOptimizeContext: add support for partial implementations

  #34988 commented on Oct 29, 2024 • 0 new comments

• Query: we don't convert JOIN to APPLY for query with subquery inside argument to Take method

  #32303 commented on Oct 29, 2024 • 0 new comments

• Bulk import for efficient importing of data from the client into the database

  #27333 commented on Oct 30, 2024 • 0 new comments

• Allow mapping optional complex properties

  #31376 commented on Oct 30, 2024 • 0 new comments

• Rationalize use of global filter when filtering is already done implicitly through joins

  #22914 commented on Oct 30, 2024 • 0 new comments

• HasPendingModelChanges() always returns true

  #34967 commented on Oct 30, 2024 • 0 new comments

• Consider the role of value converters in determining the default value of a non-nullable column added to an existing table

  #34952 commented on Oct 30, 2024 • 0 new comments

• Regression going from .NET/EF 8 to 9 with CosmosDb, will no longer save/load Ulid and Custom struct types

  #34936 commented on Oct 30, 2024 • 0 new comments

• `NonRetryingExecutionStrategy` does not set `ExecutionStrategy.Current` and is ignored.

  #34953 commented on Oct 30, 2024 • 0 new comments

• Tools: Use either UseSeeding or UseAsyncSeeding

  #34923 commented on Oct 30, 2024 • 0 new comments

• Migration fails in EF7 when mapping TVF using a model with 'string' properties

  #30142 commented on Oct 30, 2024 • 0 new comments

• Allow value types as optional properties, using the sentinel value to detect when they're set

  #34943 commented on Oct 30, 2024 • 0 new comments

• AutoInclude via data annotations

  #28486 commented on Oct 31, 2024 • 0 new comments

• JSON serialised null values cause JsonCollectionReaderWriter to throw

  #34881 commented on Oct 31, 2024 • 0 new comments

• Too many columns selected for collection subquery

  #34851 commented on Nov 1, 2024 • 0 new comments

• Attempts of returning DbSet.Local entities instead of requesting a database if possible.

  #34983 commented on Nov 1, 2024 • 0 new comments

• Consider removing the CAST to BIT for boolean literal values

  #27150 commented on Nov 1, 2024 • 0 new comments

• Allow navigations and FK properties on non-collection complex types

  #31245 commented on Nov 1, 2024 • 0 new comments

• Break apart methods in the compiled model

  #31370 commented on Nov 2, 2024 • 0 new comments

• Support JSON properties with TPT/TPC inheritance mapping

  #28443 commented on Nov 2, 2024 • 0 new comments

• .NET 8 migration on .NET MAUI Blazor Hybrid App causes exception: The type initializer for "<Module>" threw an exception.

  #32384 commented on Nov 3, 2024 • 0 new comments

• Apply fix from #34729 to Cosmos SqlExpressionFactory to keep it in sync

  #34964 commented on Oct 28, 2024 • 0 new comments

• Allow SqlFragmentExpression to have a type/type mapping

  #34995 commented on Oct 29, 2024 • 0 new comments