public int Dapper_Contrib插入语句测试示例() { 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); } }
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 = "******" }; 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 }); Tuple <StringBuilder, DynamicParameters> resultsqlparams = query.RawSqlParams(); WriteSqlParams(resultsqlparams); // 打印sql和参数 var result = query.ExecuteQuery(); WriteJson(result); // 查询结果 int page = 2, rows = 3, records; var result2 = query.LoadPagelt(page, rows, out records); WriteJson(result2); // 查询结果 }
public void 四表联表分页测试MS() { LockPers lpmodel = new LockPers() { Name = "%蛋蛋%", IsDel = false }; Users umodel = new Users() { UserName = "******" }; SynNote snmodel = new SynNote() { Name = "%木头%" }; Expression <Func <LockPers_ms, Users_ms, SynNote_ms, SynNote_ms, bool> > where = PredicateBuilder.WhereStart <LockPers_ms, Users_ms, SynNote_ms, SynNote_ms>(); where = where.And((lpw, uw, sn, snn) => lpw.Name.Contains(lpmodel.Name)); where = where.And((lpw, uw, sn, snn) => lpw.IsDel == lpmodel.IsDel); where = where.And((lpw, uw, sn, snn) => uw.UserName == umodel.UserName); where = where.And((lpw, uw, sn, snn) => sn.Name.Contains(snmodel.Name)); // SM.LimitCount, DapperSqlMaker <LockPers_ms, Users_ms, SynNote_ms, SynNote_ms> query = LockDapperUtilmssql <LockPers_ms, Users_ms, SynNote_ms, SynNote_ms> .Selec() .RowRumberOrderBy((lp, u, s, sn) => new { lp.Id, a = u.Id }) .Column((lp, u, s, sn) => new { SM.LimitCount, lp.Id, lp.InsertTime, lp.EditCount, lp.IsDel, u.UserName, s.Content, s.Name })//null查询所有字段 .FromJoin(JoinType.Left, (lpp, uu, snn, snnn) => uu.Id == lpp.UserId , JoinType.Inner, (lpp, uu, snn, snnn) => uu.Id == snn.UserId && snn.Id == snn.UserId , JoinType.Inner, (lpp, uu, snn, snnn) => snnn.Id == snn.UserId) .Where(where); //(lpp, uu, snn, snnn) => uu.Id == snn.UserId && snnn.Id == snn.UserId)//) // .Order((lp, w, sn, snn) => new { lp.EditCount, lp.Name, sn.Content }); Tuple <StringBuilder, DynamicParameters> resultsqlparams = query.RawSqlParams(); WriteSqlParams(resultsqlparams); var result = query.ExecuteQuery(); WriteJson(result); // 查询结果 int page = 2, rows = 2, records; var result2 = query.LoadPagems(page, rows, out records); WriteJson(result2); // 查询结果 }