Jalal Alzebda on LinkedIn: #csharp #dotnet #programming #cleancode #aspnetcore #performancetips | 14 comments
OrderBy doesn't work if ThenInclude uses (or how to order nested collection) · Issue #9445 · dotnet/efcore · GitHub
EF Core creates SQL query with ORDER BY at the end massively impacting performance for cases with many included collections · Issue #27026 · dotnet/efcore · GitHub
![Optimizing Entity Framework Core Database Queries With Dynamic Program Analysis | The .NET Tools Blog Optimizing Entity Framework Core Database Queries With Dynamic Program Analysis | The .NET Tools Blog](https://blog.jetbrains.com/wp-content/uploads/2023/02/image-15.png)
Optimizing Entity Framework Core Database Queries With Dynamic Program Analysis | The .NET Tools Blog
OrderBy on column 2 or more navigation properties away + .Include throws exception · Issue #3811 · dotnet/efcore · GitHub
![Optimizing Entity Framework Core Database Queries With Dynamic Program Analysis | The .NET Tools Blog Optimizing Entity Framework Core Database Queries With Dynamic Program Analysis | The .NET Tools Blog](https://blog.jetbrains.com/wp-content/uploads/2023/02/image-13.png)