Query Syntax vs Method Syntax

Easy0-2 Years

Query Syntax

var employees =
from e in employeeList
where e.Age > 25
select e;

Method Syntax

var employees = employeeList
    .Where(e => e.Age > 25)
    .ToList();

Differences

Query Syntax Method Syntax
SQL-like Uses Lambda
Easy for beginners Preferred in projects
Limited operators Supports all operators

Interview Tips

Method Syntax is used in almost every enterprise application.