title: SQLite .net provider & "prepare statement" functionality
body: <p><strong>PREFACE</strong></p>
  
  <p>One can find a description of the SQLite's <em>"Prepared Statement"</em> functionality <a href="https://sqlite.org/c3ref/stmt.html" rel="nofollow noreferrer">here</a>. </p>
  
  <p>SQLite command <em>(SQLite provider for .NET)</em> has a method "Prepare" with the following description:    </p>
  
  <blockquote>
    <p>Summary:
        Does nothing. Commands are prepared as they are executed
        the first time, and kept in prepared state afterwards.</p>
  </blockquote>
  
  <p><strong>QUESTIONS</strong></p>
  
  <ol>
  <li>In general, does SQLite's <strong><em>Prepared Statement</em></strong> functionality improve overall performance of the query, which is executed over and over again?</li>
  <li>Where the prepared statements are kept? How can I be sure that these prepared statements are in fact being used?</li>
  <li>How can I be sure that Dapper is utilizing these statements? (<em>In my case, I use Dapper to run the same query several hundred times. The query fetches 10k results in each call, based on passed parameters</em>).</li>
  </ol>
  
  <p><strong>EDIT:</strong></p>
  
  <p>Just've found <a href="https://stackoverflow.com/a/13505099/1151392">this</a>, which partially answers my question. Non the less, if I need to build the DbCommand my self and then keep it somewhere, how can I use the command with Dapper?</p>