MySqlSugar常用写法

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

using (var db = SugarDao.GetInstance())            {                //转成list                List<Student> list1 = db.SqlQuery<Student>("select * from Student");                //转成list带参                List<Student> list2 = db.SqlQuery<Student>("select * from Student where id=@id", new { id = 1 });                //转成dynamic                dynamic list3 = db.SqlQueryDynamic("select * from student");                //转成json                string list4 = db.SqlQueryJson("select * from student");                //返回int                var list5 = db.SqlQuery<int>("select id from Student limit 0,1").SingleOrDefault();                //反回键值                Dictionary<string, string> list6 = db.SqlQuery<KeyValuePair<string, string>>("select id,name from Student").ToDictionary(it => it.Key, it => it.Value);                //反回List<string[]>                var list7 = db.SqlQuery<string[]>("select  id,name from Student limit 0,1").SingleOrDefault();                //存储过程                //var spResult = db.SqlQuery<School>("exec sp_school @p1,@p2", new { p1 = 1, p2 = 2 });                  //存储过程加Output                //var pars = SqlSugarTool.GetParameters(new { p1 = 1,p2=0 }); //将匿名对象转成SqlParameter                //db.IsClearParameters = false;//禁止清除参数                //pars[1].Direction = ParameterDirection.Output; //将p2设为 output                //var spResult2 = db.SqlQuery<School>("exec sp_school @p1,@p2 output", pars);                //db.IsClearParameters = true;//启用清除参数                //var outPutValue = pars[1].Value;//获取output @p2的值                    ////存储过程优化操作                //var pars2 = SqlSugarTool.GetParameters(new { p1 = 1, p2 = 0 }); //将匿名对象转成SqlParameter                //db.CommandType = CommandType.StoredProcedure;//指定为存储过程可比上面少写EXEC和参数                //var spResult3 = db.SqlQuery<School>("sp_school", pars2);                //db.CommandType = CommandType.Text;//还原回默认                    //获取第一行第一列的值                string v1 = db.GetString("select '张三' as name");                int v2 = db.GetInt("select 1 as name");                double v3 = db.GetDouble("select 1 as name");                decimal v4 = db.GetDecimal("select 1 as name");                //....            }