In this article, I will show the most performant way to write queries for a collection of objects in .Net Core. The article discusses the common methods of LINQ and their comparison. After reading this article, you may have to review your project code!
Comparisons were made between query syntax, called LINQ, and method syntax called LAMBDA.
💡 Connect with me on LinkedIn: https://www.linkedin.com/in/hussein-nm/
✨ Where()
LINQ_Where (Method name):
LAMBDA_Where:
🚀 Performance
Which one do you think is faster?
In this simple performance query, both methods are similar.
✨ Any()
LINQ_Any:
LAMBDA_Where_Any:
LAMBDA_Any:
🚀 Performance
Using Any() as the LAMBDA_Any method is faster.
✨ First()
LINQ_First:
LAMBDA_Where_First:
LAMBDA_First:
🚀 Performance
Using First() as the method a LAMBDA call is faster.
✨ FirstOrDefault()
LINQ_FirstOrDefault:
LAMBDA_Where_FirstOrDefault:
LAMBDA_FirstOrDefault:
🚀 Performance
Using FirstOrDefault() as the method a LAMBDA call is faster.
✨ Last()
LINQ_Last:
LAMBDA_Where_Last:
LAMBDA_Last:
🚀 Performance
Using Last() as the method a LAMBDA call is faster.
✨ LastOrDefault()
LINQ_LastOrDefault:
LAMBDA_Where_LastOrDefault:
LAMBDA_LastOrDefault:
🚀 Performance
Using LastOrDefault() as the method a LAMBDA call is faster.
Conclusion
As shown in this article, you should always use Any(), First(), FirstOrDefault(), Last(), LastOrDefault, or Where() at the beginning of a LAMBDA statement.
