webapi整合dapper、swagger发布restful风格服务

一、NuGet工具下载Dapper、Swashbuckle.AspNetCore.Swagger等相关依赖，创建的项目中会自动生成相关代码，具体配置网上有很多，请自行搜索。
二、使用dapper读取数据库，自动映射到对象中。

  /// <summary>
        /// 读取数据表解释
        /// </summary>
        /// <returns></returns>
        public List<CommentEntity> findCommentByTableName(string tablename)
        {

            List<CommentEntity> result = null;

            using (IDbConnection connection = new MySqlConnection(IOTX.DbHelper.MySQLCommon.SQLConnectionString))
            {
                var dynamicParams = new DynamicParameters();
                ///查询，输入条件不为空，增加到where条件中去
                var sql = @"select COLUMN_NAME, column_comment from information_schema.columns where table_schema = database() and table_name = @tablename ";
                dynamicParams.Add("@tablename", tablename);

                ///dapper查询
                var data = connection.Query<CommentEntity>(sql, dynamicParams);

                result = data.ToList();
            }

            return result;
        }

三、返回restful风格数据

  /// <summary>
        /// 数据分析-环境数据表列名解释查询
        /// </summary>
        /// <returns>数据分析-环境数据表列名解释查询</returns>
        [HttpGet]
        public IHttpActionResult findZhjc_weatherComment()
        {
            IOTX.DataAccess.DataAnalysisProvider dao = new IOTX.DataAccess.DataAnalysisProvider();
            List<Entity.CommentEntity> query = dao.findCommentByTableName("Zhjc_weather");

            Dictionary<string, object> list = ResultHelper.Do(query, query.Count);
            return Ok(list);
        }