title: linq query for varchar field not returning any results
body: <p>When I run this query in <strong>linqpad</strong>:</p>
  
  <pre><code>Customer.Where(c =&gt; (c.CustomerName == "test"))
  </code></pre>
  
  <p>It returns a record that matches.</p>
  
  <p>When I try running the same query in <strong>visual studio</strong> it does not return any matching records. This is the code I am using:</p>
  
  <pre><code>    List&lt;Customer&gt; customerList = new List&lt;Customer&gt;();
  
      using (DBEntities db = new DBEntities())
      {
          try
          {
              customerList = db.Customer.Where(c =&gt; (c.customerName == "test")).ToList();
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.ToString());
          }
      }
  
      return customerList;
  </code></pre>
  
  <p>Can anyone see why this it works in <strong>linqpad</strong> but does not work in <strong>visual studio</strong>?</p>