Dapper 访问数据库与存储过程

public void Test()
{

    //dapper访问业务库
    DBServerProvider.GetSqlDapper<TestDb>().xx //TestDb任意业务库的model即可调用对应的数据库


    //参数化查询
    string tranNo = "T20001000100001";
    int orderType = 1;
    string sql = "select * from SellOrder where TranNo=@tranNo and OrderType=@orderType";
    //与原生dapper使用方式基本一致，更多使用方法参照dapper文档
    DBServerProvider.SqlDapper.QueryList<SellOrder>(sql, new { tranNo, orderType });
    DBServerProvider.SqlDapper.QueryFirst<dynamic>(sql, new { tranNo, orderType });
    DBServerProvider.SqlDapper.QueryFirst<object>(sql, new { tranNo, orderType });

    //参数化查询2
    string sql = "select * from SellOrder where TranNo=@tranNo and OrderType=@orderType";
    DynamicParameters parameters = new DynamicParameters();
    parameters.Add("tranNo", tranNo);
    parameters.Add("orderType", orderType);
    DBServerProvider.SqlDapper.QueryList<SellOrder>(sql, parameters);

    //还可以调用调用存储过程接收output参数
     DynamicParameters parameters = new DynamicParameters();
     parameters.Add("tranNo", tranNo);
     parameters.Add("message", direction: ParameterDirection.Output);
     var val= DBServerProvider.SqlDapper.ExecuteScalar("存储过程", parameters,System.Data.CommandType.StoredProcedure);
     object result= parameters.Get<object>("message");//ExecuteScalar执行后就可以接着获取存储过程output参数message
   
   //返回查询结果的第一行第一列字段的值
    DBServerProvider.SqlDapper.ExecuteScalar(sql, new { tranNo, orderType })

    //in查询
    string sql = "select * from SellOrder where id in @ids";
    var ids=new int[]{200,800,100}
    DBServerProvider.SqlDapper.QueryFirst<object>(sql, new {ids=ids });

    //模糊查询
    string tranNo = "20";
    string sql = $"SELECT * FROM SellOrder WHERE TranNo LIKE @tranNo";
    var orderList =  DBServerProvider.SqlDapper.QueryList<SellOrder>(sql, new { Name = "%" + tranNo + "%" });

    //根据id删除数据
    DBServerProvider.SqlDapper.DelWithKey<Sys_User>(new int[] { 1,2,3});

    //多表查询
    string sql = @"select * from sys_user; select * from sys_role;";

    //多表查询1
    var result = DBServerProvider.SqlDapper.QueryMultiple<Sys_User, Sys_Role>(sql, new { });
    List<Sys_User> users = result.Item1;
    List<Sys_Role> roles = result.Item2;

    //多表查询2
    var result = DBServerProvider.SqlDapper.QueryMultiple<object, object>(sql, new { });
    List<object> users = result.Item1;
    List<object> roles = result.Item2;

    //多表查询3
    var result = DBServerProvider.SqlDapper.QueryDynamicMultiple2(sql, new { });
    var users = result.Item1;
    var roles = result.Item2;
    //其他多表查询还支持同时返回3、4、5表，参照上面Query方法使用

      //返回sql执行影响的行数
     string sql = @"update table set name=xx where id=xx ";
     int result= DBServerProvider.SqlDapper.ExcuteNonQuery(sql, new { });

     //返回查询结果的第一行第一列字段的值
     string sql = @"select count(1) from table where id=xx ";
     object value= DBServerProvider.SqlDapper.ExecuteScalar(sql, new { });

    //调用存储过程
    DBServerProvider.SqlDapper.ExecuteScalar("存储过程名", new {参数 },System.Data.CommandType.StoredProcedure);

    //更多使用方法或者参数配置见原生dapper文档

}