Search⌘ K
AI Features
Home
Courses
Modern C# and .NET Tutorial: Cross-Platform Basics

Filtering and Sorting Sequences in LINQ

Explore how to filter and sort sequences of data using LINQ integrated with Entity Framework Core in C#. Understand how LINQ queries are constructed and executed, including efficient selection of data columns and viewing generated SQL queries. This lesson helps you write optimized data queries and manipulate query results effectively.

We'll cover the following...

Filtering and sorting

Let’s write statements to filter and sort sequences of rows from the tables:

Step 1: In the LinqWithEFCore project, add a new class file name Program.Helpers.cs.

Step 2: In Program.Helpers.cs, define a partial Program class with a method to output a section title, as shown in the following code:

C#
partial class Program
{
  static void SectionTitle(string title)
  {
    ConsoleColor previousColor = ForegroundColor;
    ForegroundColor = ConsoleColor.DarkYellow;
    WriteLine("*");
    WriteLine($"* {title}");
    WriteLine("*");
    ForegroundColor = previousColor;
  }
}

Step 3: In the LinqWithEFCore project, add a new class file named ...