When should you use LINQ in C#?

Use LINQ when it makes intent clearer, but inspect generated SQL for provider queries and profile hot in-memory paths.