zzz projects Entity Framework 6 EF 6
Home EF Core Articles Knowledge Base Online Examples
  • Home
  • EF Core
  • Articles
  • Knowledge Base
  • Online Examples

Entity Framework 6 - Knowledge Base (KB)

6 results in tag: where-clause

Linq to Entities' dynamic where clause

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...
dynamic entity-framework linq where-clause
asked by Deepak

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 ...
c# entity-framework linq where-clause
asked by tkcn

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 ...
c# entity-framework linq linq-to-entities where-clause
asked by Thomas Zweifel

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...
c# entity-framework include where-clause
asked by Beejee

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...
entity-framework-6 linq linq-to-entities vb.net where-clause
asked by adamias

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...
entity-framework expression-trees linq where-clause
asked by Greg Kopp

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!