One ASP.NET (http://ASP.NET) Core endpoint can hide dozens of database round trips. In my public ...One ASP.NET (http://ASP.NET) Core endpoint can hide dozens of database round trips. In my public ...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Daniil's avatar
Daniil Taushkanov
• 1d
One ASP.NET Core endpoint can hide dozens of database round trips.
In my public .NET audit demo, an orders endpoint loaded a list and then queried the customer table inside a loop. That creates an N+1 query pattern: 1 order query + N customer queries.
Risk: latency and database load grow with every item returned.
Remediation: • server-side projection • AsNoTracking for read-only work • bounded pagination • query-count validation in tests
The focused remediation PR also fixes four other priority findings: DbContext lifetime, unauthenticated admin access, committed secrets, and unbounded materialization.
Demo report and code: https://github.com/Dalkory/DotnetAuditDemo
I provide fixed-scope, asynchronous .NET Backend & AI Readiness Audits with a written report, prioritized backlog, effort estimates, and recorded walkthrough.

asp.net

ASP.NET Core | Open-source web framework for .NET

Build web apps and services that run on Windows, Linux, and macOS using C#, HTML, CSS, and JavaScript. Get started for free on Windows, Linux, or macOS.

Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started