1. 在.net framework下设置Sqlite密码,访问数据,重设密码,删除密码。
using System;
using System.Data.SQLite;
namespace ConsoleApp1
{
class Program
{
private const string password = "abc.123";
static void Main(string[] args)
{
try
{
string dbFile = @"C:\repos\EFCoreDemos\EFCoreDemo1\Blogs.db";
// 1. Set password for your DB
using (SQLiteConnection conn = new SQLiteConnection("Data Source=" + dbFile+ ";Version=3;"))
{
conn.Open();
conn.ChangePassword(password);
}
// 2. Access data
using (var conn2 = new SQLiteConnection("Data Source=" + dbFile + ";Version=3;Password=" + password))
{
conn2.O