Example #1
0
        private DapperParameter CreateParameter(IDbDataParameter[] parameters)
        {
            if (!(parameters?.Any() ?? false))
            {
                return(null);
            }

            var dataParameters = new DapperParameter();

            foreach (var parameter in parameters)
            {
                dataParameters.Add(parameter);
            }
            return(dataParameters);
        }
Example #2
0
        /// <summary>
        /// 执行Sql 脚本查询
        /// </summary>
        /// <param name="sql">Sql语句</param>
        /// <param name="parameters">参数</param>
        /// <returns>集合</returns>
        public IEnumerable <T> SqlQuery <T>(string sql, IDbDataParameter[] parameters)
        {
            DapperParameter dataParameters = CreateParameter(parameters);

            return(CurrentConnection.Query <T>(sql, dataParameters, CurrentTransaction));
        }