C# LINQ Where

last modified February 1, 2024

In this article we show how to filter sequences in C# using LINQ's Where method and where clause.

Language-Integrated Query (LINQ) is a domain-specific language for querying data from various data sources, including arrays, lists, XML files, or databases.

The where clause or the Where method filters a sequence of values based on a predicate. A predicate is a single-argument function which returns a boolean value.

This method is lazily evaluated. The query is not executed until the object is enumerated.

C# LINQ Where simple example

The first example is a simple program which uses LINQ Select.

List<int> vals = [-3, -1, 0, 3, 2, 1, -6, 5, 9];
var res = vals.Where(e => e > 0);

Console.WriteLine(string.Join(',', res));

The program defines a list of integers. We filter out all positive values.

var res = vals.Where(e => e > 0);

The Where method applies the given predicate function on each of the elements. It returns a sequence of values that satisfy the given condition. In our case the condition is that the value is greater than zero.

$ dotnet run

C# LINQ Where with Func predicate

Func is a built-in generic delegate type. It can be used with a method, an anonymous method or a lambda expression.

Func<int, bool> isNeg = e => e < 0;

List<int> vals = [-3, -1, 0, 3, 2, 1, -6, 5, 9];
var res = vals.Where(isNeg);

Console.WriteLine(string.Join(',', res));

The program applies the Func delegate on the elements of the list. We filter all negative values.

$ dotnet run

C# LINQ where clause

Query expressions are an alternative LINQ syntax. In a query expression, we use the where clause to filter data.

List<string> words = [ "sky", "forest", "war", "buy",
    "crypto", "cup", "water", "cloud" ];

var res = from word in words
            where word.StartsWith('c')
            select word;

Console.WriteLine(string.Join(',', res));

In the program, we filter all words that begin with letter 'c'.

$ dotnet run

C# LINQ Where with multiple conditions

We can combine multiple conditions with and/or operators.

List<User> users =
    new ("John", "Doe", 1230),
    new ("Lucy", "Novak", 670),
    new ("Ben", "Walter", 2050),
    new ("Robin", "Brown", 2300),
    new ("Amy", "Doe", 1250),
    new ("Joe", "Draker", 1190),
    new ("Janet", "Doe", 980),
    new ("Albert", "Novak", 1930),

var res = users.Where(u => (u.LastName.StartsWith('D') ||
    u.LastName.StartsWith('W')) && u.Salary > 1000);

foreach (var e in res)

record User(string FirstName, string LastName, int Salary);

In the example, we apply three conditions to our filtering. We choose only those users whose names begin with either 'D' or 'W' and whose salaries are higher than 1000.

$ dotnet run
User { FirstName = John, LastName = Doe, Salary = 1230 }
User { FirstName = Ben, LastName = Walter, Salary = 2050 }
User { FirstName = Amy, LastName = Doe, Salary = 1250 }
User { FirstName = Joe, LastName = Draker, Salary = 1190 }


Enumerable.Where method

In this article we have presented the LINQ Where operation.


My name is Jan Bodnar and I am a passionate programmer with many years of programming experience. I have been writing programming articles since 2007. So far, I have written over 1400 articles and 8 e-books. I have over eight years of experience in teaching programming.

List all C# tutorials.