Terraria.DB.DB C# (CSharp) Method

        public DB()
        {
            SQLiteDataReader tempReader = Load("terraria", "SELECT name, id FROM tiles");
            while (tempReader.Read())
                Tiles.Add(GetString(tempReader, 0), GetInt32(tempReader, 1));

            tempReader = Load("terraria", "SELECT name, id FROM buffs");
            while (tempReader.Read())
                Buffs.Add(GetString(tempReader, 0), GetInt32(tempReader, 1));

            tempReader = Load("terraria", "SELECT id, name_en, name_de, name_it, name_fr, name_es, damageMod, knockbackMod, speedMod, " + 
                "sizeMod, velocityMod, manaCostMod, critStrikeMod, sellValueMod FROM item_prefix");
            while(tempReader.Read())
            {
                ItemPrefix prefix = new ItemPrefix();
                prefix.name.Add(GetString(tempReader, 1));
                prefix.name.Add(GetString(tempReader, 2));
                prefix.name.Add(GetString(tempReader, 3));
                prefix.name.Add(GetString(tempReader, 4));
                prefix.name.Add(GetString(tempReader, 5));
                prefix.damageMod = GetFloat(tempReader, 6);
                prefix.knockBackMod = GetFloat(tempReader, 7);
                prefix.speedMod = GetFloat(tempReader, 8);
                prefix.sizeMod = GetFloat(tempReader, 9);
                prefix.velocityMod = GetFloat(tempReader, 10);
                prefix.manaCostMod = GetFloat(tempReader, 11);
                prefix.critStrikeMod = GetInt32(tempReader, 12);
                prefix.sellValueMod = GetFloat(tempReader, 13);

                ItemPrefixes.Add(GetInt32(tempReader, 0), prefix);
            }

            if (!tempReader.IsClosed)
                tempReader.Close();
            CloseConnections();
        }