使用SqlSugar执行sql语句

1.简单查询

SqlSugarClient db = SugarContext.GetInstance();//执行sql语句，处理//1.执行sql，转成listList
     
       list1 = db.SqlQuery
      
       ("select * from teacher where tsex=@tsex", new { tsex = "女" });Console.WriteLine(list1.ToJsonString());//2.转成dynamicdynamic list2 = db.SqlQueryDynamic("select * from UserInfo");Console.WriteLine(list2.Length);//3.转成json数据string list3 = db.SqlQueryJson("select * from UserInfo");Console.WriteLine(list3);//4.返回intint count = db.SqlQuery
       
        ("select count(*) from UserInfo").FirstOrDefault();Console.WriteLine(count);//5.返回键值对类型Dictionary
        
          list4 = db.SqlQuery
         
          
           >("select UserID,Name from UserInfo") .ToDictionary(q => q.Key, q => q.Value);Console.WriteLine(list4.ToJsonString());//6.返回List
           
             集合List
            
              list5 = db.SqlQuery
             
              ("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
     
       list1 = db.SqlQuery
      
       ("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
       
         list2 = db.SqlQuery
        
         ("exec proc_PageStudent @pageStart,@pageEnd,@recordCount output", pars);db.IsClearParameters = true;//启用自动清空参数var recordCount = pars[2].Value;Console.WriteLine(list2.ToJsonString());Console.WriteLine(recordCount);
        
       
      
     

 

更多参考：