title: Dapper and access returning blank values
body: <p>I'm trying to pull data from an Access database using dapper. I have the following class defined to use the fields from the access database that I need to read. I then tried to pull the data using the code below. When I run this only blanks come back. The number of blanks match the number of records in the data table.</p>
  
  <p>I tried to use a shorter sql string with the same results.</p>
  
  <p>I can't find any information on this issue, does anyone have any ideas about this?</p>
  
  <pre><code>public class DLabResults
  {
      public int ResultsFolderNumber { get; set; }
      public int Request { get; set; }
      public int Release { get; set; }
      public string Formulation { get; set; }
      public string Container { get; set; }
      public string Closure { get; set; }
      public string Shipper { get; set; }
      // public string Label_Back { get; set; }
      // public string Label_Front { get; set; }
      public string FilePath { get; set; }
  }
  
  public void LoadDapperDLabResults(List&lt;DLabResults&gt; items)
  {
      string sql = "";
      //sql = "SELECT tblResults_Results.R_Project_Assignment, tblResults_Results.R_Project_Request, tblResults_Results.R_Project_Release, tblResults_Results.R_Formulation, tblResults_Results.R_Closure, tblResults_Results.R_Container, tblResults_Results.R_Shipper, '' AS Blank1, '' AS Blank2, tblResults_Results.R_Test_FullPath FROM tblResults_Results WHERE(((tblResults_Results.R_Formulation)Like '*' &amp; [Formulation] &amp; '*') AND ((tblResults_Results.R_Closure)Like '*' &amp; [Closure] &amp; '*') AND((tblResults_Results.R_Container)Like '*' &amp; [Container] &amp; '*') AND((tblResults_Results.R_Shipper)Like '*' &amp; [Shipper] &amp; '*')) ORDER BY tblResults_Results.R_Project_Assignment, tblResults_Results.R_Project_Request, tblResults_Results.R_Project_Release;";
      sql = "SELECT * FROM tblResults_Results";
      using (OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\DavidsoJ\\Desktop\\Fixed Push Workbooks\\Redesigned Databases\\Development Lab Results Database.accdb"))
      {
          //var TM2 = connection.Query&lt;DLabResults&gt;(sql).ToList();
          List&lt;DLabResults&gt; TM2 = connection.Query&lt;DLabResults&gt;(sql).ToList();
          //add items to employess    
          if (items == null || items.Count &lt; 1)
          {
          }
          else
          {
              TM2.AddRange(items);
          }
          dataGridView1.DataSource = TM2;
      }
  }
  </code></pre>