Nuget 安装以下程序包
1.SqlSugarCore
2.Microsoft.Data.Sqlite.Core
3.SQLitePCLRaw.bundle_e_sqlcipher
using Microsoft.Data.Sqlite;using Microsoft.VisualStudio.TestTools.UnitTesting;using SqlSugar;using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;namespace UnitTest{/// <summary>/// Sqlsugar测试/// </summary>[TestClass]public class SqlsugarTest{/// <summary>/// 测试创建数据库/// </summary>[TestMethod]public void TestCreateSqliteDB(){try{//生成连接字符串var connectionString = new SqliteConnectionStringBuilder("DataSource=C:/Users/hongz/Desktop/test.db;"){Mode = SqliteOpenMode.ReadWrite,Password = "123456"}.ToString();//使用Sqlsugar连接Sqliteusing (SqlSugarClient client = new SqlSugarClient(new ConnectionConfig(){ConnectionString = connectionString,IsAutoCloseConnection = true,DbType = DbType.Sqlite,})){client.Open();/*** 单单调用 Open() 是无法判断是否成功打开加密Sqlite数据库的* 在查询数据时,如果密码错误或者未输入密码会报错.反之成功*/List<abc> lt = client.Queryable<abc>().ToList();//测试断言Assert.IsTrue(lt.Count == 1);}}catch (Exception ex){Assert.Fail(ex.Message);//throw;}}}/// <summary>/// 临时测试实体表/// </summary>class abc{public string a1 { get; set; }}}
本Demo仅展示Sqlsugar连接加密Sqlite部分，Sqlsugar IOC 等请自行查询
