Creating a dynamic query using IQueryable

Question

I'm trying to iterate for over an string array and dynamically create a IQueryable query. Its pretty straightforward but here's where I'm stuck

var query = context.QuestionsMetaDatas.AsQueryable();

var keywords=new List<string>(){ "Test1","Test2" };

foreach(var key in keywords)
{
   query=query.Where(a=>a.Text.Contains(key));
}

Now the problem is that when the query gets generated its compiles to

select * from QuestionsMetaDatas where Text Like "Test1" AND Text Like "Test2"

Instead of AND I wanted the query to generate OR...Now how can I achieve this?

Answer 1

I have used predicate builder like Raphael suggested, it's just one file to include in your project, then your example becomes:

var keywords=new List<string>(){ "Test1","Test2" };

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

foreach (var key in keywords)
{
  predicate = predicate.Or (a => a.Text.Contains (key));
}

var query = context.QuestionsMetaDatas.AsQueryable().Where(predicate);

Generating the OR query your are looking for.