SqlSugar-执行Sql语句查询实例
2023-09-14 09:11:18 时间
使用SqlSugar执行sql语句
1.简单查询
SqlSugarClient db = SugarContext.GetInstance(); //执行sql语句,处理 //1.执行sql,转成list List<teacher> list1 = db.SqlQuery<teacher>("select * from teacher where tsex=@tsex", new { tsex = "女" }); Console.WriteLine(list1.ToJsonString()); //2.转成dynamic dynamic list2 = db.SqlQueryDynamic("select * from UserInfo"); Console.WriteLine(list2.Length); //3.转成json数据 string list3 = db.SqlQueryJson("select * from UserInfo"); Console.WriteLine(list3); //4.返回int int count = db.SqlQuery<int>("select count(*) from UserInfo").FirstOrDefault(); Console.WriteLine(count); //5.返回键值对类型 Dictionary<string, string> list4 = db.SqlQuery<KeyValuePair<string, string>>("select UserID,Name from UserInfo") .ToDictionary(q => q.Key, q => q.Value); Console.WriteLine(list4.ToJsonString()); //6.返回List<string[]> 集合 List<string[]> list5 = db.SqlQuery<string[]>("select * from teacher where tsex=@tsex", new { tsex = "女" }); Console.WriteLine(list5.ToJsonString());
2.汇总查询
SqlSugarClient db = SugarContext.GetInstance(); //更方便的获取第一行第一列 string result1 = db.GetString(" select name from UserInfo where UserID=@UserID", new { UserID = 1 }); Console.WriteLine(result1); int count = db.GetInt("select count(*) from UserInfo"); Console.WriteLine(count); double result2 = db.GetDouble("select avg(degree) from score where cno=@cno ", new System.Data.SqlClient.SqlParameter("@cno", "3-105")); Console.WriteLine(result2); decimal result3 = db.GetDecimal(" select avg(degree) from score"); Console.WriteLine(result3);
3.执行视图、存储过程
SqlSugarClient db = SugarContext.GetInstance(); //执行视图查询 List<student> list1 = db.SqlQuery<student>("select * from V_student"); Console.WriteLine(list1.ToJsonString()); //执行存储过程处理 var pars = SqlSugarTool.GetParameters(new { pageStart = 1, pageEnd = 5, recordCount = 0 }); //禁止清空参数 db.IsClearParameters = false; pars[2].Direction = System.Data.ParameterDirection.Output; List<student> list2 = db.SqlQuery<student>("exec proc_PageStudent @pageStart,@pageEnd,@recordCount output", pars); db.IsClearParameters = true;//启用自动清空参数 var recordCount = pars[2].Value; Console.WriteLine(list2.ToJsonString()); Console.WriteLine(recordCount);
这里还有sqlsugar其它一些sql事务等知识内容:
https://blog.csdn.net/weixin_34041003/article/details/85833562
相关文章
- 怎样在SQL Server数据库执行sql脚本?
- SQL与MySQL的异同比较(sql与mysql的区别)
- 快速执行Oracle SQL文件的姿势(oracle执行sql文件)
- Oracle 建表SQL实例示范操作指南(oracle建表sql)
- MySQL操作:执行SQL语句(mysql执行sql语句)
- 快速学会PostgreSQL中导入SQL文件(postgresql导入sql文件)
- 操作Oracle 日期数据的SQL操作简易教程(oracle日期sql)
- MySQL实现数据分页的SQL技术(mysql分页sql)
- 语句利用MSSQL执行SQL语句的简单指南(mssql执行sql)
- sql语句精选:Oracle 前十条常用SQL语句.(oracle前十条)
- SQL党进阶必备:轻松转换Oracle数据库教程(sql转oracle)
- 脚本如何在Linux中执行SQL脚本(linux怎么执行sql)
- 提升效率:用MySQL查看SQL代码的性能(mysql查看sql执行效率)
- MySQL实现SQL脚本查询与操作(mysql执行sql脚本)
- 如何利用Oracle掌握SQL写作技巧(oracle写sql格式)
- Oracle内存表使用实例快速提升SQL执行效率(oracle内存表 例子)
- MySQL批量执行SQL脚本,给你快速上手(c mysql批量sql)
- MySQL 上下级 SQL 查询技巧(mysql 上下级sql)
- MySQL与SQL不是同一回事(mysql 不等于sql)
- sql在Oracle中如何执行SQL语句(oracle中 在哪执行)
- Oracle SQL中最多的数量统计实例(oracle sql数量)
- 法Oracle SQL实现乘法运算(oracle sql乘)