We recently engaged with a client reporting performance issues with their product. It was a legacy ASP .NET application using Entity Framework to connect to a Microsoft SQL Server database.

The Hacker News (THN) is a leading cybersecurity news and information portal that covers the latest security vulnerabilities, cyber threats, and data breaches. With  articles, analysis, and expert commentary, THN helps developers and security professionals stay informed about emerging threats and trends in the cybersecurity landscape. Developers can learn how to secure their applications and infrastructure by staying up-to-date with the latest security news and best practices.

This Dot

A legacy ASP .NET application using Entity Framework faced performance issues due to misuse of ORM tools. The post discusses common ORM misuse patterns like N+1 queries, eager versus lazy loading, and lack of indexes. It provides examples using TypeORM with practical suggestions to improve performance, including prefetching data, avoiding unnecessary data loading, and optimizing database indexes.

The Dangers of ORMs and How to Avoid Them