Sakuno.KanColle.Amatsukaze.Game.Services.Records.ExperienceRecords.Load C# (CSharp) Method

        protected override void Load()
        {
            using (var rCommand = Connection.CreateCommand())
            {
                rCommand.CommandText = "SELECT experience FROM admiral_experience ORDER BY time DESC LIMIT 1;";

                r_Admiral = Convert.ToInt32(rCommand.ExecuteScalar());
            }
            using (var rCommand = Connection.CreateCommand())
            {
                rCommand.CommandText = "SELECT id, experience FROM ship_experience GROUP BY id;";

                using (var rReader = rCommand.ExecuteReader())
                    while (rReader.Read())
                    {
                        var rID = Convert.ToInt32(rReader["id"]);
                        var rExperience = Convert.ToInt32(rReader["experience"]);

                        r_Ships.Add(rID, rExperience);
                    }
            }
        }