Entity Framework 6 - Knowledge Base (KB)

Dynamic where clause in Linq to Entities

I'm using linq to entities(EF). I have a constructor which takes 4 string parameters. Depending on what parameter is not null I have to build the linq query. I can do with if else statements but i also has other constructor with 10 parameters in that case...

LINQ is it possible to add where clauses dynamically

I want to search my db with different keys. According to the input, there may be 1 key to 10 keys. Is there a way to add OR/AND clauses to my Linq query dynamically?... keys[k] // I have my keys in this array var feedList = (from feed in ctx.Feed ...

Dynamic where clause (OR) in Linq to Entities

In the post ...here... I learned how to build a dynamic query using the deferred execution of Linq. But the query is actually using an ...AND... concatenation of the WHERE condition. ...How can I achieve the same query but with an OR logic?...Due to the ...

EF: Include with where clause

As the title suggest I am looking for a way to do a where clause in combination with an include....Here is my situations: I am responsible for the support of a large application full of code smells. Changing too much code causes bugs everywhere so I am lo...

How to implement SQL where in for entity framework 6

I am trying to filter a dataset from entity framework table using the below functions. The issue I am experiencing is that when I get to .ToList() I get an object reference error. If I take out the .contains line the query works fine....Public Function Li...

How to construct Where Expression dynamically in Entity Framework?

I've taken a look at ...this answer... on how to dynamically create an OrderBy expression in Entity Framework. But I'd like to also build a dynamic Where expression. Something along the lines of this:...public IEnumerable<InventoryItem> GetAll(string filt...