title: How do I reference the Sqlite db file in the App_Data folder for my ASP.NET Web Application?
body: <p>I'm currently storing my sqlite db file in the App_Data folder as per ASP.NET best pattern and practices.</p>
  
  <p>Currently I'm using the following in the webconfig:</p>
  
  <pre><code>  &lt;connectionStrings&gt;
      &lt;add name="sqlite"  
           connectionString="Data Source=|DataDirectory|MyDB; Version=3;" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>and the following in code:</p>
  
  <pre><code>       public SqliteDAO(string path)
          {
              Connection = new System.Data.SQLite.SQLiteConnection(path );
          }
  
  //...
  
  //where path = |DataDirectory|MyDB
  </code></pre>
  
  <p>It causes sqlite to make a NEW database (with no tables in it), and thus none of my data access calls work, since they aren't finding the table names. How do I reference the sqlite db file in the App_Data folder from my WebApplication code??</p>
  
  <p>Thanks!</p>