Which LINQ syntax is better?

There are multiple ways to write a LINQ query in C#:

• Use query (comprehension) syntax.
• Use method or Fluent syntax.
• Use a combination of query syntax and method syntax.

So which syntax is better?

MSDN recommends writing most queries using query syntax to create query expressions. The general opinion in this StackOverflow thread seems to be - "it depends".