public ActionResult Load(int page, int rows ,string serh)
{
	serh = $"%{serh}%";
	int records;
	var where = PredicateBuilder.WhereStart<LockPers>();
	where = where.And( m => m.IsDel != true );
	if (!string.IsNullOrWhiteSpace(serh)) {
		where = where.And( m => (m.Name.Contains(serh) || m.Prompt.Contains(serh) ) );
	}
	var query = LockDapperUtilsqlite<LockPers>
		.Selec().Column(p => new { t = "datetime(a.InsertTime) as InsertTimestr"
			, p.Id, p.Name, p.Content, p.Prompt, p.EditCount, p.CheckCount})
		.From().Where(where).Order(m => new { m.Name });
	var list = query.LoadPagelt(page, rows, out records);
	var resultjson = JsonConvert.SerializeObject(new { data = list, records = records});
	return Content(resultjson);
}

public void 三表联表分页测试()
{
    var arruser = new int[2] { 1,2 };  // 
    string uall = "b.*", pn1 = "%蛋蛋%", pn2 = "%m%";
    LockPers lpmodel = new LockPers() { IsDel = false};
    Users umodel = new Users() { UserName = "jiaojiao" };
    SynNote snmodel = new SynNote() { Name = "木头" };
    Expression<Func<LockPers, Users, SynNote, bool>> where = PredicateBuilder.WhereStart<LockPers, Users, SynNote>();
    where = where.And((l, u, s) => ( l.Name.Contains(pn1) || l.Name.Contains(pn2) ));
    where = where.And((lpw, uw, sn) => lpw.IsDel == lpmodel.IsDel);
    where = where.And((l, u, s) => u.UserName == umodel.UserName);
    where = where.And((l, u, s) => s.Name == snmodel.Name );
    where = where.And((l, u, s) => SM.In(u.Id, arruser));

    DapperSqlMaker<LockPers, Users, SynNote> query = LockDapperUtilsqlite<LockPers, Users, SynNote>
        .Selec()
        .Column((lp, u, s) => //null)  //查询所有字段
            new { lp.Name, lpid = lp.Id, x = "LENGTH(a.Prompt) as len", b = SM.Sql(uall), scontent = s.Content, sname = s.Name })
        .FromJoin(JoinType.Left, (lpp, uu, snn) => uu.Id == lpp.UserId
                , JoinType.Inner, (lpp, uu, snn) => uu.Id == snn.UserId)
        .Where(where)
        .Order((lp, w, sn) => new { lp.EditCount, x = SM.OrderDesc(lp.Name), sn.Content });

    var result = query.ExcuteSelect();
    WriteJson(result); //  查询结果

    Tuple<StringBuilder, DynamicParameters> resultsqlparams = query.RawSqlParams();
    WriteSqlParams(resultsqlparams); // 打印sql和参数

    int page = 2, rows = 3, records;
    var result2 = query.LoadPagelt(page, rows, out records);
    WriteJson(result2); //  查询结果
}

public void 添加部分字段和子查询_测试lt2() 
{
    string colm = "img", val = "(select value from skin limit 1 offset 1)"; 
	DateTime cdate = DateTime.Now;
    var insert = LockDapperUtilsqlite<Users>.Inser().AddColumn(p => new bool[] {
         p.UserName =="木头人1", p.Password == "666", p.CreateTime == cdate
        , SM.Sql(colm,val), SM.Sql(p.Remark,"(select '荒野高尔夫')")
    }); 
    var efrow = insert.ExecuteInsert();
    Console.WriteLine(efrow + " " + insert.RawSqlParams().Item1);
}

public void 更新部分字段_含子查询_测试lt()
{
    string colm = "img", val = "(select value from skin limit 1 offset 1)"; 
	DateTime cdate = DateTime.Now;
    var update = LockDapperUtilsqlite<Users>.Updat().EditColumn(p => new bool[] {
        p.UserName =="几十行代码几十个错 调一步改一步....", p.Password == "bug制造者"
        , p.CreateTime == cdate,  SM.Sql(p.Remark,"(select '奥德赛 终于改好了')")
    }).Where(p => p.Id == 6 && SM.SQL("IsDel == 0"));
	
    var efrow = update.ExecuteUpdate();
    Console.WriteLine(efrow + update.RawSqlParams().Item1);
}

public void 删除数据_含子查询_测试lt() {
    var sql = " UserId = ( select Id from users  where UserName = '木头人1' )";
    var delete = LockDapperUtilsqlite<LockPers>.Delet().Where(p => 
            p.Name == "H$E22222" && SM.SQL(sql) && SM.SQL(" IsDel = '1' "));
    var efrow = delete.ExecuteDelete();
    Console.WriteLine(efrow + " " + delete.RawSqlParams().Item1);
}

	var str = DateTime.Now.ToString();
	Console.WriteLine(str);
	var update = DBMSSql<Users>.Update().EditColumn(p => new bool[] { p.UserName == "事务修改 第一条语句", p.Password == str })
		.Where(p => p.Id == 4 && SM.SQL(" IsDel = 'false' "));
	var update2 = DBMSSql<Users>.Update().EditColumn(p => new bool[] { p.UserName == "xxxxx 2 sql事务修改", p.Password == str })
		.Where(p => p.Id == 6 && SM.SQL(" IsDel = 'false' "));

	Console.WriteLine(update.RawSqlParams().Item1);
	Console.WriteLine(update2.RawSqlParams().Item1);

	using (var conn = update.GetConn())
	{
		var trans = conn.BeginTransaction();
		try
		{
			var efrow = conn.Execute(update.RawSqlParams().Item1.ToString(), update.RawSqlParams().Item2, trans);
			Console.WriteLine(efrow + "第一执行了");

			//throw new Exception("机房爆炸了");
			var efrow2 = conn.Execute(update2.RawSqlParams().Item1.ToString(), update2.RawSqlParams().Item2, trans);
			Console.WriteLine(efrow2 + "第2执行了");

			trans.Commit();
		}
		catch (Exception ex)
		{
			trans.Rollback();
			Console.WriteLine(ex.Message);
		}

	}

//var efrow = update.ExecuteUpdate();

var rows = DBMSSql<Users>.Select().Column().From().Where(p => p.Id == 4 || p.Id == 6).ExecuteQuery();
WriteJson(rows);

 using (var conn = DBSqliteFuncs.New.GetConn()) // var = GetConn())
    {
        System.Data.IDbTransaction transaction = null;
        int? commandTimeout = null;
        var entity = new SynNote();
        // using Dapper.Contrib.Extensions;
        var t = conn.Inser(entity, false, transaction, commandTimeout);
        return (int)t;
    }

	
    DynamicParameters jdmp = new DynamicParameters("#");
    jdmp.Add("UserName_join_0", name);

...

1.工具 -> 扩展和更新 ->联机
NUnit第3版，那么搜索NUnit 3 Test Adapter

2.先把这个东西复制上 -》》》   download.visualstudio.microsoft.com
搜索站长工具    -》http://tool.chinaz.com/dns/?type=1&host=download.visualstudio.microsoft.com&ip=

3.然后打开cmd
输入ipconfig /flushdns