How to process multiple where clauses in a LINQ statement?

Question

Thanks to those who answered my last question I got the code below to work which allows the developer to send multiple where clauses to a method which includes each of them in a LINQ statement. However, how can I get the inclusion of the where clauses to be dynamic? Instead of this:

return customers
       .Where(whereClauses[0])
       .Where(whereClauses[1])
       .ToList();

something like this (pseudo-code):

List<Customer> customers = new List<Customer>();
foreach (var whereClause in whereClauses)
{
    customers
    .Where(whereClause...???)
    .ToList();
}
return customers;

Here is the code that works:

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

namespace TestDynamicLinq2343
{
    public class Program
    {
        static void Main(string[] args)
        {
            List<Customer> customers = Customer.GetCustomers();

            List<Func<Customer, bool>> whereClauses = new List<Func<Customer, bool>>();
            whereClauses.Add(c => c.LastName.ToUpper().Contains("A"));
            whereClauses.Add(c => c.FirstName.ToUpper().Contains("J"));

            foreach (var customer in Customer.GetFilteredCustomers(customers, whereClauses))
            {
                Console.WriteLine(customer.LastName);
            }

            Console.ReadLine();
        }
    }

    public class Customer
    {
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string Street { get; set; }
        public string Location { get; set; }
        public string ZipCode { get; set; }

        public static List<Customer> GetCustomers()
        {
            List<Customer> customers = new List<Customer>();
            customers.Add(new Customer { FirstName = "Jim", LastName = "Jones" });
            customers.Add(new Customer { FirstName = "Joe", LastName = "Adams" });
            customers.Add(new Customer { FirstName = "Jake", LastName = "Johnson" });
            customers.Add(new Customer { FirstName = "Angie", LastName = "Reckar" });
            customers.Add(new Customer { FirstName = "Jean", LastName = "Anderson" });
            return customers;
        }

        public static List<Customer> GetFilteredCustomers(List<Customer> customers, List<Func<Customer, bool>> whereClauses)
        {
            return customers
                   .Where(whereClauses[0])
                   .Where(whereClauses[1])
                   .ToList();
        }
    }
}

Answer 1

IEnumerable<Customer> dbCustomers = customers;
foreach (var whereClause in whereClauses)
{
    dbCustomers = dbCustomers.Where(whereClause);
}
return dbCustomers.ToList();

maybe interesting extensionMethod:

public static class IEnumerableExtension
{
    public static void AttachWhereClauses<T>(this IEnumerable<T> source, IEnumerable<Func<T, bool>> whereClauses)
    {
     foreach (var whereClause in whereClauses)
     {
      source = source.Where(whereClause);
     }
    }
}
var listedCustomers = customers.AttachWhereClauses(whereClauses).ToList();

but: not tested - i do not know for sure, if attaching the whereClauses to the same object works!

Answer 2

Something like this:

public IEnumerable<Customer> ApplyConditions(IEnumerable<Func<Customer, bool>> conditions)
{
    IEnumerable<Customer> customers = ...;
    foreach(var condition in conditions)
        customers = customers.Where(condition);
    return customers;
}