public async Task <List <RouletteState> > ListRoulettes(int id) { SqlDataReader result; List <SqlParameter> _listParameter = new List <SqlParameter>(); _listParameter.Add(_baseData.GetParameter("idRulette", id)); result = await _baseData.GetDataReaderAsync("sp_ListRoulettes", _listParameter); List <RouletteState> _listRouletteState = new List <RouletteState>(); while (result.Read()) { RouletteState _rouletteState = new RouletteState(); _rouletteState.IdRoulette = Convert.ToInt32(result["idRoulette"]); _rouletteState.State = Convert.ToString(result["state"]); _listRouletteState.Add(_rouletteState); } return(_listRouletteState); }