title: How to use CodeEngine.Framework.QueryBuilder.SelectQueryBuilder for the following query in asp.net c#?
body: <p>I tried to use the <strong>SelectQueryBuilder</strong> for the following query,but it is not coming exactly as it should be.</p>
  
  <p>I want a Query String Like this</p>
  
  <pre><code>SELECT * FROM CustomerData WHERE (CustomerType = 'SPC3' OR CustomerType = 'SPC2' OR CustomerType = 'SPC5') AND Country='UK'
  </code></pre>
  
  <p>but what I am getting is </p>
  
  <pre><code>SELECT * FROM CustomerData WHERE ((CustomerType = 'SPC3' OR CustomerType = 'SPC3') AND (CustomerType = 'SPC2' OR CustomerType = 'SPC2') AND (CustomerType = 'SPC5' OR CustomerType = 'SPC5')) AND country='UK'
  </code></pre>
  
  <p>My code is:</p>
  
  <pre><code>var query = new SelectQueryBuilder();
  query.SelectFromTable("CustomerData");
  query.SelectAllColumns();
  query.AddWhere("CustomerType", Comparison.Equals,"UK");
  
  foreach (var selectedCustomerType in selectedCustomerList)
  {
  WhereClause whereClause = query.AddWhere("CustomerType", Comparison.Equals, selectedCustomerType);
  whereClause.AddClause(LogicOperator.Or, Comparison.Equals, selectedCustomerType);
  }
  
  String queryStatement = query.BuildQuery();
  </code></pre>
  
  <p>How can I add LogicOperator.Or in the statement itself ?</p>
  
  <p>Thanks.</p>