void importTrainingDays(int oldProfileId, Profile newProfile, SqlCeConnection oldConnection) { Log.WriteInfo("Importing training days for profile id {0}, name{1}", newProfile.Id, newProfile.Name); SqlCeCommand cmd = new SqlCeCommand(); cmd.Connection = oldConnection; cmd.CommandText = "SELECT ID,TrainingDate,Comment FROM TrainingDay WHERE ProfileId=" + oldProfileId; var reader = cmd.ExecuteReader(); Log.WriteInfo("TrainingDay reader executed"); while (reader.Read()) { int oldTrainingDayId = getInt32(reader, "ID").Value; DateTime date = getDateTime(reader, "TrainingDate").Value; Log.WriteInfo("Training day id={0},TrainingDate={1}", oldTrainingDayId, date); TrainingDay day = new TrainingDay(date); day.ProfileId = newProfile.Id; day.Comment = getString(reader, "Comment"); importA6w(day, newProfile, oldTrainingDayId, oldConnection); importStrengthTraining(day, oldTrainingDayId, oldConnection); importSizes(day, oldTrainingDayId, oldConnection); day.CreateAndFlush(); if (day.IsEmpty) { day.Delete(); } Log.WriteInfo("TrainingDay saved"); } Log.WriteInfo("TrainingDay import complete"); }