title: How can I change my connectionstring in App.config and my database (sqlite) when I setup my project?
body: <p>I using Entity framework and sqlite to my project.</p>
  
  <p>when I setup my project I don't know to change my connectionstring :</p>
  
  <pre><code> &lt;connectionStrings&gt;
      &lt;add name="mainEntities"
          connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model
      1.msl;provider=System.Data.SQLite.EF6;
          provider connection string=&amp;quot;
              data source=C:\Users\Nam\Desktop\ConsoleApp\ProductDB.db&amp;quot;" 
      providerName="System.Data.EntityClient" /&gt;
          &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>so I decided to let it stay here (not change)
  and after setup I can't open my app. My database ( .db) stay from another file 
  ( not in my project ).</p>
  
  <p>I saw many videos on youtube but It mostly using ADO.NET .</p>
  
  <p>Plaese help me code to change connectionstring and all above is the way can create file .db in my project.</p>
  
  <p>thanks guy .</p>