C # How to connect encrypted database (Sqlite) sample sharing

Data encryption in two, one is to encrypt the database itself, the other is to encrypt data table data, the following through this article to introduce the C # connection encrypted SQLite database method, interested friends to see it together

There are two kinds of data encryption, one is to encrypt the database itself, the other is to encrypt the data in the data table,

If the SQLite database encryption, I use a management tool here called Sqlitedeveloper, the following can be encrypted database

，

If you open the database without a password in the tool, you will be prompted with the following error:

，

or using the wrong password in C # will also give you the wrong hint:

System.Data.SQLite.SQLiteException: "File is encrypted or was not a database

，

The correct way to connect is to provide the correct password in the connection string:

using System;
using System.Collections.Generic;
using System.Data.SQLite;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace OpenSqliteDBByPwd
{
  class Program
  {
    static void Main(string[] args)
    {
      string DB_PATH = "Data Source=EncryptedDB.db3; Password=1111";
      using (SQLiteConnection con = new SQLiteConnection(DB_PATH))
      {
        con.Open();
        string sqlStr = @"INSERT INTO Customer(CUST_NO,CUSTOMER)
                 VALUES
                 (
                   3001,
                   'Allen'
                 )";
        using (SQLiteCommand cmd = new SQLiteCommand(sqlStr, con))
        {
          cmd.ExecuteNonQuery();
        }
      }
    }
  }
}

Summarize