The Query Operators are executed only when enumerated except few scenarios. For example, when you use the for/Foreach statement and iterate the items from the query result.
Below is a sample code demonstrating the Deferred Execution in C#.
Deferred Execution Example in LINQ and C#
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
namespace AbundantCode
{
internal class Program
{
// Deferred Execution Example in LINQ and C#
private static void Main(string[] args)
{
List<int> nos = new List<int>();
nos.Add(100);
nos.Add(101);
var Output = nos.Where(a => a % 2 == 0);
// New element added after retreival in Output
nos.Add(102);
foreach (var no in Output)
Console.WriteLine(no);
Console.ReadLine();
}
}
}