title: Linq to SQL - Ignore search parameters that are null or zero
body: <p>I have a search form where the user can enter one to many parameters (Data, Status, Type, ID, Summary, Description) and leave the rest blank. </p>
  
  <p>Here's my Linq to SQL code for my basic search. Is there a way to check each parameter within the Linq for zero, null or empty string?</p>
  
  <pre><code>List&lt;RequestStatusModel&gt; objRequestStatus = new List&lt;RequestStatusModel&gt;();
  var query = from r in SimCareDB.Requests
              where r.CustomerID == 31       
              select (new RequestStatusModel
              {
                  RequestID = r.RequestID,
                  RequestTitle = r.RequestTitle,
                  DateAdded = r.DateAdded.ToString(),
                  DateChanged = r.DateChanged.ToString(),
                  RequestStatusID = r.StatusID
              });
  </code></pre>
  
  <p>Thank you!</p>