Query Syntax vs Method Syntax Architecture

Evaluate when to use the syntactic sugar of query expressions versus the functional composition of lambda methods.