title: How to connect to sqlite database with password
body: <p>I have a sqlite database and I want to connect from my C# program using a password for the database. I am using Navicat and I set encrypt database file with password "test"
  and then by code my connection string is:</p>
  
  <pre><code>_connection = new SQLiteConnection("Data Source=MedExpress.db;Version=3;Password=\"test\";");
  </code></pre>
  
  <p>or</p>
  
  <pre><code>_connection = new SQLiteConnection("Data Source=MedExpress.db;Version=3;Password=test;");
  </code></pre>
  
  <p>But this does not work.</p>
  
  <p>The error is:  <code>File opened that is not a database file
  file is encrypted or is not a database</code></p>
  
  <p>I can connect to the database without a password like this:</p>
  
  <pre><code>_connection = new SQLiteConnection("Data Source=MedExpress.db;Version=3;");
  </code></pre>
  
  <p>My question is how can I set a password to a sqlite database and connect from C# program using <code>System.Data.SQLite</code></p>