3 ms·
I much prefer: var query = from c in db.MyTable where lessThan == null ? true : c.MyColumn < lessThan where greaterT
by louthy 10y ago
I much prefer:
var query = from c in db.MyTable
where lessThan == null ? true : c.MyColumn < lessThan
where greaterThan == null ? true : c.MyColumn > greaterThan
where name == null ? true : c.Name == name
select c;
Although IQueryable supports your approach also:
var query = db.MyTable;
if (lessThan != null)
query = query.Where(c => c.MyColumn < lessThan);
if (greaterThan != null)
query = query.Where(c => c.MyColumn > greaterThan);
if (!String.IsNullOrEmpty(name))
query = query.Where(c => c.Name == name);
var results = query.ToList();