Prev Next

Sorting in EF Core

Sorting allows you to order the results based on specific fields using LINQ methods like OrderBy and OrderByDescending.

Key Topics

Basic Sorting

Example

using System;
using System.Linq;

class Program
{
    static void Main()
    {
        using (var context = new MyDbContext())
        {
            var employees = context.Employees
                .OrderBy(e => e.Name)
                .ToList();

            foreach (var employee in employees)
            {
                Console.WriteLine("Name: " + employee.Name);
            }
        }
    }
}

Explanation: This example sorts employees by their names in ascending order using the OrderBy method.

Key Takeaways

  • Use OrderBy() for ascending order and OrderByDescending() for descending order.
  • Combine sorting methods for multiple fields using ThenBy() or ThenByDescending().
Prev Next