How do I iterate through a List inside a C# Class?

Hi Tony,

To iterate through the List inside the WeatherResponse object and insert the data for each day into an MS SQL table, you can use a foreach loop. Here's a general outline of how to achieve this, including the SQL insertion logic:

You can use this process.

using System;
using System.Collections.Generic;
using System.Data.SqlClient;

public class WeatherResponse
{
    public string queryCost { get; set; }
    public string latitude { get; set; }
    public string longitude { get; set; }
    public string resolvedAddress { get; set; }
    public string address { get; set; }
    public string timezone { get; set; }
    public string tzoffset { get; set; }
    public List days { get; set; }
}

public class DayInfo
{
    public string datetime { get; set; }
    public string tempmax { get; set; }
    public string tempmin { get; set; }
}

public class Program
{
    static void Main(string[] args)
    {
        // Assuming weatherData is populated from your API call
        WeatherResponse weatherData = GetWeatherDataFromAPI();

        // SQL Connection String
        string connectionString = "your_connection_string_here";

        // Insert each day's data into the MS SQL table
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            conn.Open();

            foreach (DayInfo day in weatherData.days)
            {
                string insertQuery = @"
                    INSERT INTO WeatherTable (DateTime, TempMax, TempMin)
                    VALUES (@DateTime, @TempMax, @TempMin)";
                
                using (SqlCommand cmd = new SqlCommand(insertQuery, conn))
                {
                    cmd.Parameters.AddWithValue("@DateTime", day.datetime);
                    cmd.Parameters.AddWithValue("@TempMax", day.tempmax);
                    cmd.Parameters.AddWithValue("@TempMin", day.tempmin);
                    
                    cmd.ExecuteNonQuery();
                }
            }
        }
    }

    static WeatherResponse GetWeatherDataFromAPI()
    {
        // Your logic to get weather data from API and deserialize into WeatherResponse object
        return new WeatherResponse
        {
            // Sample data for testing
            days = new List
            {
                new DayInfo { datetime = "2024-09-01", tempmax = "30", tempmin = "20" },
                new DayInfo { datetime = "2024-09-02", tempmax = "28", tempmin = "18" }
            }
        };
    }
}

• Iteration: The foreach loop is used to iterate over each DayInfo object in the days list within the WeatherResponse object.
• SQL Connection: Use SqlConnection to connect to your MS SQL database.
• SQL Insertion: For each day, the code inserts the data into the WeatherTable using an INSERT INTO query.
• Parameterization: SqlCommand.Parameters.AddWithValue is used to avoid SQL injection and bind parameters.

Make sure to modify the connection string and table name according to your setup.