Extend IQueryable Where() as OR instead of AND relationship

by

I’m assuming the different parts of the query are only known at runtime, i.e. you can’t just use || in a where…

One lazy option is Concat – but this tends to lead to poor TSQL etc; however, I tend to be inclined to write custom Expressions instead. The approach to take depends on what the provider is, as LINQ-to-SQL supports different options to EF (for example) – which has a genuine impact here (since you can’t use sub-expressions with EF). Can you tell us which?

Here’s some code that should work with LINQ-to-SQL; if you build an array (or list, and call .ToArray()) of expressions, it should work fine; example is LINQ-to-Objects, but should still work:

    static void Main()
    {
        var data = (new[] { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }).AsQueryable();

        var predicates = new List<Expression<Func<int, bool>>>();
        predicates.Add(i => i % 3 == 0);
        predicates.Add(i => i >= 8);           

        foreach (var item in data.WhereAny(predicates.ToArray()))
        {
            Console.WriteLine(item);
        }
    }

    public static IQueryable<T> WhereAny<T>(
        this IQueryable<T> source,
        params Expression<Func<T,bool>>[] predicates)
    {
        if (source == null) throw new ArgumentNullException("source");
        if (predicates == null) throw new ArgumentNullException("predicates");
        if (predicates.Length == 0) return source.Where(x => false); // no matches!
        if (predicates.Length == 1) return source.Where(predicates[0]); // simple

        var param = Expression.Parameter(typeof(T), "x");
        Expression body = Expression.Invoke(predicates[0], param);
        for (int i = 1; i < predicates.Length; i++)
        {
            body = Expression.OrElse(body, Expression.Invoke(predicates[i], param));
        }
        var lambda = Expression.Lambda<Func<T, bool>>(body, param);
        return source.Where(lambda);
    }

More Related Contents:

  1. Dynamic LINQ OrderBy on IEnumerable / IQueryable
  2. Returning IEnumerable vs. IQueryable
  3. Using IQueryable with Linq
  4. To return IQueryable or not return IQueryable [closed]
  5. Differences between IQueryable, List, IEnumerator?
  6. Why use AsQueryable() instead of List()?
  7. The provider for the source IQueryable doesn’t implement IAsyncQueryProvider
  8. What is the purpose of AsQueryable()?
  9. Pass An Instantiated System.Type as a Type Parameter for a Generic Class
  10. MVC5 Razor html.dropdownlistfor set selected when value is in array
  11. How can I download HTML source in C#
  12. Exception: There is already an open DataReader associated with this Connection which must be closed first
  13. Convert a binary string representation to a byte array
  14. Connect to network drive with user name and password
  15. Passing data to Master Page in ASP.NET MVC
  16. What’s the difference between IEquatable and just overriding Object.Equals()?
  17. Generically Flatten Json using c#
  18. Determine if current application is activated (has focus)
  19. Why do members of a static class need to be declared as static? Why isn’t it just implicit?
  20. Open a folder using Process.Start
  21. Linq to Entity Join table with multiple OR conditions
  22. Parent Control Mouse Enter/Leave Events With Child Controls
  23. keybd_event along with PostMessage win32 not working when Visual Studio has focus (or any application run as admin)
  24. Web Api Request Content is empty in action filter
  25. How do I code a progress bar for Windows 7 to also update itself on the taskbar?
  26. Make DateTimePicker work as TimePicker only in WinForms
  27. C# Why use SuspendLayout()?
  28. TableLayoutPanel responds very slowly to events
  29. How to receive event when user changes system’s culture
  30. Is Injection Possible through Dynamic LINQ?

Leave a Comment