Using if / else in lambda expression in Where clause

Question

I have this Code for Search.

public List<Tbl_Product> ProductSearch(DateTime startdate, DateTime enddate, string productname, int suply)
{
    var q = _db.Tbl_Product
            .Where(model => 
                model.DateReg == startdate && 
                model.DateReg == enddate)
            .Where(model => 
                model.ProductName.Contains(productname))
            .Where({});

}

Now I Need to insert this code in Last Where .

if(suply == 1)
{
    model.Suply > 0 ;
}
else
{
    model.Suply = 0;
}

How should I do it?

Possible duplicate of Implementing conditional 'if' statements within a LINQ queries 'where' statement — Dmitry Pavlov
– Dmitry Pavlov, Commented Dec 26, 2016 at 17:24

Kris Vandermotten · Accepted Answer · 2016-12-26 16:33:05Z

9

Personally I wouldn't do that inside the Where clause as it means you are passing the suply variable to your database.

var q = _db.Tbl_Product
    .Where(model => model.DateReg == startdate 
                 && model.DateReg == enddate
                 && model.ProductName.Contains(productname));

if(suply == 1)
{
    q = q.Where(model => model.Suply > 0);
}
else
{
    q = q.Where(model => model.Suply == 0);
}

However, if you're really adamant that you want to do it all at once:

.Where(model => (suply == 1 && model.Suply > 0)
             || (suply != 1 && model.Suply == 0));

edited Dec 26, 2016 at 16:33

Kris Vandermotten

10.2k40 silver badges50 bronze badges

answered Dec 26, 2016 at 16:03

DavidG

120k13 gold badges232 silver badges239 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using if / else in lambda expression in Where clause

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related