Linq to SQL - Multiple where clauses at runtime

Question

Linq to SQL - Multiple where clauses at runtime

c# dynamic-linq linq-to-sql where-clause

Question

I am trying to accomplish this but only my first where clause is getting used when the query runs.

This needs to for for .Net 3.5 so the WhereIf in 4.0 is not usable.

var query =
    from tb in dataContext.TableOne
    where tb.DateTimeCreated >= fromDate && 
        tb.DateTimeCreated <= toDate.AddDays(1) 
    select tb;

if (!string.IsNullOrEmpty(reference))
{
    query.Where(tb => tb.Reference = reference));
}

SetiSeeker

Popular Answer

Try

Just do it in "one"

var query = (from tb in dataContext.TableOne
                      where (tb.DateTimeCreated >= fromDate && tb.DateTimeCreated <= toDate.AddDays(1)) && (string.IsNullOrEmpty(reference) || tb.Reference == reference)
                      select tb
               );

or as Ives says, do:

query = query.Where(...)

veggerby

View more on Stack Overflow

Ives.me · Accepted Answer · 12/8/2010 1:15:56 PM

Accepted Answer

  if (!string.IsNullOrEmpty(reference))
        query = query.Where(tb => tb.Reference = reference));

Ives.me

Linq to SQL - Multiple where clauses at runtime

Question

Fastest Entity Framework Extensions

Accepted Answer

Popular Answer

Performance

Expression Evaluator