Insights: dotnet/efcore

12 Pull requests merged by 6 people

• Query expression interceptor

  #28351 merged Jul 1, 2022

• Add a way to configure identity columns and triggers for split enities

  #28354 merged Jul 1, 2022

• Adjust DetectChanges events so they can be used to get a notification when all changes for an entity have been detected

  #28356 merged Jul 1, 2022

• Migrate FabricBot Tasks to Config-as-Code

  #28341 merged Jun 30, 2022

• New ChangeTracker events

  #28297 merged Jun 30, 2022

• [main] Update dependencies from dotnet/runtime

  #28322 merged Jun 30, 2022

• [release/7.0-preview6] Update dependencies from dotnet/runtime

  #28347 merged Jun 30, 2022

• Workaround for Sqlite/InMemory test failures on OSX

  #28328 merged Jun 29, 2022

• Add entity splitting tests for migrations and update pipeline

  #28338 merged Jun 29, 2022

• Interceptor for DbUpdateConcurrencyException

  #28305 merged Jun 29, 2022

• Add support for CSharpHelper for List literals

  #28212 merged Jun 27, 2022

• [main] Update dependencies from dotnet/arcade

  #28323 merged Jun 27, 2022

8 Pull requests opened by 7 people

• Bump Microsoft.Data.SqlClient from 5.0.0-preview2.22096.2 to 5.0.0-preview3.22168.1

  #28325 opened Jun 27, 2022

• Bump NetTopologySuite from 2.4.0 to 2.5.0

  #28326 opened Jun 27, 2022

• Add support for CSharpHelper for Dictionary literals

  #28330 opened Jun 27, 2022

• Translate x.parse

  #28337 opened Jun 28, 2022

• [release/6.0] Query: Don't add DbParameter if already added

  #28348 opened Jun 29, 2022

• Scaffolding: Refactor some code

  #28358 opened Jul 1, 2022

• Store null table name and TPH mapping strategy in the snapshot

  #28359 opened Jul 2, 2022

• Fix dropping of sequence and dependent column

  #28361 opened Jul 2, 2022

28 Issues closed by 12 people

• "SELECT COUNT(*) FROM sqlite_schema;" always returns null

  #28321 closed Jul 3, 2022

• Events and interception (aka lifecycle hooks)

  #626 closed Jul 1, 2022

• Interceptors for expression trees

  #19748 closed Jul 1, 2022

• Cannot configure different Identity column facets for different tables in TPC mapping

  #28195 closed Jul 1, 2022

• HasTrigger for entity-splitting

  #28237 closed Jul 1, 2022

• Provide event that can be used to get notifications when all property changes have been detected

  #26506 closed Jul 1, 2022

• How do you test EF Query Filters?

  #28357 closed Jul 1, 2022

• Why type of DbSet property at runtime is shown as of type InternalDbSet1?

  #28355 closed Jul 1, 2022

• Error with nested LINQ Select and AutoMapper ProjectTo

  #28334 closed Jun 30, 2022

• How to remove orphans from the db context?

  #28345 closed Jun 30, 2022

• Why does EF Core use nested select statements in all joins?

  #28252 closed Jun 30, 2022

• Change Tracker events lost on pooled context

  #27473 closed Jun 30, 2022

• Add interception for DetectChanges/state changes

  #16256 closed Jun 30, 2022

• ChangeTracker: New event for "entity about to get tracked"

  #27093 closed Jun 30, 2022

• Simple insert fails when key col has an explicit collation

  #28317 closed Jun 29, 2022

• Projection in DbSet Ignores Filter Condition in Where Clause

  #28346 closed Jun 29, 2022

• Problem with setting cte max recursion depth value using raw sql

  #28336 closed Jun 29, 2022

• Error "The specified deps.json ... does not exist"

  #28335 closed Jun 29, 2022

• GroupBy with to-many relation leads to exception and overly complex SQL (regression since 6.0.2)

  #28309 closed Jun 29, 2022

• Is it possible to evaluate in server if a the property of a row starts with any item of a list of strings?

  #28292 closed Jun 29, 2022

• Interception for DbUpdateConcurrencyException

  #28315 closed Jun 29, 2022

• renaming entities while scaffolding in EF Core 6

  #28329 closed Jun 28, 2022

• Sqlite Unique Key

  #28324 closed Jun 27, 2022

• Intermittent Behavior With Linq .Any() / AnyAsync()

  #28311 closed Jun 27, 2022

• GroupJoin leads to exception

  #28319 closed Jun 27, 2022

• SqlClient version in EF Core.

  #28320 closed Jun 27, 2022

• GroupJoin leads to exception

  #28318 closed Jun 27, 2022

• Sum in GroupBy fails with Cannot perform an aggregate function on an expression containing an aggregate or a subquery

  #28310 closed Jun 27, 2022

14 Issues opened by 12 people

• Allow IDesignTimeDbContextFactory to be picked up via an assembly attribute

  #28363 opened Jul 2, 2022

• Entity is not updated using new context instance from new service provider scope, InMemoryProvider

  #28362 opened Jul 2, 2022

• Support expression (AKA functional) indexes

  #28360 opened Jul 2, 2022

• EF 6 .0 GroupBy select Top N Query Count() Throw Exception

  #28353 opened Jul 1, 2022

• Merge property overrides when a new base type is set

  #28352 opened Jun 30, 2022

• Unable to translate set operation when using concise C# records for projection

  #28350 opened Jun 30, 2022

• Down with a Sequence generated in incorrect order

  #28349 opened Jun 30, 2022

• net sdk 6.0.6 hostfxr.dll is not found

  #28344 opened Jun 29, 2022

• Interceptors for EnsureDeleted/EnsureCreated

  #28343 opened Jun 29, 2022

• Separate conventions into groups/tags

  #28340 opened Jun 28, 2022

• Further update pipeline improvements for seeding

  #28339 opened Jun 28, 2022

• dotnet ef dbcontext scaffold works fine when executed from command line, but not when executed from code

  #28333 opened Jun 28, 2022

• Deadlock on deleting separate entities in parallel

  #28331 opened Jun 28, 2022

• Add-Migration mysteriously retrieves old migration information

  #28316 opened Jun 26, 2022

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

• Json Columns initial work

  #28171 commented on Jul 1, 2022 • 114 new comments

• Plan for Entity Framework Core 7.0

  #26994 commented on Jul 1, 2022 • 7 new comments

• Allow passing in other arguments to msbuild when building project with dotnet ef.

  #28306 commented on Jun 30, 2022 • 6 new comments

• Custom aggregate translations

  #28110 commented on Jun 30, 2022 • 5 new comments

• JSON: Support [JsonStringEnumConverter]

  #27828 commented on Jul 3, 2022 • 4 new comments

• Changes in parent owned collection cause unexpected behavior in nested owned collection

  #27918 commented on Jun 28, 2022 • 3 new comments

• DbCommand failure message doesn't include exception details

  #24530 commented on Jun 29, 2022 • 3 new comments

• EFCore Many to many join tables are no longer mapped

  #28296 commented on Jun 29, 2022 • 3 new comments

• Setting Up and Initializing Column Encryption with MSSQL Always Encrypted

  #23970 commented on Jun 29, 2022 • 3 new comments

• CSharpHelper: support more types of collection literals

  #19274 commented on Jun 27, 2022 • 2 new comments

• Support Caching and SqlCacheDependencies (or other second-level cache solution) as a built-in Feature

  #27735 commented on Jun 28, 2022 • 2 new comments

• SQLite: Make async methods real asynchronous or at least add await Task.Yield() calling to them

  #28279 commented on Jun 29, 2022 • 2 new comments

• Support arrays of primitive types in in-memory database

  #11926 commented on Jul 2, 2022 • 2 new comments

• Translate int.Parse and similar

  #28287 commented on Jun 27, 2022 • 1 new comment

• Owned attribute adds TempId column to principal entity when foreign key type has conversion

  #27549 commented on Jun 27, 2022 • 1 new comment

• Why does Npgsql join the same table multiple times on the same key

  #28312 commented on Jun 28, 2022 • 1 new comment

• EntityFrameworkCore 3.1.26 on WIndows 10 LTSB 2015 (.NET 4.6.2 Application)

  #28284 commented on Jun 29, 2022 • 1 new comment

• Add a pubternal way to clear ServiceProviderCache

  #27189 commented on Jun 29, 2022 • 1 new comment

• Allow method/member translators to provide translation failure error details

  #26410 commented on Jun 29, 2022 • 1 new comment

• Cosmos: Support aggregate operators

  #16146 commented on Jun 29, 2022 • 1 new comment

• Allow IndexAttribute on properties

  #23154 commented on Jun 30, 2022 • 1 new comment

• Update ASP.Net tests

  #28313 commented on Jun 30, 2022 • 1 new comment

• Discussion for possible implementation of a Snowflake database provider

  #15732 commented on Jul 1, 2022 • 1 new comment

• Couchbase provider discussion

  #14452 commented on Jul 1, 2022 • 1 new comment

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

  #24493 commented on Jul 1, 2022 • 1 new comment

• Add-Migration fails with "An item with the same key has already been added" when renaming entity

  #27504 commented on Jul 3, 2022 • 1 new comment

• Relational: Entity splitting support

  #620 commented on Jun 28, 2022 • 0 new comments

• Improve Migrations data seeding

  #22947 commented on Jun 28, 2022 • 0 new comments

• Deliver highly-requested user features for EF Core

  #24107 commented on Jun 28, 2022 • 0 new comments

• Improvements to change tracking

  #22954 commented on Jun 28, 2022 • 0 new comments

• Improve experience for managing migrations

  #22945 commented on Jun 28, 2022 • 0 new comments

• Improve data access performance

  #24110 commented on Jun 28, 2022 • 0 new comments

• Cosmos: Use the V4 SDK

  #18753 commented on Jun 28, 2022 • 0 new comments

• Cosmos: Allow to use a custom JSON serializer

  #17306 commented on Jun 28, 2022 • 0 new comments

• Support for JsonDocument type in Cosmos provider

  #20584 commented on Jun 28, 2022 • 0 new comments

• Remove or internalize JSON.NET dependency in Cosmos Provider

  #14570 commented on Jun 28, 2022 • 0 new comments

• Expose model building conventions to applications

  #214 commented on Jun 28, 2022 • 0 new comments

• Get pending migrations using .NET Core CLI

  #28283 commented on Jun 29, 2022 • 0 new comments

• Regression in 6.0.2: The variable name '@p0' has already been declared.

  #27427 commented on Jun 29, 2022 • 0 new comments

• Cosmos: Avoid projecting contained properties

  #16142 commented on Jun 29, 2022 • 0 new comments

• Cosmos: Improve exception message when subquery pushdown is needed

  #16156 commented on Jun 29, 2022 • 0 new comments

• Cosmos: Translate non-persisted property in query when possible

  #17670 commented on Jun 29, 2022 • 0 new comments

• Query: Support GroupJoin when it is final query operator

  #19930 commented on Jun 29, 2022 • 0 new comments

• Cosmos: Detect partition key filters in more queries

  #20350 commented on Jun 29, 2022 • 0 new comments

• EFCore 3.1 + CosmosDb can't translate any() on owned object

  #20441 commented on Jun 29, 2022 • 0 new comments

• Cosmos: bad exception for queries with aggregate selecting non-mapped type

  #20677 commented on Jun 29, 2022 • 0 new comments

• Cosmos: Improve materialization exceptions

  #22374 commented on Jun 29, 2022 • 0 new comments

• Add navigation configuration overloads for shared type entity types

  #23255 commented on Jun 29, 2022 • 0 new comments

• Cosmos: Improve query tree during translation

  #23538 commented on Jun 29, 2022 • 0 new comments

• Cosmos: add support for pagination (MaxItemCount)

  #24513 commented on Jun 29, 2022 • 0 new comments

• Cosmos: Allow terminating operators after Skip and Take

  #24571 commented on Jun 29, 2022 • 0 new comments

• Cosmos: translate Length/Count on collections

  #25700 commented on Jun 29, 2022 • 0 new comments

• Cosmos: translate indexing into collection

  #25701 commented on Jun 29, 2022 • 0 new comments

• Cosmos: Issues when loading derived type via base set and vice versa

  #25886 commented on Jun 29, 2022 • 0 new comments

• GroupBy debug assert: Missing alias in the list: p1,p

  #26104 commented on Jun 29, 2022 • 0 new comments

• Sequence contains no elements running in-memory query with class key

  #26238 commented on Jun 29, 2022 • 0 new comments

• Cosmos: Average truncates results

  #26378 commented on Jun 29, 2022 • 0 new comments

• InMemory: Use deferredOwnedExpansionExpression

  #26618 commented on Jun 29, 2022 • 0 new comments

• Check parameters for nullable types in EF.Functions extensions

  #26634 commented on Jun 29, 2022 • 0 new comments

• Cosmos: translate array projection

  #26662 commented on Jun 29, 2022 • 0 new comments

• Operations on IQueryable after GroupBy.Select

  #26748 commented on Jun 29, 2022 • 0 new comments

• Query: Property binding on the result entity from grouping.First

  #26753 commented on Jun 29, 2022 • 0 new comments

• Warn/throw when non-deterministic split query may return wrong results

  #26808 commented on Jun 29, 2022 • 0 new comments

• Cosmos: Selecting complex properties (object or collections mapped as "OwnsOne" and "OwnsMany") makes the query return the entire document

  #27440 commented on Jun 29, 2022 • 0 new comments

• The LINQ expression 'ProjectionBindingExpression: 0/1/2' could not be translated.

  #28125 commented on Jun 29, 2022 • 0 new comments

• ArgumentOutOfRangeException thrown on query with projection for entity containing owned types

  #28137 commented on Jun 29, 2022 • 0 new comments

• Nested query, let clause, select enum issue

  #28170 commented on Jun 29, 2022 • 0 new comments

• Support raw SQL queries without defining an entity type for the result

  #10753 commented on Jun 29, 2022 • 0 new comments

• Select + Distinct + Select Collection results in incorrect SQL and results

  #24263 commented on Jun 29, 2022 • 0 new comments

• Add interception for transaction enlistment

  #16261 commented on Jun 30, 2022 • 0 new comments

• Add interception for execution strategies

  #16257 commented on Jun 30, 2022 • 0 new comments

• Add support for provider convention types

  #19806 commented on Jun 30, 2022 • 0 new comments

• Investigate slow text templating tests on Linux

  #27598 commented on Jul 1, 2022 • 0 new comments

• RevEng: Enable generating IEntityTypeConfiguration classes (avoids large OnModelCreating)

  #8434 commented on Jul 1, 2022 • 0 new comments

• Design: Generate more code using IAnnotationCodeGenerator

  #21882 commented on Jul 1, 2022 • 0 new comments

• Update formatting code for double-nested lambdas

  #26349 commented on Jul 1, 2022 • 0 new comments

• TPC migration attempts to drop nonexistent table for base type

  #28298 commented on Jul 2, 2022 • 0 new comments

• DbSet names are not used for table names in TPT and TPC mappings

  #28193 commented on Jul 2, 2022 • 0 new comments

• Add support for Global Query Filters on derived types.

  #27978 commented on Jul 2, 2022 • 0 new comments