Dapper 执行存储过程

使用 Dapper 执行存储过程有两种方法： 使用CommandTypeas Text；或作为StoredProcedure。两者效果一样。

[Route(nameof(QueryByCommandTypeAsText))]
        [HttpGet]
        public async Task<ActionResult> QueryByCommandTypeAsText()
        {//使用CommandTypeas Text
            var sql = "exec [Sales by Year] @Beginning_Date,@Ending_Date";
            var values = new { Beginning_Date = "1998-1-1", Ending_Date = "1998-12-30" };
            using (var con = new SqlConnection(MyConfig.ConnectionString))
            {
                var reuslts =await con.QueryAsync(sql, values);
                return Ok(reuslts);
            }
        }
        [Route(nameof(QueryByCommandTypeAsStoredProcedure))]
        [HttpGet]
        public async Task<ActionResult> QueryByCommandTypeAsStoredProcedure()
        {//使用CommandTypeas StoredProcedure
            var procedure = "[Sales by Year]";
            var values = new { Beginning_Date = "1998-1-1", Ending_Date = "1998-12-30" };
            using (var con = new SqlConnection(MyConfig.ConnectionString))
            {
                var reuslts = await con.QueryAsync(procedure, values,commandType: CommandType.StoredProcedure);
                return Ok(reuslts);
            }
        }