title: Dynamic Where Clause over relational tables with LINQ to SQL
body: <p>I need help for a dynamic where clause <strong>over relational tables (one to many)</strong> in LinqToSql.</p>
  
  <p>User select conditions from page. (there is 4 input that user select the clauses) </p>
  
  <p><strong><em>For example CompanyName and CompanyTitle from Customer table and OrderDate and ShipCity From Order table.</em></strong> </p>
  
  <p>But <strong>user can select one ore many of them from page</strong> interface and dynamic query will be generated at codebehind and select From LinqToSql.</p>
  
  <p>You can give similar type of example from another web pages.</p>
  
  <p><img src="https://i.stack.imgur.com/nOMC4.jpg" alt="alt text"></p>