title: OleDbCommand parameters order and priority
body: <p>I have been debugging this query for the last 40 minutes, and the problem apparently is the order of the parameters after all.</p>
  
  <pre><code>SELECT * FROM tblSomeThing WHERE id = @id AND debut = @dtDebut AND fin = @dtFin
  </code></pre>
  
  <p>Then I add the parameters this way, notice that the two last parameters are switched, I get no results.</p>
  
  <pre><code>cmd.Parameters.Add("@id", OleDbType.Integer).Value = idSociete;
  cmd.Parameters.Add("@dtFin", OleDbType.Date).Value = dateTraitementFin;
  cmd.Parameters.Add("@dtDebut", OleDbType.Date).Value = dateTraitementDebut;
  </code></pre>
  
  <p>When I declare the parameters the way they appear in the queury everything works perfectly.</p>
  
  <p>I thought named parameters were at first place to address this problem! what am I missing here?</p>
  
  <p>Thank you</p>