Deferred execution behavior in C Sharp (C#) - Mini Project: Build & Apply

Understanding Deferred Execution in C#

📖 Scenario: Imagine you have a list of numbers and you want to find all numbers greater than a certain value. In C#, queries using LINQ are not run immediately but only when you actually use the results. This is called deferred execution.

🎯 Goal: You will create a list of numbers, set a threshold value, write a LINQ query to select numbers greater than the threshold, and then print the results to see deferred execution in action.

📋 What You'll Learn

Create a list of integers called numbers with the values 1, 3, 5, 7, 9

Create an integer variable called threshold and set it to 4

Write a LINQ query called filteredNumbers that selects numbers greater than threshold

Print each number in filteredNumbers using a foreach loop

💡 Why This Matters

🌍 Real World

Filtering data based on conditions is common in apps like shopping sites, where you show products above a certain price.

💼 Career

Understanding deferred execution helps you write efficient C# code that only processes data when needed, saving time and resources.

1

Create the list of numbers

Create a list of integers called numbers with these exact values: 1, 3, 5, 7, 9.

C Sharp (C#)

# Create the list of numbers
// Your code here

Hint

Use List<int> and initialize it with the values inside curly braces.

2

Set the threshold value

Create an integer variable called threshold and set it to 4.

C Sharp (C#)

using System.Collections.Generic;

List numbers = new List { 1, 3, 5, 7, 9 };

// Create the threshold variable
// Your code here

Hint

Use int threshold = 4; to create the variable.

3

Write the LINQ query with deferred execution

Write a LINQ query called filteredNumbers that selects numbers from numbers greater than threshold. Use var filteredNumbers = numbers.Where(n => n > threshold);.

C Sharp (C#)

using System.Collections.Generic;
using System.Linq;

List numbers = new List { 1, 3, 5, 7, 9 };

int threshold = 4;

// Write the LINQ query to select numbers greater than threshold
// Your code here

Hint

Use numbers.Where(n => n > threshold) to create the query.

4

Print the filtered numbers

Use a foreach loop to print each number in filteredNumbers on its own line.

C Sharp (C#)

using System.Collections.Generic;
using System.Linq;

List numbers = new List { 1, 3, 5, 7, 9 };

int threshold = 4;

var filteredNumbers = numbers.Where(n => n > threshold);

// Print each number in filteredNumbers
// Your code here

Hint

Use foreach (int number in filteredNumbers) and Console.WriteLine(number); inside the loop.

Practice

1. What does deferred execution mean in C# LINQ queries?

easy

A. The query runs only when you actually use its results.

B. The query runs immediately when it is defined.

C. The query results are stored permanently in memory.

D. The query runs multiple times automatically without control.

Solution

1. Step 1: Understand when LINQ queries run

   LINQ queries in C# do not run when defined but wait until their results are needed.

2. Step 2: Identify deferred execution meaning

   This means the query is executed only when you iterate over it or call methods like Count().

3. Final Answer:

   The query runs only when you actually use its results. -> Option A

4. Quick Check:

   Deferred execution = run when used [OK]

Hint: Deferred means delay running until results are needed [OK]

Common Mistakes:

• Thinking queries run immediately when defined
• Assuming results are stored permanently
• Believing queries run automatically multiple times

2. Which of the following C# code snippets correctly triggers deferred execution of a LINQ query?

easy

A. var result = numbers.Where(n => n > 5);

B. var filtered = numbers.Where(n => n < 3);

C. var query = numbers.Select(n => n * 2);

D. var count = numbers.Where(n => n > 5).Count();

Solution

1. Step 1: Identify code that triggers execution

   Calling Count() forces the query to run immediately and count matching elements.

2. Step 2: Compare other options

   The other options only define queries but do not execute them until iterated or a method like Count() is called.

3. Final Answer:

   var count = numbers.Where(n => n > 5).Count(); -> Option D

4. Quick Check:

   Calling Count() triggers execution [OK]

Hint: Methods like Count() force query to run immediately [OK]

Common Mistakes:

• Assuming query runs when assigned to a variable
• Confusing query definition with execution
• Not knowing which methods trigger execution

3. What will be the output of this C# code?

var numbers = new List<int> {1, 2, 3};
var query = numbers.Select(n => n * 2);
numbers.Add(4);
foreach(var num in query) Console.Write(num + " ");

medium

A. 2 4 6 8

B. 2 4 6

C. 1 2 3 4

D. 4 6 8

Solution

1. Step 1: Understand deferred execution with Select

   The query uses deferred execution, so it runs when the foreach starts, not when defined.

2. Step 2: Check list changes before execution

   Since numbers.Add(4) happens before foreach, the query sees the updated list including 4.

3. Final Answer:

   2 4 6 8 -> Option A

4. Quick Check:

   Deferred execution includes added item [OK]

Hint: Deferred queries reflect list changes before iteration [OK]

Common Mistakes:

• Thinking query runs at definition ignoring added items
• Confusing output with original list values
• Ignoring that foreach triggers execution

4. Identify the error in this code that prevents deferred execution from working as expected:

var numbers = new List<int> {1, 2, 3};
var query = numbers.Where(n => n > 1).ToList();
numbers.Add(4);
foreach(var num in query) Console.Write(num + " ");

medium

A. foreach loop syntax is invalid.

B. Using ToList() executes query immediately, so added item is ignored.

C. Cannot add items to a list after query definition.

D. The Where clause syntax is incorrect.

Solution

1. Step 1: Check effect of ToList()

   Calling ToList() executes the query immediately and stores results in a new list.

2. Step 2: Analyze list modification after execution

   Adding 4 to numbers after ToList() does not affect query because it is already a fixed list.

3. Final Answer:

   Using ToList() executes query immediately, so added item is ignored. -> Option B

4. Quick Check:

   ToList() disables deferred execution [OK]

Hint: ToList() runs query immediately, no deferred execution [OK]

Common Mistakes:

• Thinking ToList() keeps query deferred
• Believing list changes affect ToList() results
• Misreading Where clause syntax

5. You want to create a LINQ query that filters out numbers less than 5 and then doubles them, but you also want to avoid re-running the query multiple times for performance. Which approach correctly applies deferred execution but avoids repeated execution?

hard

A. Use a foreach loop inside the query to process items.

B. Define the query with var q = numbers.Where(n => n >= 5).Select(n => n * 2); and use it multiple times directly.

C. Define the query and immediately call ToList() to store results: var q = numbers.Where(n => n >= 5).Select(n => n * 2).ToList();

D. Call Count() on the query before using it to force execution.

Solution

1. Step 1: Understand deferred execution and repeated use

   Using the query directly runs it every time you iterate, which can be slow if repeated.

2. Step 2: Use ToList() to cache results

   Calling ToList() runs the query once and stores results, so repeated use is fast without re-executing.

3. Final Answer:

   Define the query and immediately call ToList() to store results. -> Option C

4. Quick Check:

   ToList() caches results, avoids repeated execution [OK]

Hint: Use ToList() to run once and reuse results efficiently [OK]

Common Mistakes:

• Using query directly causing multiple executions
• Misusing foreach inside query definition
• Calling Count() only counts, does not cache results