CountVersusSkipAndAny.cs

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;

namespace QueryTests
{
    class Program
    {
        static void Main(string[] args)
        {
            //RecreateDB();
            using (CustomersContext db = new CustomersContext())
            {
                int count = db.Customers.Where(c => c.Age == 26).Count();
                Console.WriteLine(count);

                bool moreThanOne = db.Customers.Where(c => c.Age == 26).OrderBy(c => c.ID).Skip(1).Any();
                Console.WriteLine(moreThanOne);
            }
        }

        private static void RecreateDB()
        {
            using (CustomersContext db = new CustomersContext())
            {
                db.Database.Delete();
                db.Database.Create();
                db.SaveChanges();
            }

            for (int j = 0; j < 100; j++)
            {
                using (CustomersContext db = new CustomersContext())
                {
                    Random r = new Random();
                    for (int i = 0; i < 1000; i++)
                    {
                        Customer c = new Customer
                        {
                            Name = Guid.NewGuid().ToString(),
                            Age = r.Next(0, 100)
                        };
                        db.Customers.Add(c);
                    }
                    db.SaveChanges();
                }
                Console.WriteLine(j);
            }
        }
    }

    public class Customer
    {
        public int ID { get; set; }
        public string Name { get; set; }
        public int Age { get; set; }
    }

    public class CustomersContext : DbContext
    {
        public DbSet<Customer> Customers { get; set; }
    }
}