【文件属性】：
文件名称：Dapper 链式查询 扩展
文件大小：21.3MB
文件格式：ZIP
更新时间：2022-01-24 06:34:20
Dapper 链式查询 扩展
博文地址: https://www.cnblogs.com/cl-blogs/p/10219126.html
简单栗子：
[Test]
public void 三表联表分页测试()
{
LockPers lpmodel = new LockPers() { Name = "%蛋蛋%", IsDel = false};
Users umodel = new Users() { UserName = "jiaojiao" };
SynNote snmodel = new SynNote() { Name = "%木头%" };
Expression> where = PredicateBuilder.WhereStart();
where = where.And((lpw, uw, sn) => lpw.Name.Contains(lpmodel.Name));
where = where.And((lpw, uw, sn) => lpw.IsDel == lpmodel.IsDel);
where = where.And((lpw, uw, sn) => uw.UserName == umodel.UserName);
where = where.And((lpw, uw, sn) => sn.Name.Contains(snmodel.Name));
DapperSqlMaker query = LockDapperUtilsqlite
.Selec()
.Column((lp, u, s) => // null) //查询所有字段
new { lp.Id, lp.InsertTime, lp.EditCount, lp.IsDel, u.UserName, s.Content, 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, lp.Name, sn.Content });
var result = query.ExcuteSelect(); //1. 执行查询
WriteJson(result); // 打印查询结果
Tuple resultsqlparams = query.RawSqlParams();
WriteSqlParams(resultsqlparams); // 打印生成sql和参数
int page = 2, rows = 3, records;
var result2 = query.LoadPagelt(page, rows, out records); //2. 分页查询
WriteJson(result2); // 查询结果
}
