How to use predicates with LINQ to query CRM 2011

Question

I am trying to use linqkit to Predicate. Getting following code when I am trying to compile.

public void TestPredicate(Guid[] productIds)
{
    var predicate = PredicateBuilder.False<Product>();
    foreach (var productId in productIds)
    {
        var tempGuid = productId;
        predicate = predicate.Or(p => p.ProductId== tempGuid);
    }
}

    var query = from p in context.CreateQuery("product")
            .AsExpandable().Where(predicate) select p;
}

Error 1: 'System.Linq.IQueryable' does not contain a definition for 'Where' and the best extension method overload 'System.Linq.Queryable.Where(System.Linq.IQueryable, System.Linq.Expressions.Expression>)' has some invalid arguments

Error 2 Argument 2: cannot convert from 'System.Linq.Expressions.Expression>' to 'System.Linq.Expressions.Expression>

Please suggest me what I need to do fix it.

Thanks

Change `context.CreateQuery("product")` to `context.Set()` – haim770 Jun 10 '15 at 15:12 — haim770, Jun 10 '15 at 15:12
Set does not exist in context. – user1211185 Jun 10 '15 at 15:43 — user1211185, Jun 10 '15 at 15:43

score 3 · Accepted Answer · answered Jun 10 '15 at 15:45

3

I believe you are using Dynamics CRM. So following should work for you.

var query = from p in context.ProductSet
        .AsExpandable().Where(predicate) select p;

answered Jun 10 '15 at 15:45

Scorpion

4,495
7
39
60

score 0 · Answer 2 · answered Jun 10 '15 at 15:18

0

Did you try doing something like this?

var query = context.Products.AsExpandable().Where(predicate);

answered Jun 10 '15 at 15:18

ivamax9

2,601
24
33

How to use predicates with LINQ to query CRM 2011

2 Answers2