title: How do I create and persist a SQLite DB from scratch in code using System.Data.SQLite and C#?
body: <p>I have a database creation tool and am creating a database from scratch. This is done the same way as mentioned <a href="http://sqlite.phxsoftware.com/forums/p/1833/7797.aspx#7797">Here</a>. It creates a temporary DB and I can add data to it.</p>
  
  <p>When I close the database it is deleted, which is the expected behavior, but I do not want it deleted.</p>
  
  <p>I cannot find a Save or Create method in System.Data.SQLite and creating one with <code>System.IO.File.Create(myDBFilename);</code> creates a file that SQLite cannot connect to.</p>
  
  <p>How do I create and persist a database in code from scratch?</p>