public CityForecast[] Get() { CityForecast namurForecast = new CityForecast("namur", 5); CityForecast monsForecast = new CityForecast("mons", 5); return new CityForecast[] { new CityForecast("namur", 5), new CityForecast("mons", 5) }; //return (GetForecastFromDatabase()); }
private CityForecast[] GetForecastFromDatabase() { SqlConnection connection = new SqlConnection(@"Data Source = (LocalDb)\MSSQLLocalDb; Initial Catalog = bobLeServeur; Integrated Security = True; Pooling = False"); SqlCommand cmd = new SqlCommand("SELECT * FROM[Table]", connection); connection.Open(); SqlDataReader reader; reader = cmd.ExecuteReader(); List<CityForecast> forecasts = new List<CityForecast>(); while (reader.Read()) { CityForecast forecast = new CityForecast(); forecast.City = (string)reader["City"]; forecast.Tempe = (decimal)reader["tempe"]; forecasts.Add(forecast); } reader.Close(); connection.Close(); return (forecasts.ToArray()); }