Return Multiple Result Sets or DataSet Using Entity Framework
The article discusses optimizing database calls by minimizing database round trips, utilizing ADO.NET and custom mappers even in applications using Entity Framework. [ more ]
| 09. Query Optimization | Data Modeling Deep Dive
Optimizing database queries can greatly improve web application performance and reduce the need for expensive hardware scaling or caching solutions. [ more ]