.Net快速开发框架-vol-Dapper访问数据库与存储过程

//dapper访问业务库
DBServerProvider.GetSqlDapper().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);

预览地址 http://pro.volcore.xyz/
开源版地址