LINQ

Query syntax versus method syntax, deferred versus immediate execution, IEnumerable versus IQueryable, the core operators, and expression trees. Interviewers ask because knowing where a query actually runs — in memory or translated to SQL — is the difference between a fast endpoint and an accidental full table scan.