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
Post a Comment