Linq to Entities' dynamic where clause

dynamic entity-framework linq where-clause

Question

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 there will be many combinations to check.

Example:

Constructor(p1,p2,p3,p4)
{
  var prod= from p in ctxt.products.expand("items\details")
            where p.x==p1 && p.xx==p2 && p.xxx==p3 && p.xxxx==p4
            select p;
}

In the above where clause there should be condition checks only if the parameter is not null. ie., if p2 is null then the where clause should look like

where p.x==p1 && p.xxx==p3 && p.xxxx==p4

if p2 and p3 are null then 

where p.x==p1 && p.xxxx==p4

Can anyone tell me how to handle this. if possible can you give sample code for this

1
10
2/3/2012 12:45:38 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Linq's DeferredExecution to rescue. Linq query is not executed unless the data is requested from it.

var prod = from p in ctxt.products.expand("items\details")
        select p;

if (p1 != null)
{
    prod = prod.Where(p => p.x == p1);
}

if (p2 != null)
{
    prod = prod.Where(p => p.xx == p2);
}

// Execute the query

var prodResult = prod.ToList();
11
2/3/2012 12:48:09 AM

Popular Answer

You could always build the query in pieces and take advantage of delayed query execution:

public Constructor(int? p1, int? p2, int? p3, int? p4)
{
    var prod = ctxt.products.expand("items\details");

    if(p1 != null)
        prod = prod.Where(p.x == p1);

    if(p2 != null)
        prod = prod.Where(p.xx == p2);

    if(p3 != null)
        prod = prod.Where(p.xxx == p3);

    if(p4 != null)
        prod = prod.Where(p.xxxx == p4);
}
Justin Niessner

Related Questions

Building where clauses to evaluate collections inside a many to many connection using LINQ to entities

So, I am using the Linq entity framework. I have 2 entities: ...Content... and ...Tag.... They are in a many-to-many relationship with one another. ...Content... can have many ...Tags... and ...Tag... can have many ...Contents.... So I am trying to write a query to select all contents where any tags names are equal to ...blah...The entities both ha...
c# entity-framework lambda linq many-to-many
asked by Phobis

Dynamic Where Clause in Entity Framework

I have a query like:...var function = GetSomeExpression(); using (FooModel context = new FooModel()) { var bar = context.Bar.Where(function); } ...I'd like to make a generic method that can execute Where against different Entities in the context. The goal is not having to do context.Bar.Where, context.Car.Where, Context.Far.Where, etc. ....
c# entity-framework generics
asked by blu

Using the 'Contains' Clause in Entity Framework instead of the 'IN' SQL Clause

I am working on a tag cloud application. There are 3 database tables....Content...: ContentID, Text...Tag...: TagID, Name...TagRelation...: TagRelationID, TagID, ContentID...The code below is wrong. Because 'Contains' clause doesn't take a list of parameters like the 'IN' SQL clause. Is there an alternative clause that I can use to make this code w...
asp.net c# contains entity-framework ienumerable
asked by gavss

Outer left Entity Framework through Linq To Entities using Where Clause

I have read all the posts related to implementing the equivalent of a LEFT OUTER JOIN in Linq to Entities (.NET 3.5) when using the Entity Framework, but have yet to find a solution to the following problem....Given two tables, represented by the objects below:... public class Foo { public int FooId; // primary key public st...
entity-framework left-join linq-to-entities outer-join
asked by EulerOperator

Dynamic LINQ DateTime Comparison String Building - Linq To Entities

I'm using the dynamic LINQ library by Scott Guthrie together with Entity Framework and C#....I have to build my where string into a variable based on several factors and then pass the string variable to the where clause. For some reason, this will work:...ContactList = ContactList.Where("DateAdded >= @0", DateTime.Parse("12/1/2012")); ...But this w...
c# dynamic-linq entity-framework linq string
asked by Ricketts

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 Flags enum, the query should search for ...Username..., ...WindowsUsername... or ...both...:...
c# entity-framework linq linq-to-entities where-clause
asked by Thomas Zweifel

Building dynamic where clauses in LINQ to EF queries

I'm trying to build a where clause dynamically in a LINQ query which references tables via EF, but I'm getting the following error:...'ClaimantLastName' could not be resolved in the current scope or context. Make sure that all referenced variables are in scope, that required schemas are loaded, and that namespaces are referenced correctly. Near mem...
entity-framework linq
asked by birdus

Dynamic Linq + Entity Framework: datetime modifications for dynamic select

I am trying to find a way to move UTC time to Local before doing a sql grouping. I am using the System.Linq.Dynamic (managed here ...https://github.com/kahanu/System.Linq.Dynamic... ). It works great for doing dynamic selects without having at compile time the required fields. In our case, we store all datetimes in UTC. In this dynamic select, it...
.net c# dynamic-linq entity-framework-6
asked by TravisWhidden

Dynamic LINQ - Entity Framework 6 - Update Records for Dynamic Select

C# rookie. Below is my code, been trying for hours now to get this to update some fields in my DB and tried many different implementations without luck.... // Select all fields to update using (var db = new Entities()) { // dbFields are trusted values var query = db.tblRecords ...
c# dynamic-linq entity-framework-6
asked by user3333134

How to pass an Expression into Entity Framework LINQ query OrderBy clause

I have the following LINQ query:...using (var context = new EUContext()) { var tmp = context.Terms.Include(x => x.StudentCourses) .Where(x => x.StudentID == studentId && x.DepartmentID == departmentId) .OrderBy(x => x.AcademicYear) .ThenBy(x=> x.TermRegistered == "Fall" ? 1 : ...
c# entity-framework-6 expression lambda linq
asked by Sulieman Mansouri

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow