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());
}