Immediate execution methods in C Sharp (C#) - Cheat Sheet & Quick Revision

Recall & Review

beginner

What are immediate execution methods in C# LINQ?

Immediate execution methods run the query right away and return a result immediately, unlike deferred execution which waits until the data is needed.

beginner

Name three common immediate execution methods in C# LINQ.

Common immediate execution methods include ToList(), ToArray(), and Count().

intermediate

What is the difference between ToList() and Count() in terms of immediate execution?

ToList() creates a new list with all elements immediately, while Count() immediately calculates how many elements are in the sequence.

intermediate

Why might you use an immediate execution method instead of deferred execution?

You use immediate execution when you want to get the results right away, for example to avoid multiple enumerations or to capture the current state of data.

advanced

What happens if you call ToList() on a LINQ query multiple times?

Each call to ToList() executes the query again and creates a new list, which can be inefficient if the source data changes or is expensive to query.

Which of the following is an immediate execution method in C# LINQ?

A Where()

B ToList()

C Select()

D OrderBy()

ToList() immediately executes the query and returns a list. The others use deferred execution.

What does the Count() method do in LINQ?

A Sorts the elements

B Filters elements based on a condition

C Returns the number of elements immediately

D Projects each element into a new form

Count() immediately counts and returns the number of elements in the sequence.

Calling ToArray() on a LINQ query will:

A Sort elements without execution

B Return a query that runs later

C Filter elements lazily

D Return an array immediately with all elements

ToArray() forces immediate execution and returns an array of the results.

Which method does NOT cause immediate execution?

A Select()

B ToList()

C First()

D Count()

Select() uses deferred execution and does not run the query immediately.

Why is immediate execution useful?

A To get results right away and avoid multiple enumerations

B To delay query execution until needed

C To create a query expression only

D To sort data without running the query

Immediate execution runs the query and returns results immediately, which can improve performance and consistency.

Explain what immediate execution methods are in LINQ and give examples.

Think about when the query runs and returns results.

Describe a situation where using an immediate execution method is better than deferred execution.

Consider when you want to fix the data results right away.

Practice

1. Which of the following methods in C# causes immediate execution of a LINQ query?

easy

A. ToList()

B. Where()

C. Select()

D. OrderBy()

Solution

1. Step 1: Understand deferred vs immediate execution

   Methods like Where(), Select(), and OrderBy() only build the query and do not execute it immediately.

2. Step 2: Identify immediate execution methods

   ToList() forces the query to run and returns a list immediately.

3. Final Answer:

   ToList() -> Option A

4. Quick Check:

   Immediate execution = ToList() [OK]

Hint: Immediate methods like ToList() run queries right away [OK]

Common Mistakes:

• Confusing deferred methods like Where() as immediate
• Thinking Select() executes query immediately
• Assuming OrderBy() runs query instantly

2. Which of the following is the correct syntax to immediately get the count of elements in a LINQ query numbers?

easy

A. int count = numbers.Count;

B. int count = Count(numbers);

C. int count = numbers.Count();

D. int count = numbers.Count[];

Solution

1. Step 1: Recognize Count() as a method

   In LINQ, Count() is a method that must be called with parentheses to execute immediately.

2. Step 2: Check syntax correctness

   numbers.Count() is the correct syntax; Count without parentheses is a property, which does not exist here.

3. Final Answer:

   int count = numbers.Count(); -> Option C

4. Quick Check:

   Count() method needs parentheses [OK]

Hint: Count() always needs parentheses to execute immediately [OK]

Common Mistakes:

• Using Count without parentheses
• Trying to call Count as a standalone function
• Using invalid syntax like Count[]

3. What is the output of the following code?

var numbers = new List<int> {1, 2, 3, 4};
var result = numbers.Where(n => n > 2).Count();
Console.WriteLine(result);

medium

A. 0

B. 3

C. 4

D. 2

Solution

1. Step 1: Filter numbers greater than 2

   The Where method filters numbers: 3 and 4 satisfy the condition, so filtered list is [3,4].

2. Step 2: Count the filtered elements

   Count() returns the number of elements in the filtered list, which is 2.

3. Final Answer:

   2 -> Option D

4. Quick Check:

   Count of numbers > 2 = 2 [OK]

Hint: Count() after Where() counts filtered items immediately [OK]

Common Mistakes:

• Counting original list length instead of filtered
• Confusing Count() with deferred execution
• Assuming Where() returns count directly

4. Identify the error in this code snippet:

var list = new List<string> {"apple", "banana"};
var first = list.First;
Console.WriteLine(first);

medium

A. Missing parentheses after First method

B. List initialization syntax is wrong

C. Console.WriteLine cannot print strings

D. First method does not exist on List

Solution

1. Step 1: Check usage of First method

   First is a method and requires parentheses to execute immediately.

2. Step 2: Identify syntax error

   Code uses list.First without parentheses, which causes a compile-time error.

3. Final Answer:

   Missing parentheses after First method -> Option A

4. Quick Check:

   First() needs () to run immediately [OK]

Hint: Always add () when calling immediate execution methods [OK]

Common Mistakes:

• Forgetting parentheses on First()
• Thinking First is a property
• Misunderstanding List initialization syntax

5. Given a list of integers, how can you immediately get a list of only even numbers using LINQ and immediate execution methods?

hard

A. var evens = numbers.Where(n => n % 2 == 0);

B. var evens = numbers.Where(n => n % 2 == 0).ToList();

C. var evens = numbers.Select(n => n % 2 == 0).ToList();

D. var evens = numbers.ToList().Where(n => n % 2 == 0);

Solution

1. Step 1: Filter even numbers with Where()

   Where(n => n % 2 == 0) filters the list to only even numbers.

2. Step 2: Use ToList() for immediate execution

   Calling ToList() after filtering runs the query immediately and returns a list of even numbers.

3. Final Answer:

   var evens = numbers.Where(n => n % 2 == 0).ToList(); -> Option B

4. Quick Check:

   Filter then ToList() = immediate even list [OK]

Hint: Chain Where() then ToList() for immediate filtered list [OK]

Common Mistakes:

• Not calling ToList() to force immediate execution
• Calling ToList() before Where(), which returns full list
• Using Select() incorrectly to filter