title: how to design search for multiple fields in asp.net
body: <p>[Form]: ![Form to be Considered][Form]</p>
  
  <p>[Form]:<img src="https://i.stack.imgur.com/CHYP1.png" alt="Access Form"> </p>
  
  <p>I have these form from Access. Here, I am developing search application on asp.net. I have 2 heavy databases with same data structure in which one database include approx 12000 fields and another has approx. 9000 records. I want to do search records with any criteria say, </p>
  
  <p>Dealer Number = 3123 and DLicenceNo = 3242314</p>
  
  <p>Here, I am assuming that if user provides a field text, that only considered to be search, and others to be ignored.</p>
  
  <p>Is there anyway to build query for this rather using long if clauses?</p>