✅ System.Data.SQLiteDatabase .NET 7.0 Reading Items From Database

public static List<GameModel> GetAllGames()
{
    using SQLiteConnection? conn = new(dbFile);
    using SQLiteCommand? cmd = conn.CreateCommand();
    SQLiteDataReader? reader;

    List<GameModel> games = new();

    conn.Open();

    reader = cmd.ExecuteReader();

    while (reader.Read())
    {
        GameModel game = new()
        {
            Id = Convert.ToInt32(reader["Id"].ToString()),
            Username = reader["User"].ToString(),
            Date = reader["Date"].ToString(),
            StartTime = reader["StartTime"].ToString(),
            EndTime = reader["EndTime"].ToString(),
            Duration = reader["Duration"].ToString(),
            Score = Convert.ToInt32(reader["Score"].ToString()),
            Total = Convert.ToInt32(reader["Total"].ToString()),
            Difficulty = reader["Difficulty"].ToString(),
            GameType = reader["GameType"].ToString()
        };

        games.Add(game);
    }

    return games;
}

public static List<GameModel> GetAllGames()
{
    using SQLiteConnection? conn = new(dbFile);
    using SQLiteCommand? cmd = conn.CreateCommand();
    SQLiteDataReader? reader;

    List<GameModel> games = new();

    conn.Open();

    reader = cmd.ExecuteReader();

    while (reader.Read())
    {
        GameModel game = new()
        {
            Id = Convert.ToInt32(reader["Id"].ToString()),
            Username = reader["User"].ToString(),
            Date = reader["Date"].ToString(),
            StartTime = reader["StartTime"].ToString(),
            EndTime = reader["EndTime"].ToString(),
            Duration = reader["Duration"].ToString(),
            Score = Convert.ToInt32(reader["Score"].ToString()),
            Total = Convert.ToInt32(reader["Total"].ToString()),
            Difficulty = reader["Difficulty"].ToString(),
            GameType = reader["GameType"].ToString()
        };

        games.Add(game);
    }

    return games;
}