EFCore Many-to-Many: any way to prevent inefficient sub-select without a round-trip?

This page summarizes the projects mentioned and recommended in the original post on /r/csharp
ORM entity-framework Database C# dotnet-core

InfluxDB
Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
Our great sponsors

  • Entity Framework

    EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.

    • I think you're seeing the same issue as I saw here: https://github.com/dotnet/efcore/issues/19418 - I think you may have commented on a linked/related issue (the code looks familiar).

  • efcore-m2m

    Reproduction repo for EFCore M2M mapping sub-select issue.

    • We can see this as a huge CPU spike when it occurs and the query takes ~16s to complete (the code above is just a minimum repro example and I have a standalone repo here with two branches with different approaches to see if I could coerce EFC7 to generate the correct query).

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts