/// <summary> /// Import a given list of climate stations into the database /// </summary> /// <param name="dataAccess">Database Access object (e.g. SqliteDataAccess)</param> /// <param name="stations">List of Station objects</param> private static void ImportStationsIntoDatabase(IDatabaseAccess dataAccess, List <Station> stations) { if (!dataAccess.StationsDbExists()) { dataAccess.CreateStationsDb(); } var districtNames = stations.Select(station => station.FederalState.FederalStateName).Distinct().ToList(); foreach (var districtName in districtNames) { dataAccess.SaveFederalState(new FederalState(districtName)); } foreach (var station in stations) { dataAccess.SaveStation(station); } }