public async Task <IEnumerable <MSedes> > ListarSedes() { using (SqlConnection sql = new SqlConnection(_connectionString)) { using (SqlCommand cmd = new SqlCommand("usp_ListarSedes", sql)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; var response = new List <MSedes>(); await sql.OpenAsync(); using (var reader = await cmd.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { response.Add(_populate.SetSedes(reader)); } } return(response); } } }