public string GetTemplateForStoredProcedure(IDbConnection connection ,string sprocName) { var html = string.Empty; var p = connection.GetStoredProcedureParams(sprocName); html = p.Aggregate(html, (current, param) => { if (DbTypeDictionary.ContainsKey(param.DbType)) { var paramName = default(string); paramName = ParamNameFilter(param.ParameterName.Replace("@", "")); return current + _templateEngine.RenderToString(DbTypeDictionary[param.DbType], new { DbType = param.DbType, UglyName = param.ParameterName.Replace("@", ""), PrettyName = paramName}); } else return current; }); return html; }