VS2017一步一步断点调试解决Dapper语句出现的Bug

最近再做一个项目，出现一个小bug，bug虽小，但是却要命啊。下面我show下我解决问题的方法。

View层代码：

@model List<mhq.Blog.Model.Blog>

<blockquote class="layui-elem-quote">文章管理</blockquote>

<div style="padding:10px;">

    <div>

        <a class="layui-btn" href="~/Admin/Blog/Add">

            <i class="layui-icon"></i> 添加

        </a>

    </div>

    <table class="layui-table">

        <thead>

            <tr>

                <th>发布时间</th>

                <th>boke标题</th>

                <th>所属分类</th>

                <th>访问量</th>

                <th>排序号</th>

                <th>管理</th>

            </tr>

        </thead>

        <tbody>

            @foreach (var blog in Model)

            {

            <tr>

                <td>@blog.createdate.ToString("yyyy-MM-dd HH:mm")</td>

                <td>@blog.title</td>

                <td>@blog.caname</td>

                <td>@blog.visitnum</td>

                <td>@blog.sort</td>

                <td>

                    <a style="margin-right:20px" href="~/Admin/Blog/Add/@blog.id">

                        <i class="layui-icon"></i>

                        编辑

                    </a>

                    <a href="javascript:void()0;" onclick="del(@blog.id)">

                        <i class="layui-icon"></i>

                        删除

                    </a>

                </td>

            </tr>

            }

        </tbody>

    </table>

</div>

<script>

    /* 删除*/

    function del(id) {

        layui.use('layer', function () {

            var layer = layui.layer;

            var $ = layui.jquery;

            layer.confirm("是否确认删除？", function () { 

                var url = "/Admin/Blog/Del/" + id;

                $.post(url, function (data) {

                    layer.alert(data, function () { location.reload(); });

                })

            })

        })

    }

</script>

Controller层代码：

 public IActionResult Index()

        {

            List<Model.Blog>  list = dal.GetList(" 1=1 order by sort asc,id desc");

            return View(list);

        }

Dal层代码：

        /// <summary>

        /// 查询

        /// </summary>

        /// <param name="cond">查询条件</param>

        /// <returns></returns>

        public List<Model.Blog> GetList(string cond)

        {

            // Dapper – Simple List

            using (var connection = ConnectionFactory.GetOpenConnection())

            {

                string sql = "select * from blog ";

                if (!string.IsNullOrEmpty(cond))

                {

                    sql=sql+$" where{cond}";

                }

                var list = connection.Query<Model.Blog>(sql).ToList();

                return list;

            }

        }