Why advanced LINQ matters in C Sharp (C#) - Challenge Your Understanding

Challenge - 5 Problems

❓ Predict Output

intermediate

What is the output of this LINQ query with grouping?

Consider the following C# code using LINQ to group numbers by their remainder when divided by 3. What will be printed?

C Sharp (C#)

var numbers = new[] {1, 2, 3, 4, 5, 6};
var groups = numbers.GroupBy(n => n % 3).OrderBy(g => g.Key);
foreach (var group in groups)
{
    Console.Write($"{group.Key}: ");
    foreach (var num in group)
        Console.Write(num + " ");
    Console.WriteLine();
}

A

0: 3 6 
1: 1 4 
2: 2 5 

B

0: 3 6 
1: 1 2 
2: 4 5 

C

0: 6 3 
1: 1 4 
2: 2 5 

D

0: 3 6 
1: 4 1 
2: 5 2 

💡 Hint

Remember that GroupBy preserves the order of elements within each group.

The GroupBy groups numbers by their remainder when divided by 3. Numbers 3 and 6 have remainder 0, 1 and 4 have remainder 1, and 2 and 5 have remainder 2. The order inside each group is preserved from the original array.

🧠 Conceptual

intermediate

Why use deferred execution in LINQ?

Which of the following best explains the advantage of deferred execution in LINQ?

A It forces all data to be loaded from the database at once to avoid multiple calls.

B It allows queries to be executed immediately and results stored in memory.

C It converts LINQ queries into SQL statements automatically.

D It delays query execution until the results are actually needed, improving performance and resource use.

💡 Hint

Think about when the data is actually fetched or processed.

Deferred execution means the query is not run until you iterate over the results. This can save time and memory by avoiding unnecessary work.

❓ Predict Output

advanced

What is the output of this LINQ query with SelectMany?

Given the following code, what will be printed?

C Sharp (C#)

var data = new[] { new[] {1, 2}, new[] {3, 4}, new[] {5} };
var result = data.SelectMany(arr => arr.Where(x => x % 2 == 0));
foreach (var num in result)
{
    Console.Write(num + " ");
}

A 2 4 5

B 1 2 3 4 5

C 2 4

D 1 3 5

💡 Hint

SelectMany flattens collections and Where filters elements.

SelectMany flattens the arrays into one sequence, but only elements that are even (x % 2 == 0) are selected. So only 2 and 4 are printed.

🔧 Debug

advanced

What error does this LINQ code produce?

Examine the following code snippet. What error will it cause when run?

C Sharp (C#)

var list = new List<int> {1, 2, 3};
var query = list.Select(x => x / (x - 2));
foreach (var val in query)
{
    Console.Write(val + " ");
}

A NullReferenceException

B DivideByZeroException

C InvalidOperationException

D No error, outputs: 1 2 3

💡 Hint

Check what happens when x equals 2.

When x is 2, the expression x - 2 is zero, causing a division by zero error during query execution.

🚀 Application

expert

How many items are in the resulting dictionary?

Consider this LINQ query that creates a dictionary from a list of strings. How many items will the dictionary contain?

C Sharp (C#)

var words = new List<string> {"apple", "banana", "apricot", "blueberry", "avocado"};
var dict = words.GroupBy(w => w[0])
                .ToDictionary(g => g.Key, g => g.Count());
Console.WriteLine(dict.Count);

A 3

B 4

C 5

D 2

💡 Hint

Look at the first letters of each word and count unique letters.

The words start with 'a' (apple, apricot, avocado) and 'b' (banana, blueberry). So there are 2 unique keys: 'a' and 'b'. The dictionary will have 2 items.

Practice

1. What is the main benefit of using advanced LINQ in C# programming?

easy

A. It automatically fixes bugs in your code.

B. It makes the program run faster by using less memory.

C. It replaces the need for any loops in your program.

D. It simplifies complex data queries into readable code.

Solution

1. Step 1: Understand LINQ's purpose

   LINQ is designed to query and manipulate data collections easily.

2. Step 2: Identify the main benefit

   Advanced LINQ makes complex data queries simpler and more readable.

3. Final Answer:

   It simplifies complex data queries into readable code. -> Option D

4. Quick Check:

   Advanced LINQ = Simplifies queries [OK]

Hint: Think: LINQ turns complex data tasks into simple code [OK]

Common Mistakes:

• Confusing LINQ with performance optimization
• Believing LINQ fixes bugs automatically
• Thinking LINQ removes all loops

2. Which of the following is the correct syntax to filter a list of numbers using LINQ to select only even numbers?

easy

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

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

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

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

Solution

1. Step 1: Identify LINQ filtering method

   The correct LINQ method to filter is Where.

2. Step 2: Check syntax correctness

   numbers.Where(n => n % 2 == 0) correctly filters even numbers.

3. Final Answer:

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

4. Quick Check:

   Filter with Where = var evens = numbers.Where(n => n % 2 == 0); [OK]

Hint: Use Where for filtering in LINQ [OK]

Common Mistakes:

• Using Select instead of Where for filtering
• Using non-existent Filter method
• Confusing FindAll (List method) with LINQ

3. What will be the output of this code?

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

medium

A. 6 8 10

B. 4 6 8 10

C. 8 10

D. 2 4 6 8 10

Solution

1. Step 1: Filter numbers greater than 3

   From the list {1,2,3,4,5}, numbers > 3 are 4 and 5.

2. Step 2: Multiply filtered numbers by 2

   4 * 2 = 8, 5 * 2 = 10.

3. Final Answer:

   8 10 -> Option C

4. Quick Check:

   Filter >3 then *2 = 8 10 [OK]

Hint: Filter first, then transform with Select [OK]

Common Mistakes:

• Multiplying before filtering
• Including numbers not > 3
• Confusing Select and Where order

4. Identify the error in this LINQ query:

var names = new List<string> {"Anna", "Bob", "Cathy"};
var result = names.Select(n => n.StartsWith("A"));
Console.WriteLine(string.Join(", ", result));

medium

A. The Select method should be Where to filter names starting with 'A'.

B. The StartsWith method is used incorrectly and causes a syntax error.

C. The string.Join method cannot join boolean values.

D. The list initialization syntax is wrong.

Solution

1. Step 1: Understand Select vs Where

   Select transforms each item; Where filters items based on condition.

2. Step 2: Identify correct method for filtering

   To get names starting with 'A', use Where, not Select.

3. Final Answer:

   The Select method should be Where to filter names starting with 'A'. -> Option A

4. Quick Check:

   Filter with Where, not Select [OK]

Hint: Use Where to filter, Select to transform [OK]

Common Mistakes:

• Using Select instead of Where for filtering
• Thinking StartsWith causes syntax error
• Believing string.Join can't join booleans

5. Given a list of products with properties Name and Price, how can you use advanced LINQ to create a dictionary where keys are product names and values are prices, but only include products priced above 100?

hard

A. products.Where(p => p.Price > 100).ToDictionary(p => p.Name, p => p.Price);

B. products.ToDictionary(p => p.Name, p => p.Price > 100);

C. products.Select(p => new {p.Name, p.Price > 100}).ToDictionary();

D. products.Where(p => p.Price > 100).Select(p => p.Name, p => p.Price);

Solution

1. Step 1: Filter products priced above 100

   Use Where(p => p.Price > 100) to select only those products.

2. Step 2: Convert filtered list to dictionary

   Use ToDictionary(p => p.Name, p => p.Price) to create dictionary with name keys and price values.

3. Final Answer:

   products.Where(p => p.Price > 100).ToDictionary(p => p.Name, p => p.Price); -> Option A

4. Quick Check:

   Filter then ToDictionary = products.Where(p => p.Price > 100).ToDictionary(p => p.Name, p => p.Price); [OK]

Hint: Filter first, then use ToDictionary with key and value selectors [OK]

Common Mistakes:

• Trying to use ToDictionary without filtering first
• Passing boolean expressions as dictionary values
• Incorrect use of Select for dictionary creation