c# - Linq to SQL - Ignore search parameters that are null or zero -


i have search form user can enter 1 many parameters (data, status, type, id, summary, description) , leave rest blank.

here's linq sql code basic search. there way check each parameter within linq zero, null or empty string?

list<requeststatusmodel> objrequeststatus = new list<requeststatusmodel>(); var query = r in simcaredb.requests             r.customerid == 31                    select (new requeststatusmodel             {                 requestid = r.requestid,                 requesttitle = r.requesttitle,                 dateadded = r.dateadded.tostring(),                 datechanged = r.datechanged.tostring(),                 requeststatusid = r.statusid             }); 

thank you!

if doesn't have in linq statement classic if statements.

list<requeststatusmodel> objrequeststatus = new list<requeststatusmodel>(); var query = r in simcaredb.requests             r.customerid == 31             select (new requeststatusmodel             {                //...             });  if(data != null) //replace additional checks, if neccessary {    query = query.where(x=> ...); }  if(status != null)  {    query = query.where(x => ...) } 

Comments