.NET - Entity Framework Core - Global Query Filters Demo

Program.cs

class Program
{
    // Only Queries are shown below
    // Rest of the methods are same as shown in previous snippet
    
    static async Task DisplayStudentsByNationality(string nationality)
    {
        using var context = BuildUniversityContext();
        var studentCollection = await context.Students
                .Where(x => x.Nationality == nationality)
                .ToListAsync();
        Console.WriteLine();
        Console.WriteLine($"Display {nationality} Students: ");
        Display(studentCollection);
    }

    static async Task DisplayAllStudents()
    {
        using var context = BuildUniversityContext();
        var studentCollection = await context.Students.ToListAsync(); ;
        Console.WriteLine();
        Console.WriteLine("Display All Non-Deleted Students");
        Display(studentCollection);
    }

    static async Task DisplayDeletedStudents()
    {
        using var context = BuildUniversityContext();
        var studentCollection = await context.Students
                .IgnoreQueryFilters()   // To ignore global filters
                .Where(x=> x.IsDeleted).ToListAsync(); ;
        Console.WriteLine();
        Console.WriteLine("Display Deleted Students");
        Display(studentCollection);
    }
}