public void UpdateAllLocationInfo() { MySqlUtil mySqlUtil = new MySqlUtil(_mysqlConStr); List <string> needUpdateVillages = mySqlUtil.GetVillagesWithoutLocation(); List <LocationInfo> locationInfos = new List <LocationInfo>(); foreach (string village in needUpdateVillages) { LocationInfo locationInfo = GetNewVillageLocation(village); if (locationInfo != null && locationInfo.VillageName != null) { locationInfos.Add(locationInfo); } } mySqlUtil.InsertLocationInfos(locationInfos); }