22 Pull requests merged by 8 people

• [release/9.0] Don't suppress transactions when creating the history repository

  #35266 merged Dec 4, 2024

• Allow SqlFragmentExpression to have a type/type mapping

  #34995 merged Dec 4, 2024

• Expose SQLite VFS option in connection string

  #34864 merged Dec 3, 2024

• Merge branch 'release/9.0-staging' into release/9.0

  #35255 merged Dec 2, 2024

• [release/9.0] Fix Contains on ImmutableArray

  #35251 merged Dec 2, 2024

• [release/9.0] Add more specific messages when pending model changes are detected

  #35221 merged Dec 2, 2024

• [release/9.0] Fix query filters with context accessors

  #35246 merged Dec 2, 2024

• Fix test on newest SQL Server (not run on CI ATM)

  #35254 merged Dec 2, 2024

• [release/9.0] Set environment variables to "Development" when creating DbContext using IDesignTimeDbContextFactory

  #35230 merged Dec 2, 2024

• [release/9.0] Prevent owner entity from becoming optional

  #35222 merged Dec 2, 2024

• Uniquify all variables used in SQL Server migration scripts

  #35177 merged Dec 2, 2024

• [main] Update dependencies from dotnet/runtime

  #35250 merged Dec 2, 2024

• Fix Contains on ImmutableArray

  #35247 merged Dec 2, 2024

• [main] Update dependencies from dotnet/arcade

  #35249 merged Dec 2, 2024

• [release/9.0] Avoid using ^ and ~ when invalid because of value converters

  #35241 merged Dec 2, 2024

• [release/9.0] Uniquify all variables used in SQL Server migration scripts

  #35228 merged Dec 2, 2024

• Handle comparers for nullable value types in primitive collections

  #35235 merged Nov 30, 2024

• Fix query filters with context accessors

  #35237 merged Nov 30, 2024

• Avoid using ^ and ~ when invalid because of value converters

  #35124 merged Nov 29, 2024

• [release/9.0-staging] Fix to #35212 - Query/Perf: Compile identifier lambdas passed to PopulateIncludeCollection rather than inline

  #35217 merged Nov 27, 2024

• [release/9.0] Return null when the type is nullable for Cosmos Max/Min/Average

  #35216 merged Nov 27, 2024

• [release/9.0] Enable Cosmos vector search on EF9

  #35183 merged Nov 27, 2024

5 Pull requests opened by 4 people

• See how SqlClient 6 runs

  #35232 opened Nov 28, 2024

• Don't escape separator characters in single key values

  #35252 opened Dec 2, 2024

• Don't attempt to remove a detached entry from the local view

  #35253 opened Dec 2, 2024

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

  #35256 opened Dec 2, 2024

• Change ExecuteUpdate to accept non-expression lambda

  #35257 opened Dec 2, 2024

39 Issues closed by 13 people

• Different behaviour between `Include` and `ThenInclude` when querying self-referencing entities

  #35262 closed Dec 4, 2024

• No coercion operator is defined between nullable and not nullable type after upgrade from EFCore8 to EFCore9

  #35117 closed Dec 4, 2024

• EF 9 much slower than EF 8

  #35268 closed Dec 4, 2024

• [Feature Request] SqlQueryRaw support ValueTuple result

  #35267 closed Dec 4, 2024

• SYSTEM_VERSIONING = OFF in EF8 migration causes SYSTEM_VERSIONING is not turned ON in EF9

  #35180 closed Dec 4, 2024

• Support for a Single Project with Multiple Provider Migrations - Edge Case/Issue/Request

  #34197 closed Dec 3, 2024

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

  #34936 closed Dec 3, 2024

• The data types varchar and nvarchar are incompatible in the '^' operator

  #35093 closed Dec 3, 2024

• EF Core 9 : the database operation was expected to affect 1 row(s), but actually affected 0 row(s)

  #35195 closed Dec 3, 2024

• Error in Generated Migration Script for dotnet-ef 8.0.11

  #35132 closed Dec 2, 2024

• Scaffolding: Optionally including the `nullable` directive for generated code

  #33426 closed Dec 2, 2024

• Regression when using ImmutableArray's Contains, while Array's Contains method still works.

  #35102 closed Dec 2, 2024

• SQLite Error 19: 'FOREIGN KEY constraint failed'. exception is thrown in case of foreign key constraint is configured in base class's EntityTypeConfiguration

  #34761 closed Dec 2, 2024

• Including a view with nested properties

  #34721 closed Dec 1, 2024

• JSON: InvalidOperationException by deleting entity with owned entities

  #34566 closed Dec 1, 2024

• `dotnet ef migrations` does not work correctly with more than one model and migrations added in a non default location.

  #34528 closed Dec 1, 2024

• Query/Perf: Compile identifier lambdas passed to PopulateIncludeCollection rather than inline

  #35212 closed Nov 30, 2024

• Query/Perf: don't compile liftable constant resolvers in interpretation mode when the resolver itself contains a lambda

  #35208 closed Nov 30, 2024

• Query/Perf: don't use Invoke in value comparer ObjectEqualsExpression lambdas

  #35206 closed Nov 30, 2024

• After upgrading to .Net 9 with EF 9 the global query filter code throws a runtime exception

  #35111 closed Nov 30, 2024

• Allow Json property to be updated by using ExecuteUpdate or as a single property

  #35240 closed Nov 30, 2024

• Issue with Column Naming in Migrations for Snake Case

  #34874 closed Nov 29, 2024

• How can I update a Many to Many with Payload joining table

  #35064 closed Nov 29, 2024

• Facing this issue on EF core 8.0

  #35070 closed Nov 29, 2024

• Discriminator with default name but different type not generated correctly in migration snapshots

  #35075 closed Nov 29, 2024

• dotnet-ef - Could not load file or assembly 'ef, Version=9.0.0.0, Culture=neutral, PublicKeyToken=adb9793829ddae60'

  #35084 closed Nov 29, 2024

• Index was out of range issue while migration

  #35116 closed Nov 29, 2024

• collection-based materialization interceptor

  #35109 closed Nov 29, 2024

• get names by referance instead of hardcoding

  #35160 closed Nov 29, 2024

• The specified deps.json [...] does not exist. Missing net8.0 in path

  #35234 closed Nov 29, 2024

• Migration keeps trying to add/delete a discriminator even though i specified e.HasBaseType((Type)null)

  #33188 closed Nov 29, 2024

• RelationalQueryableMethodTranslatingExpressionVisitor now accepts RelationalQueryCompilationContext and not QueryCompilationContext

  #35226 closed Nov 28, 2024

• Try EF Core 9 now!

  #33030 closed Nov 28, 2024

• Nullable value type used with coalescing operator in argument to non-nullable aggregate function throws

  #35227 closed Nov 28, 2024

• Add a REPL for dotnet-ef

  #35125 closed Nov 28, 2024

• Running dotnet-ef migrations bundle in a Azure pipeline

  #35157 closed Nov 28, 2024

• Could not load type AdHocMapper after upgrading from 8 to 9

  #35179 closed Nov 27, 2024

• How to turn off protection against concurrent migrations

  #35186 closed Nov 27, 2024

• Cosmos: Min/Max/Average over nullable value type throws on no data

  #35094 closed Nov 27, 2024

20 Issues opened by 20 people

• React to deps.json change wrt PrivateAssets

  #35265 opened Dec 3, 2024

• How do I handle: The Azure Cosmos DB provider for EF Core currently does not support index definitions.'

  #35264 opened Dec 3, 2024

• User transaction is not supported with a TransactionSuppressed migrations or a retrying execution strategy Ef core 9

  #35263 opened Dec 3, 2024

• Rename EntityTypeBuilder<TEntity>.HasData(params object[] data) overload

  #35261 opened Dec 3, 2024

• How to avoid 'N' being prepended before json path in json_value() function in a user-defined function

  #35260 opened Dec 3, 2024

• Why are owned types required to use ToJson feature?

  #35259 opened Dec 3, 2024

• Issues with EF Tools (9.0.0) and MS.CodeAnalysis.WorkSpaces.MSBuild (4.8.0)

  #35258 opened Dec 3, 2024

• Microsoft.EntityFrameworkCore.Database.Command: Taking time to execute the queries because of new DateOnly datatype in .NET 8

  #35248 opened Dec 2, 2024

• Regression in EF9 for CosmosDb, 'CountAsync' broken

  #35245 opened Dec 1, 2024

• Add UseNetTopologySuite extension method for AzureSqlDbContextOptionsBuilder

  #35244 opened Dec 1, 2024

• LocalView goes out of sync and throws an IndexOutOfRangeException

  #35243 opened Nov 30, 2024

• Is it possible to have different delete behaviors on child and parent classes for a shared FK?

  #35242 opened Nov 29, 2024

• EF9: SaveChanges() is significantly slower in .NET9 vs. .NET8 when using .ToJson() Mapping vs. PostgreSQL Legacy POCO mapping

  #35239 opened Nov 29, 2024

• Mapping entities with a foreign key value of 0 fails in EF 8.0.11 on Azure SQL

  #35238 opened Nov 29, 2024

• Support span based collations comparison functions in Sqlite

  #35236 opened Nov 29, 2024

• Add dependency injection support to `IEntityTypeConfiguration` when using `ApplyConfigurationsFromAssembly`

  #35233 opened Nov 28, 2024

• Consider solutions for removing the need to specify same cmdline arguments all the time for the tools

  #35231 opened Nov 28, 2024

• IDbCommandInterceptor.CommandFailed does not capture all command exceptions

  #35229 opened Nov 28, 2024

• Cosmos: EF Core 9 fails to find document with '|' character in it's id

  #35224 opened Nov 27, 2024

• EF Core Sqlite - Migration doesn't apply configuration when [NotMapped] property is added to one of the DbSets

  #35223 opened Nov 27, 2024

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

• Adding Half type support for SqlLite

  #35193 commented on Dec 3, 2024 • 6 new comments

• Adding a stored procedure using raw SQL and then generating an idempotent migration script results in flawed SQL script

  #34555 commented on Nov 27, 2024 • 0 new comments

• Support multiple HasQueryFilter calls on same entity type

  #10275 commented on Dec 1, 2024 • 0 new comments

• Primary Contructor Causes analyzer misfire

  #35062 commented on Dec 2, 2024 • 0 new comments

• EFCore 8: DbContext (StateManager) adds back previously detached entities

  #33557 commented on Dec 2, 2024 • 0 new comments

• ASPNETCORE_ENVIRONMENT does not default to Development when using EF Core 9 if there is a IDesignTimeDbContextFactory implementation

  #35174 commented on Dec 2, 2024 • 0 new comments

• Regression from EF Core 8 to 9: MigrationBuilder.DropTable Causes Issues with Subsequent Table Recreation

  #35162 commented on Dec 2, 2024 • 0 new comments

• Cosmos SQL query enum array (Contains) to string conversion not working properly

  #35092 commented on Dec 2, 2024 • 0 new comments

• Register both DbContext and factory in DI with a single call

  #26528 commented on Dec 2, 2024 • 0 new comments

• Consider adding first-class left-join LINQ operator

  #12793 commented on Dec 2, 2024 • 0 new comments

• JSON serialised null values cause JsonCollectionReaderWriter to throw

  #34881 commented on Dec 2, 2024 • 0 new comments

• Accept `Action<SetPropertyCalls>` in `ExecuteUpdate`

  #32018 commented on Dec 2, 2024 • 0 new comments

• Programmatic Scaffold-Migration Issue After Updating to 9.0.0

  #35146 commented on Dec 3, 2024 • 0 new comments

• EF Core 9 generates incorrect compiled models for negative enum sentinel values

  #35142 commented on Dec 3, 2024 • 0 new comments

• InMemory database context with CustomWebApplicationFactory is giving double database context registration error. How do I implement this correctly?

  #35126 commented on Dec 3, 2024 • 0 new comments

• Required dependent of optional dependent is not materialized/updated properly

  #34707 commented on Dec 3, 2024 • 0 new comments

• Consider using NuGet's buildTransitive folder

  #14531 commented on Dec 3, 2024 • 0 new comments

• Revisit tools architecture

  #18840 commented on Dec 3, 2024 • 0 new comments

• Improve experience deploying databases created by Migrations

  #19587 commented on Dec 3, 2024 • 0 new comments

• Sample for Migrations with Multiple Providers does not work

  #25023 commented on Dec 3, 2024 • 0 new comments

• Support migrations for the same DbContext in the same assembly for multiple providers

  #29343 commented on Dec 3, 2024 • 0 new comments

• Allow to change the order of updates when using a filtered unique index

  #35159 commented on Dec 4, 2024 • 0 new comments

• Have a tests suite (or model) specifically for method/member translations

  #34872 commented on Dec 4, 2024 • 0 new comments

• SQL Server geography elevation (Z) is not updated

  #34290 commented on Dec 4, 2024 • 0 new comments

• Unexpected PendingModelChangesWarning on initial creation of database via migrations

  #35110 commented on Dec 4, 2024 • 0 new comments

• Is EF9 slower than EF8?

  #35053 commented on Dec 4, 2024 • 0 new comments

• Allow FKs to exist in the model but avoid creating them in the database

  #15854 commented on Dec 4, 2024 • 0 new comments

• Rowversion migration regression from EF Core 8 to 9

  #35148 commented on Dec 4, 2024 • 0 new comments

• EF Core 9 migration behaviour change causes an exception with surrounding user transaction

  #35127 commented on Dec 4, 2024 • 0 new comments

• Temporal table migration regression from EF Core 8 to 9

  #35108 commented on Dec 4, 2024 • 0 new comments

• Add SqlServer translation for DateOnly.ToDateTime(timeOnly)

  #35194 commented on Dec 2, 2024 • 0 new comments

• Cosmos: Advanced type mapping inference (for scalar collections)

  #34026 commented on Nov 27, 2024 • 0 new comments

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

  #34153 commented on Nov 27, 2024 • 0 new comments

• Query/Perf: deep investigation on shaper perf changes regarding AOT

  #35210 commented on Nov 28, 2024 • 0 new comments

• When using temporal tables - property named PeriodEnd or PeriodStart has to be DateTime

  #27316 commented on Nov 28, 2024 • 0 new comments

• [Perf] consider not using Expression.Invoke in CreateGetValueExpression for value with converter when possible

  #35129 commented on Nov 28, 2024 • 0 new comments

• Merge/Upsert/AddOrUpdate support

  #4526 commented on Nov 28, 2024 • 0 new comments

• Value cannot be null. (Parameter 'key') issue on Concurrent/Duplicate updates

  #35185 commented on Nov 28, 2024 • 0 new comments

• Ability to refresh a context from the database

  #16491 commented on Nov 29, 2024 • 0 new comments

• Missing `_ord` column when translating an inline collection into a queryable SQL VALUES expression

  #34954 commented on Nov 29, 2024 • 0 new comments

• Bug Report: Unexpected Behavior When Removing Non-Tracked Entities in Entity Framework

  #35188 commented on Nov 29, 2024 • 0 new comments

• Consider throwing/warning by default if a migration is used against a different provider than it was generated for

  #15174 commented on Nov 29, 2024 • 0 new comments

• DefaultTypeMappings do not seem to be applied in queries.

  #34850 commented on Nov 29, 2024 • 0 new comments

• JsonElement not supported with Sqlite

  #34752 commented on Nov 29, 2024 • 0 new comments

• ExecuteNonQuery_throws_when_busy_with_returning failed

  #33520 commented on Nov 29, 2024 • 0 new comments

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

  #35033 commented on Nov 29, 2024 • 0 new comments

• IsPrimitiveCollection metadata is incorrect when using the compiled model

  #35047 commented on Nov 30, 2024 • 0 new comments

• NullReferenceException when trying to optimize a DbContext with --nativeaot

  #35219 commented on Nov 30, 2024 • 0 new comments

• ComplexType properties disappear when using TPC mapping

  #35025 commented on Nov 30, 2024 • 0 new comments

• Access SQL Server extended properties in scaffolding templates (t4)

  #33270 commented on Nov 30, 2024 • 0 new comments

• Null reference exception in migrations when string has invalid store type

  #33556 commented on Nov 30, 2024 • 0 new comments

• Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 14: 'unable to open database file'

  #34273 commented on Nov 30, 2024 • 0 new comments

• When using Microsoft.EntityFrameworkCore.Sqlite in a plug-in, if it is not introduced in the main project, but it is introduced in the plug-in project, an exception will be throwed.

  #34308 commented on Nov 30, 2024 • 0 new comments

• Scaffolded Navigation Properties Forced to Use Navigation Suffix

  #34328 commented on Nov 30, 2024 • 0 new comments

• 'Argument types do not match' when selecting off of a projection with a null check

  #34411 commented on Nov 30, 2024 • 0 new comments

• Customizing migration detection and generation

  #34454 commented on Nov 30, 2024 • 0 new comments

• Remove reference joins in split queries

  #29182 commented on Nov 30, 2024 • 0 new comments

• The Include path expression must refer to a navigation property defined on the type

  #34625 commented on Dec 1, 2024 • 0 new comments

• Problem with Bounded Context and Shared DbContext Base in a Modular Monolith using DDD

  #34646 commented on Dec 1, 2024 • 0 new comments

• Issue while performing null check in where clause in linq for a non-nullable string property

  #35058 commented on Dec 1, 2024 • 0 new comments

• Primitive collections without setters don't get discovered by convention

  #34815 commented on Dec 1, 2024 • 0 new comments