In LINQ, Don't Use Count() When You Mean Any()
April 21, 2010
Author: Craig Stuntz
If you have a list, array, or query in a C#/LINQ application and need to check and see if the list is empty, the correct way to do this is to use the Any() extension method:
if (q.Any())
{
Similarly, you can check to see if any elements in the list meet a certain condition:
if (q.Any(i => i.IsSpecial))
{
If the query provider is something like LINQ to Entities…