Comprehension Queries are used for user friendly, but the thing is there query are converted into lamda internally for execution. So lamda expressions are fast.

Comprehension queries:

int[] array = new int[7] { 0, 1, 2, 3, 4, 5, 6 };

var query = (from no in array

where (no % 3 == 0)

select no).ToArray();

foreach (int no in query)

{

Console.WriteLine("{0,1}", no);

}

Lamda Queries:

string[] stringarray = { "How", "are", "you" };

IEnumerable<string> result = Enumerable.Where(stringarray, o => o.Length == 3);

foreach (string res in result)

Console.WriteLine(res);