Deferred and immediate executions in LINQ

We will create a simple list of strings and query the list through LINQ.

static void Main(string[] args)
{
    List<String> strlist = new List<string>() { "string 1", "string 2", "string 3", "string 4" };
    var q = from strings in strlist
    select strings;
    foreach (string str in q)
    {
        Console.WriteLine(str);
    }
    Console.ReadKey();
}

The output of the above program is



Now refer to the image below



How can we check that what we have mentioned in the above image is correct ? Let us add one more string AFTER the LINQ query.



So what's the output now ?



When we added "string 5" after the query, it was still considered in the FOREACH loop. So we can say that with foreach loop, the query was executed only when the values were required.

We can also make the query execute where it was defined by using. ToList() or ToArray() on the LINQ query which will cause the immediate execution of the LINQ query.



And the output is



The query was executed before the foreach loop at the query definition itself because of the use to ToArray() method.

The immediate execution in a LINQ query also takes place if the query is returning single value, like the COUNT for instance

    int count = (from strings in strlist
    select strings).Count();

This query will get executed immediately and assign the count to the variable.