Combine Predicates in Linq-to-entities
c#, linq-to-entities
Solution
Turns out, you need to add this:
Results = query.AsExpandable.Where(_wherePredicate).ToList();
And then it just magically works!
I followed this tutorial: http://www.albahari.com/nutshell/predicatebuilder.aspx
Problem
I want to dynamically build my list of where conditions. Here's a snippet of my code: ``` protected Expression<Func<event_info, bool>> _wherePredicate = c => true; public void main() { _wherePredicate = _wherePredicate.And(c => c.createdby == 6); _wherePredicate = _wherePredicate.And(c => c.isdeleted == 0); var query = from ev in dataConnection.event_info where ev.isdeleted == 0 select ev; Results = query.Where(_wherePredicate).ToList(); } ``` Except this doesn't work because linq-to-entities doesn't support the Invoke method. What's a good way I can combine predicates in linq-to-entities?