c# dapper帮助类

数据库 为 mysql 如果用sqlserver 直接把代码中的Mysql改成Sql即可
代码片.

public class DapperHelper<T>
    {
   
        /// <summary>
        /// 数据库连接字符串
        /// </summary>
        private static readonly string connectionString ="";

        /// <summary>
        /// 查询列表
        /// </summary>
        /// <param name="sql">查询的sql</param>
        /// <param name="param">替换参数</param>
        /// <returns></returns>
        public static List<T> Query(string sql, object param)
        {
   
            using (MySqlConnection con = new MySqlConnection(connectionString))
            {
   
                return con.Query<T>(sql, param).ToList();
            }
        }

        /// <summary>
        /// 查询第一个数据
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="param"></param>
        /// <returns></returns>
        public static T QueryFirst(string sql, object param)
        {
   
            using (MySqlConnection con = new MySqlConnection(connectionString))
            {
   
                return con.QueryFirst<T>(sql, param);
            }
        }

        /// <summary>
        /// 查询第一个数据没有返回默认值
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="param"></param>
        /// <returns></returns>
        public static T QueryFirstOrDefault(string sql, object param)
        {
   
            using (