The Project | About Us | Contribute | Donations | License
HOME My courses Completed
◄ Previous
◄

LINQ (Language Integrated Query)

Next ►
►

LINQ (Language Integrated Query) is a powerful feature in C# that allows you to query collections of data in a more readable and concise way. LINQ provides a consistent query experience across different types of data sources, such as arrays, collections, XML, and databases.

Key Concepts

  1. LINQ Syntax

LINQ queries can be written in two syntaxes:

  • Query Syntax: Similar to SQL, more readable for those familiar with SQL.
  • Method Syntax: Uses method calls, more flexible and powerful.

  1. LINQ Providers

LINQ can be used with various data sources through different providers:

  • LINQ to Objects: Queries in-memory collections like arrays and lists.
  • LINQ to SQL: Queries SQL databases.
  • LINQ to XML: Queries XML documents.
  • LINQ to Entities: Queries Entity Framework data models.

  1. Basic LINQ Operations

  • Filtering: Using where clause.
  • Projection: Using select clause.
  • Sorting: Using order by clause.
  • Grouping: Using group by clause.
  • Joining: Using join clause.

Practical Examples

Example 1: LINQ to Objects

Query Syntax

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

class Program
{
    static void Main()
    {
        List<int> numbers = new List<int> { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };

        // Query Syntax
        var evenNumbers = from num in numbers
                          where num % 2 == 0
                          select num;

        Console.WriteLine("Even Numbers:");
        foreach (var num in evenNumbers)
        {
            Console.WriteLine(num);
        }
    }
}

Explanation:

  • from num in numbers: Iterates over each element in the numbers list.
  • where num % 2 == 0: Filters elements that are even.
  • select num: Projects the filtered elements.

Method Syntax

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

class Program
{
    static void Main()
    {
        List<int> numbers = new List<int> { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };

        // Method Syntax
        var evenNumbers = numbers.Where(num => num % 2 == 0);

        Console.WriteLine("Even Numbers:");
        foreach (var num in evenNumbers)
        {
            Console.WriteLine(num);
        }
    }
}

Explanation:

  • numbers.Where(num => num % 2 == 0): Filters elements that are even using a lambda expression.

Example 2: LINQ to XML

using System;
using System.Linq;
using System.Xml.Linq;

class Program
{
    static void Main()
    {
        string xmlData = @"
        <Students>
            <Student>
                <Name>John Doe</Name>
                <Age>20</Age>
            </Student>
            <Student>
                <Name>Jane Smith</Name>
                <Age>22</Age>
            </Student>
        </Students>";

        XDocument doc = XDocument.Parse(xmlData);

        var students = from student in doc.Descendants("Student")
                       where (int)student.Element("Age") > 20
                       select new
                       {
                           Name = student.Element("Name").Value,
                           Age = (int)student.Element("Age")
                       };

        Console.WriteLine("Students older than 20:");
        foreach (var student in students)
        {
            Console.WriteLine($"Name: {student.Name}, Age: {student.Age}");
        }
    }
}

Explanation:

  • XDocument.Parse(xmlData): Parses the XML string into an XDocument.
  • doc.Descendants("Student"): Selects all Student elements.
  • where (int)student.Element("Age") > 20: Filters students older than 20.
  • select new { ... }: Projects the filtered elements into anonymous objects.

Exercises

Exercise 1: Filtering and Projection

Write a LINQ query to filter and project a list of strings to only include those that start with the letter 'A' and convert them to uppercase.

Solution:

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

class Program
{
    static void Main()
    {
        List<string> names = new List<string> { "Alice", "Bob", "Andrew", "Charlie", "Anna" };

        var filteredNames = from name in names
                            where name.StartsWith("A")
                            select name.ToUpper();

        Console.WriteLine("Names starting with 'A' in uppercase:");
        foreach (var name in filteredNames)
        {
            Console.WriteLine(name);
        }
    }
}

Exercise 2: Sorting and Grouping

Write a LINQ query to sort a list of integers in descending order and group them by their even or odd status.

Solution:

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

class Program
{
    static void Main()
    {
        List<int> numbers = new List<int> { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };

        var groupedNumbers = from num in numbers
                             orderby num descending
                             group num by num % 2 == 0 into g
                             select new { Key = g.Key, Numbers = g };

        foreach (var group in groupedNumbers)
        {
            Console.WriteLine(group.Key ? "Even Numbers:" : "Odd Numbers:");
            foreach (var num in group.Numbers)
            {
                Console.WriteLine(num);
            }
        }
    }
}

Common Mistakes and Tips

  • Common Mistake: Forgetting to include using System.Linq; at the top of your file.
    • Tip: Always ensure you have the necessary using directives for LINQ.
  • Common Mistake: Misunderstanding the difference between query syntax and method syntax.
    • Tip: Practice both syntaxes to understand their use cases and flexibility.

Conclusion

In this section, you learned about LINQ, its syntax, and how to use it with different data sources. You also practiced filtering, projecting, sorting, and grouping data using LINQ. Understanding LINQ will greatly enhance your ability to work with collections and data in C#. In the next module, we will delve into asynchronous programming, which will help you write more efficient and responsive applications.

◄ Previous
◄
Next ►
►
The Project | About Us | Contribute | Donations | License
© Copyright 2024. All rights reserved