In LINQ, Don’t Use Count() When You Mean Any()
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 [...]
Tagged entity framework, linq, linq to sql