Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Linq PredicateBuilder - Multiple ORs

Tags:

c#

linq

I'm trying to use the PredicateBuilder, as described here - http://www.albahari.com/nutshell/predicatebuilder.aspx

The following code

var predicate = PredicateBuilder.False<StreetDTO>();

        predicate = predicate.Or(p => p.Locality.Contains(criteria.Locality));
        predicate = predicate.Or(p => p.Name.Contains(criteria.Name));
        predicate = predicate.Or(p => p.Town.Contains(criteria.Town));

        List<StreetDTO> streetData = StreetData.Instance();

        var streetList = from street in streetData.Where(predicate)
                         select street;

as far as I see this should work, according to the example

var newKids  = Product.ContainsInDescription ("BlackBerry", "iPhone");

var classics = Product.ContainsInDescription ("Nokia", "Ericsson")
                      .And (Product.IsSelling());
var query =
  from p in Data.Products.Where (newKids.Or (classics))
  select p;

but all I get is

Error 1 The type arguments for method 'System.Linq.Enumerable.Where(System.Collections.Generic.IEnumerable, System.Func)' cannot be inferred from the usage. Try specifying the type arguments explicitly.

I'm trying to gain some understanding in LINQ 'on-the-job', so apologies if this is a simple question.

like image 527
Duncan Avatar asked May 18 '09 10:05

Duncan


2 Answers

Ah; your list is using IEnumerable<T> extension methods (rather than IQueryable<T>) - try:

var streetList = from street in streetData.AsQueryable().Where(predicate)
                 select street;
like image 80
Marc Gravell Avatar answered Nov 05 '22 18:11

Marc Gravell


Try compiling your predicate:

var streetList = from street in streetData.Where(predicate.Compile())
                 select street;
like image 11
bruno conde Avatar answered Nov 05 '22 19:11

bruno conde