title: sqlite database with winforms deployment
body: <p>I am fairly new to this deployment of sqlite database with C# winforms application. 
  I created a Setup project  with the following Application Folder contains Primary output(.exe file)
  The program has the System.Data.sqlite as its dependencies. </p>
  
  <p>In the regular project(not set up), database  is included in bin->Debug->Appdata->Test.DB </p>
  
  <pre><code> &lt;connectionStrings&gt;
      &lt;clear /&gt;
    &lt;add name="RConnString" connectionString="Data Source=App_Data\Test.db;Compress=True;Version=3"
        providerName="System.Data.Sqlite" /&gt;
  
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>For Installation: Where would the database and its related dependencies go(system.data.sqlite)
  Currently, this program is installed at C:\Programfiles...
  Did not include Database yet.</p>
  
  <p>What is a good place to ship this sqlite Db. Also, how would I do it. Where in the Setup project do I place it. Do I need a custom install?<br>
  We have Windows XP, Win 7 users </p>