LINQ Querying

Writing queries as LINQ over IQueryable and knowing what EF can actually translate: deferred execution, projections, filtering, grouping, joins, raw SQL escapes, and where client-side evaluation takes over. Interviewers ask because the IQueryable-versus-IEnumerable distinction decides whether filtering happens in the database or in your process memory.