Re-using LINQ query based on bool value

Question

I'm trying to write a single query which will include one of the two conditions, based on an input variable:

!(from o in db.Products.Where(x => x.Company_ID == cid && x.IsDeleted != true)

or

(from o in db.Products.Where(x => x.Company_ID == cid && x.IsDeleted != true)

My current method, covering the former condition, is as follows. I have included productExists, which will be the parameter which determines whether I want condition #1 or #2 from above.

public IQueryable<ProductImportViewModel> AllImports(int id, bool productExists)
{
    return (from t1 in db.Products_Staging
            where (t1.ImportFileId == id) && !(from o in db.Products.Where(x => x.Company_ID == cid && x.IsDeleted != true)
                                               select o.ProductName).Contains(t1.ProductName)
            select new ProductImportViewModel
            {
                Id = t1.Id
            }
}

If anybody could help me with this, I'd be much appreciated.

Arion · Accepted Answer · 2012-03-30 11:06:05Z

2

Something like this maybe:

where (t1.ImportFileId == id) && 
            (
                productExists==true
                &&
                !(from o in db.Products.Where(x => x.Company_ID == cid && x.IsDeleted != true).
                                                Select(o=> o.ProductName).Contains(t1.ProductName)
            )
            ||
            (
                productExists==false
                &&
                (from o in db.Products.Where(x => x.Company_ID == cid && x.IsDeleted != true).
                                                Select(o=> o.ProductName).Contains(t1.ProductName)
            )

You could also do it something like this:

var query=(from o in db.Products
          .Where(x => x.Company_ID == cid && x.IsDeleted != true).
          Select(o=> o.ProductName);
------
where (t1.ImportFileId == id) && 
    (
        productExists && !query.Contains(t1.ProductName)
    )
    ||
    (
        !productExists && query.Contains(t1.ProductName)
    )

Both queries will result in the same sql

edited Mar 30, 2012 at 11:06

answered Mar 30, 2012 at 11:00

Arion

31.3k10 gold badges74 silver badges89 bronze badges

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

1 Comment

Nick Over a year ago

Thanks. That's pretty much what I did. I just wondered if there was a more succinct way to do it!

Collectives™ on Stack Overflow

Re-using LINQ query based on bool value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related