public List <Year> GetAllYears(string spName, string providerName, string connectionString) { try { return(_DapperRepository.ExecuteStoredProcedure <Year>(spName , providerName, connectionString).ToList()); } catch (Exception ex) { throw ex.InnerException; } }
public async Task <IEnumerable <DTO> > ExecuteStoredProcedure <DTO>(string sql, DynamicParameters parameters) { return(await _dapperRepository.ExecuteStoredProcedure <DTO>(sql, parameters)); }