title: Passing query parameters in Dapper using OleDb
body: <p>This query produces an error <code>No value given for one or more required parameters</code>:</p>
  
  <pre><code>using (var conn = new OleDbConnection("Provider=..."))
  {
    conn.Open();
    var result = conn.Query(
      "select code, name from mytable where id = ? order by name",
      new { id = 1 });
  }
  </code></pre>
  
  <p>If I change the query string to: <code>... where id = @id ...</code>, I will get an error: <code>Must declare the scalar variable "@id".</code></p>
  
  <p>How do I construct the query string and how do I pass the parameter?</p>