.NET / Asp.Net Core / C# / Entity Framework

Stop Calling ToList() Too Early – Improve LINQ Performance

- - ErcanOPAK

Calling ToList() too early forces premature execution.

// Bad
var items = db.Users.ToList().Where(...);

// Good
var items = db.Users.Where(...).ToList();

 

Let the database handle filtering and execution.

Related posts:

.NET Core Memory Grows Without Leaks

Observability — Logs Without Correlation IDs Are Noise

What is the purpose of nameof in C#?

Post Views: 6